Importing Tables and Indexes Including Data (SAP Library - SAP Database Guide: Oracle (BC-DB-ORA-DBA))

Importing Tables and Indexes Including Data

Use

You can use SAPDBA for Oracle to import one or more tables and indexes, including constraints, comments, and grants. SAPDBA created the required scripts for the import when you performed Exporting Tables and Indexes Including Data. Therefore, the import uses the same settings used for the export.

Caution

You can not use data from an import to restore the database. This is because exported data is a logical backup, which is static. You can only restore the database with a proper backup. For more information, see Database Restore and Recovery with SAPDBA.

Prerequisites

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

You have completed the Preparations for Export and Import.

You have shut down the Oracle database and then started it in restricted session mode.

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

Procedure

Choose Export/Import ® Import tables and indexes including data.

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>.exd .

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.

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.