Exporting Structures of Tables and Indexes (SAP Library - SAP Database Guide: Oracle (BC-DB-ORA-DBA))

Exporting Structures of Tables and Indexes

Use

You can use SAPDBA for Oracle to export structures of tables and indexes. Structures are the table and index definitions.

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>.exs file. For more information, see SAPDBA Log Files and Their Contents.

Procedure

Choose Export/Import ® Export structures of tables and indexes.

Enter the objects that you want to export by specifying one of the following names:

Tablespace – the structures of all tables or indexes in the chosen tablespace are exported

Owner – the structures of all tables and indexes belonging to the owner are exported

Table – the structures of the chosen table and its indexes are exported

Note

To export Oracle system objects, choose Owners, then enter all . In reply to the prompt Including owners SYS and SYSTEM, enter y for yes.

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

Enter the required storage parameters under Storage parameters.

Choose Start to prepare for the export.

SAPDBA prepares for the export by:

Checking for space in the dump file

Generating the:

<timestamp> subdirectory in the working directory

<timestamp>.exs log

The scripts and parameter files listed below, including one to perform the import later

restart.exs file for restart in the <timestamp> subdirectory

SAPDBA creates the following scripts and parameter files:

tab<TSP>.sql

ind<TSP>.sql

con<TSP>.sql

grants.sql

restart.exs

Choose how to start the export:

Immediately in the foreground
In the background
Not now, but possibly later

Note

If you start the export in the background, tables generated after the export scripts have been created are not exported.

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.