Entering content frameObject documentation Types of Export and Import Locate the document in its SAP Library structure

Definition

The section describes the types of export and import that you can perform with SAPDBA for Oracle. For more information, see Export and Import of Database Objects with SAPDBA.

Use

There are the following types of export and import:

Export and Import Type Descriptions

Type

How to Export

How to Import

Tables with indexes and data

Choose Export tables and indexes including data.

Choose Import tables and indexes including data.

Definitions for tables and indexes

Choose Export structures of tables and indexes.

Choose Import structures.

Constraints, synonyms, sequences, views, and grants

Choose Export constraints, synonyms, sequences, views, grant.

Choose Import structures.

The following table gives an overview of the individual data and application flows:

Export and Import Procedures

Objects for Export

Procedure

Tables with indexes and data

SAPDBA exports the table(s) you specify with their indexes and data. Indexes are exported even if they are not in the same tablespace as the associated table. SAPDBA also exports all constraints, comments and grants of the selected tables.

You can optionally modify the parameters INITIAL , NEXT , MINEXTENTS , MAXEXTENTS , PCTFREE , PCTUSED and FREELISTS or have SAPDBA automatically calculate the value for the INITIAL and NEXT parameters ( PCTINCREASE is always set to 0).

SAPDBA creates import scripts that are used by SAPDBA for importing the data.

Definitions for tables and indexes

SAPDBA creates an import script that can be used to recreate definitions of tables and indexes that you specify. If you store table definitions, the index definitions referring to the tables are also stored, even if the indexes are stored in another tablespace than the tables.

Definitions contain table and column comments, constraints, and grants.

You can optionally modify the parameters INITIAL , NEXT , MINEXTENTS , MAXEXTENTS , PCTFREE , PCTUSED and FREELISTS or have SAPDBA automatically calculate the value for the INITIAL and NEXT parameters ( PCTINCREASE is always set to 0).

Constraints, grants, synonyms, sequences, and views

SAPDBA creates an import script that can be used to recreate these objects. The export is performed globally: all constraints, grants, synonyms, sequences, and views of the database are included (you can optionally exclude objects of users SYS and SYSTEM from this process by using incl.owners SYS/SYSTEM: no).

 

 

Leaving content frame