Database Backup   «Prev 

Running export using Interactive export in Oracle

Export utility

The Export utility provides a simple way for you to transfer data objects between Oracle databases, even if they reside on platforms with different hardware and software configurations. When you run Export against an Oracle database, objects (such as tables) are extracted, followed by their related objects such as
  1. indexes,
  2. comments, and
  3. grants.
The extracted data is written to an Export file, as illustrated in Figure 1.

Export Database
Figure 1 - Exporting a Database

1) This starts Export in interactive mode and includes the entry of the interactive export options.
This starts Export in interactive mode and includes the entry of the interactive export options.

2) This displays the beginning of your database export.
This displays the beginning of your database export.

3) Displays the SCOTT AND DEMO tables being exported
Displays the SCOTT AND DEMO tables being exported.

4) This displays the end of export after all tables have been exported
This displays the end of export after all tables have been exported.