8.3 Migrating Oracle R Enterprise Data

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

The source and target must have the same version of the Oracle Database and of Oracle R Enterprise 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 R Enterprise user data to a dump file.

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

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

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