Databases Reference
In-Depth Information
All the
filtered
objects
(
C
) to be exported were saved in the dump file along with
their
dependent
objects
(
B
). If you change the command line with the following, it
will prevent all the indexes being exported:
$ expdp hr/hr dumpfile=default_dp_dest:EmpDeptNoIndexes
tables=EMPLOYEES,DEPARTMENTS exclude=INDEX:\”LIKE \'\%\'\”
logfile=default_log_dest:EmpDeptNoIndexes
As can be seen, the
exclude
or
include
clause is actually a
where
predicate.
Use of parameter file
Using a parameter file simplifies an otherwise
complex
to
write
command line, it
also allows the user to define a library of repeatable operations, even for simple
exports. As previously seen, if a filtering (object or row) clause is used—some extra
operating system escape characters are required. By writing the filtering clauses
inside a parameter file, the command line can be greatly simplified.
Comparing this command line (
A
) against the previously exposed command lines,
it can be seen that it is more readable and manageable. The
SHParFile.dpp
file from
the example contains these command options:
Search WWH ::
Custom Search