SAPDBA: Export/import (SAP Library - Database Administration (Oracle) with SAPDBA)

SAPDBA: Export/import

	Export/import
a	- Export - tables and indexes including data
b	- Export - structures of tables and indexes
c	- Export - constraints, synonyms, sequences, views, grants
d	- Import - tables and indexes including data
e	- Import - structures
r	- Restart
q	- Return

The SAPDA function Export/import allows you to carry out the following actions:

Export of database objects

You can export tables with their data, table and index definitions, and with other database objects such as constraints, grants, views, synonyms and sequences.

Import of objects in the database which have earlier been exported.

You can find a description of the various types of export under

Export Types.

In SAPDBA: Export Menu you can choose one of the following methods (tools) for the data transport:

ORACLE export / ORACLE import (SAPDBA default)

SAP unload / ORACLE SQL*Loader (from ORACLE 7.2)

SAP unload / SAP load

One advantage of using the tool SAP unload/load, ORACLE SQL*Loader is the significant reduction in the length of time the data transport takes (up to 50%) in comparison to ORACLE export/import. For other advantages of this method see SAP Unload/Load, SQL*Loader.

The so-called structure export (without data) of table definitions and index definitions, and of constraints, grants, views, synonyms and sequences, and their import (structure import) is not carried out with the tools described above, but with SAPDBA-internal methods.

In the following the terms export/import stand for the data transport procedure in general without specifying a particular method.

In order to accelerate the data transport process you can perform the export and the import processes in parallel:

Parallel Export/Import