Preparations for Export and Import 

Use

This section describes the preparations necessary for an export and import with SAPDBA for Oracle.

You have chosen an export type.

1. You decide if you want to perform a parallel export and import.
2. You check storage space in the dump directory or 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 export is running in parallel – that is, if the value of exp_imp_degree is greater than 1 and you have specified multiple dump destinations (disk directories or tapes) – SAPDBA tries to distribute the exported objects equally across the specified directories or tapes.

3. You check that the target tablespaces exist.

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.

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

4. You check storage space in the target tablespaces.