Database Reference
In-Depth Information
To use a parameter file, first create an OS text file that contains the commands you want to use to control the
behavior of your job. This example uses the Linux/Unix
vi
command to create a text file named
exp.par
:
$ vi exp.par
Now, place the following commands in the
exp.par
file:
userid=mv_maint/foo
directory=dp_dir
dumpfile=exp.dmp
logfile=exp.log
tables=inv
reuse_dumpfiles=y
Next, the export operation references the parameter file via the
PARFILE
command line option:
$ expdp parfile=exp.par
Data Pump processes the parameters in the file as if they were typed on the command line. If you find yourself
repeatedly typing the same commands or using commands that require quotation marks, or both, then consider using
a parameter file to increase your efficiency.
■
Don't confuse a Data pump parameter file with the database initialization parameter file. a Data pump parameter
file instructs Data pump as to which user to connect to the database as, which directory locations to read/write files to
and from, what objects to include in the operation, and so on. In contrast, a database parameter file establishes
characteristics of the instance upon database startup.
Tip
Exporting and Importing with Granularity
Recall from the section “Data Pump Architecture,” earlier in this chapter, that there are several different modes in
which you can invoke the export/import utilities. For instance, you can instruct Data Pump to export/import in the
following modes:
•
Entire database
•
Schema level
•
Table level
•
Tablespace level
•
Transportable tablespace level
Before diving into the many features of Data Pump, it's useful to discuss these modes and ensure you're aware of
how each operates. This will further lay the foundation for understanding concepts introduced later in the chapter.
