Export Types (SAP Library - Database Administration (Oracle) with SAPDBA)

Export Types

You can use the Export/import function to carry out three types of export procedure:

Export of tables with their indexes and their data (rows). Other database objects, such as constraints and grants, are also contained in this export. For this export use the menu item Export tables and indexes including data. To import this data, use Import tables and indexes including data.

Export of table and index definitions (structure export). For this export use the menu item Export structures of tables and indexes. To import this data, use Import structures.

Export constraints, synonyms, sequences, views, and grants from a database (structure export). For this export, use the menu item Export constraints, synonyms, sequences, views, grants. To import this data, use Import structures.

The following table gives an overview of the individual data/application flows.

Description of Export Types

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 their table(s). SAPDBA 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.
Tables/index definitions	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 by SAPDBA to recreate these objects. The export is carried out 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).