Prerequisites for Export and Import (SAP Library - Database Administration (Oracle) with SAPDBA)

Prerequisites for Export and Import

To ensure a successful export and import, make sure that the following conditions are met:

Storage space in the dump directory/on tape: The file systems or tapes to which the export dump files are written must have sufficient storage space to hold the objects for export. SAPDBA checks whether the contents of the objects to be exported fit in the directories or onto the tapes, and issues a warning if they are too large.

If the parameter exp_imp_degree is > 1, then this represents the number of processes that execute in parallel. SAPDBA tries to distribute the tables equally across the specified directories/tapes.

Tapes can only be used when implementing ORACLE export/ import, however not when implementing SAPunload/load and SQL*Loader.

Tablespace: Before you import tables, you must make sure that the tablespaces to which the tables and the indexes belong exist.

The import script contains all commands for creating tables and the indexes, and for importing data, but not the commands for recreating any tablespaces.

SAP indexes are generally held in tablespaces - on separate disks - other than those of the tables to which they refer.

Storage space: The tablespaces must have enough free storage space to hold the table and the indexes. In contrast to reorganization, SAPDBA does not check whether the import into the database will run successfully.