Export with SAPDBA (SAP Library - SAP Database Guide: Oracle (BC-DB-ORA-DBA))

Export with SAPDBA

Use

This section tells you how to export database objects with SAPDBA for Oracle.

Prerequisites

You have completed Preparations for Export and Import.

Caution

If SAPDBA uses the Oracle export program for a tape export, write errors are possible that the Oracle export cannot recognize. Therefore, to prevent data loss, be sure to:

Back up the data before starting a tape export

Use the SAPDBA option CheckExp: yes when exporting

In general, an export to disk causes fewer errors than one to tape.

Procedure

You perform the type of export that you identified during the preparations:

Exporting Tables and Indexes with Data

Exporting Structure of Tables and Indexes

Exporting Constraints, Synonyms, Sequences, Views, Grants