Oracle??™s Data Pump Export utility queries the database, including the data dictionary, and
writes the output to an XML file called an export dump file. You can export the full database,
specific users, tablespaces, or specific tables. During exports, you may choose whether or not
to export the data dictionary information associated with tables, such as grants, indexes, and
constraints. The file written by Data Pump Export will contain the commands necessary to
completely re-create all the chosen objects and data.
Once data has been exported via Data Pump Export, it may be imported via the Data Pump
Import utility. Data Pump Import reads the dump file created by Data Pump Export and executes
the commands found there. For example, these commands may include a create table command,
followed by an insert command to load data into the table.
O
Chapter 11: Backup and Recovery Options 393
NOTE
Data Pump Export and Import can use a network connection for
a simultaneous export and import operation, avoiding the use of
intermediate operating system files and reducing total export and
import time.
The data that has been exported does not have to be imported into the same database, or the
same schema, as was used to generate the export dump file. You may use the export dump file to
create a duplicate set of the exported objects under a different schema or in a separate database.
You can import either all or part of the exported data.
Pages:
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612