Export Options for Tables and Indexes 

Procedure

  1. Start up the database system. You can make this export while the database and the R/3 System are active. This does not affect other users.
  2. Choose the SAPDBA for export option for table and index definitions (Export structures of tables and indexes); the following menu appears:

a

- Tablespaces

b

- Owners

c

- Tables

d

- Working directory

g

- Storage parameters

 

ComprExt

 

SAP-NEXT

 

ReduceOb

 

Manually

s

- Start

q

- Return

  1. Specify the tables and indexes that you want to export. Do this by the tablespace name, its owner or the table name. Make any other settings that you want. (see SAPDBA: Export Menu).
  2. Start the export. SAPDBA starts the Oracle program Export. Import scripts are generated that contain the appropriate table and index definitions. SAPDBA creates the restart file restart.exs and the log <timestamp>.exs . If there is an error you musst repeat the export of the structure. You can use the scripts in restart.exs to start an import of the objects later. If there are errors during the import you can repeat it using the restart function. (see Restarting the Export/Import).
  3. If you need to re-import the definitions, use the SAPDBA function Import structures. You can start the appropriate scripts manually. Use the SAPDBA function Additional functions ® Execute SQL script. for the SQL scripts.

The import does not overwrite any definitions that already exist in the database (see Data Consistency and Structure Import).

Script Categories

In an export of table and index definitions, the following scripts are used or created for a later import or restart:

See Restart File for Export/Import and SAPDBA Scripts and Files