In LSH Version 2.2, The Oracle LSH export and import 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.
Note: This utility imports and exports metadata. To export data out
of Oracle LSH, use Oracle LSH Data Marts. See "Defining Data Marts".
The following objects are not exported:
> All validation supporting information including all supporting outputs and
supporting documents.
> The classification hierarchy assigned to any object. On import, the default of the
target Oracle LSH instance's classification is used for that object type.
> The subtype of any object. On import the default subtype of the target Oracle
LSH instance is used for each object type.
> Checkin and checkout comments.
> Execution and Work Area installation data (jobs, outputs, data).
> All other object types: Adapter Domains, Adapter Areas, Workflows, Report Sets,
Data Marts.
> Other Oracle LSH metadata: Users, User Groups, Roles, Subtypes, Adapter
Security, Database Accounts, Remote Locations and Connections, Service
Locations, Hierarchies, Terms, and Subtypes.
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.
Note: This utility imports and exports metadata. To export data out
of Oracle LSH, use Oracle LSH Data Marts. See "Defining Data Marts".
The following objects are not exported:
> All validation supporting information including all supporting outputs and
supporting documents.
> The classification hierarchy assigned to any object. On import, the default of the
target Oracle LSH instance's classification is used for that object type.
> The subtype of any object. On import the default subtype of the target Oracle
LSH instance is used for each object type.
> Checkin and checkout comments.
> Execution and Work Area installation data (jobs, outputs, data).
> All other object types: Adapter Domains, Adapter Areas, Workflows, Report Sets,
Data Marts.
> Other Oracle LSH metadata: Users, User Groups, Roles, Subtypes, Adapter
Security, Database Accounts, Remote Locations and Connections, Service
Locations, Hierarchies, Terms, and Subtypes.
No comments:
Post a Comment