Using Data Pump Export and Import
Introduced with Oracle Database 10g, Data Pump provides a server-based data-extraction and
data-import utility. Its features include significant architectural and functional enhancements over
the original Import and Export utilities. Data Pump allows you to stop and restart jobs, see the
status of running jobs, and restrict the data that is exported and imported.
NOTE
Data Pump files are incompatible with those generated from the
original Export utility.
Data pump runs as a server process, benefiting users in many ways. The client process that
starts the job can disconnect and later reattach to the job. Performance is enhanced (as compared
to the original export/import) because the data no longer has to be processed by a client program.
Data Pump extractions and loads can be parallelized, further enhancing performance.
In this chapter, you will see how to use Data Pump, along with descriptions and examples of
its major options; a more thorough treatment of Data Pump (and more examples) in the context
of large database management can be found in Chapter 16, ???Managing Large Databases.???
Creating a Directory
Data Pump requires you to create directories for the datafiles and log files it will create and read.
Use the create directory command to create the directory pointer within Oracle to the external
directory you will use. Users who will access the Data Pump files must have the READ and
WRITE privileges on the directory.
Pages:
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617