7.3 Migrate Oracle Machine Learning for R Data

Oracle Machine Learning for R Server includes migration scripts that you can run to migrate the RQSYS schema and Oracle Machine Learning for R user data from a source database to a target database

The source and target must have the same version of the Oracle AI Database and of Oracle Machine Learning for R Server.

To locate the scripts, navigate to the server directory and change to the migration subdirectory.

/oreserver_install_dir/server/migration

The migration subdirectory contains a README and the following subdirectories:

• exp — contains the script ore_srcexport.pl for exporting the RQSYS schema and all Oracle Machine Learning for R user data to a dump file.

• imp — contains the script ore_destimport.pl for importing the RQSYS schema and all Oracle Machine Learning for R user data from the dump file created by ore_screxport.pl.

• oreuser — contains scripts for exporting and importing data for a specific Oracle Machine Learning for R user.

Instructions for running the migration scripts are provided in the README.