Importing Structures (SAP Library - SAP Database Guide: Oracle (BC-DB-ORA-DBA))

Importing Structures

Use

You can use SAPDBA for Oracle to import structures. SAPDBA creates the required scripts for the import when you perform Exporting Structures of Tables and Indexes and Exporting Constraints, Synonyms, Sequences, Views, and Grants. Therefore, the import uses the settings you made for the export.

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 import in the <timestamp>.ims file. For more information, see SAPDBA Log Files and Their Contents.

Procedure

Choose Export/Import ® Import structures of database objects.

SAPDBA displays the:

Working directory

This is the working directory for the import. 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).

Import subdirectory

This is the subdirectory <timestamp> that contains the import scripts. This information is based on the last export performed. Compare this information with that in the appropriate export log <timestamp>.exs or <timestamp>.exg .

Function

This shows the type of import to be performed, based on the type of the last export.

If required, change the Working directory or Import subdirectory .

Choose Show import plan to check the import plan before you start.

Choose Start to start the import, or Start in batch to execute the import in the background.

If there are potential problems with the import, SAPDBA warns you, so that you can stop the import.

Choose Start to start the import, or Start in batch to execute the import in the background.

If there are potential problems with the import, SAPDBA warns you, so that you can stop the import.

Result

SAPDBA performs the import and displays a confirmation message.

If an error occurs, SAPDBA displays an error message. You can restart the import after fixing the problem.