Data Pump - Oracle RMAN for Absolute Beginners - page 246

Data Pump Legacy Mode
This feature is covered last in this chapter, but it's quite useful, especially if you're an old-school DBA. As of Oracle 11g
Release 2, Data Pump allows you to use the old exp and imp utility parameters when invoking a Data Pump job. This is
known as legacy mode, and it's a great feature.
You don't have to do anything special to use legacy mode Data Pump. As soon as Data Pump detects a legacy
parameter, it attempts to process the parameter as if it were from the old exp / imp utilities. You can even mix and
match old legacy parameters with newer parameters; for example,

$ expdp mv_maint/foo consistent=y tables=inv directory=dp_dir

In the output, Data Pump indicates that it has encountered legacy parameters and gives you the syntax for what it
translated the legacy parameter to in Data Pump syntax. For the previous command, here is the output from the Data
Pump session that shows what the consistent=y parameter was translated into:

Legacy Mode Parameter: "consistent=TRUE" Location: Command Line,
Replaced with:
"flashback_time=TO_TIMESTAMP('2014-01-25 19:31:54', 'YYYY-MM-DD HH24:MI:SS')"

This feature can be extremely handy, particularly if you're really familiar with the old legacy syntax and wonder
how it's implemented in Data Pump.
I recommend that you try to use the newer Data Pump syntax whenever possible. However, you may run into
situations in which you have legacy exp / imp jobs and want to continue running the scripts as they are, without
modification.

■ When Data pump runs in legacy mode, it doesn't create an old exp -/ imp -formatted file. Data pump always
creates a Data pump file and can only read Data pump files.

Note

Data Pump Mapping to the exp Utility
If you're used to the old exp / imp parameters, you may initially be confused by some of the syntax semantics. However,
after you use Data Pump, you'll find the newer syntax fairly easy to remember and use. Table 8-3 describes how the
legacy export parameters map to Data Pump export.

Table 8-3. Mapping of Old Export Parameters to Data Pump

Original exp Parameter Similar Data Pump expdp Parameter

BUFFER

N/A

COMPRESS TRANSFORM

CONSISTENT FLASHBACK_SCN or FLASHBACK_TIME

CONSTRAINTS EXCLUDE=CONSTRAINTS

DIRECT N/A; Data Pump automatically uses direct path whenever possible.

FEEDBACK STATUS in client output

FILE Database directory object and DUMPFILE

GRANTS EXCLUDE=GRANT

INDEXES INCLUDE=INDEXES , INCLUDE=INDEXES