Exporting Constraints, Synonyms, Sequences, Views, and Grants (SAP Library - SAP Database Guide: Oracle (BC-DB-ORA-DBA))

Exporting Constraints, Synonyms, Sequences, Views, and Grants

Use

You can use SAPDBA for Oracle to export the following items for the entire database:

Constraints

Object requirements, such as interval of values allowed for a field

Synonyms

Secondary identifications of defined database objects, such as official synonyms for views (that is, Oracle Dictionary views)

Sequences

Number intervals that, among other things, are used by SAP for certain network synchronization functions

Views

Selections of data (can be from different tables) according to certain criteria

Grants

Authorizations for using database objects

Prerequisites

You have configured and started SAPDBA. Refer to Getting Started with SAPDBA.

You have completed the Preparations for Export and Import.

You have started the database. The export does not affect other users and can be performed while the SAP System is running.

SAPDBA logs the export in the <timestamp>.exg file. For more information, see SAPDBA Log Files and Their Contents

All user objects – and if necessary system objects – are exported

Procedure

Choose Export/Import ® Export constraints, synonyms, sequences, views, grants.

Select whether you want to include the owners SYS and SYSTEM .

Enter the Working directory.

This is the working directory for the export. The default is <SAPDATA_HOME>/sapreorg or <SAPREORG> , based on the environment variable SAPREORG . Logs and scripts are saved in this directory. For more information on <SAPREORG> , see Environment Variables (UNIX) and Environment Variables (Windows NT).

Choose Start to start the export.

SAPDBA performs the export, creating the following scripts and parameter files:

cssvg<DBSID>.sql

restart.exg

Result

On successful completion, SAPDBA displays a confirmation message.

If there has been an error, SAPDBA displays the appropriate error message. You can restart the export after fixing the problem.

If necessary, you can import the exported data. You can also import structures singly using SQL scripts.

Note

Constraint import command

Constraints are imported using commands with the form ALTER TABLE <owner>.<table name> ADD (<table constraint A>, <table constraint B>, ...

Sequence counter

Sequences are exported with their counters, the last number used in every sequence. Therefore, you should only export and import sequences along with the data that they refer to.

Views

The complete specifications of all views are included in an export. The export includes view columns, comments, grants, and inspection options (constraints with category V).