About Exporting and Importing Objects

The Oracle Life Sciences Data Hub export and import utility (also called the release utility) allows you to export all or part of a single Domain to a file and then read from the file to import the included objects to an Oracle LSH instance—either the same one or a different one—for example, to:

• Set up a new Oracle LSH instance within your organization.
• Make an Oracle LSH application that you developed available to others.
• Provide upgrades to previously imported objects.

The export and import utility includes three scripts:

• cdrruexport.sql exports objects to a file.
• cdrruimport.sql imports objects from a file.
• cdrruwainstall.sql installs imported objects.

The scripts are stored in the following location by default:

$CDR_TOP/patch/115/sql/script_name.sql

You must run these scripts from the command line on the computer where the Oracle LSH database server is installed. There is no user interface to run these scripts.

• Required Setup
  Each script requires access to a local directory on the database server machine from within SQL*Plus.
• Required Oracle Life Sciences Data Hub User Roles
  Although you run the scripts as the user apps, each script has input parameters requiring the username and password of an Oracle LSH user account with certain privileges.