Database Reference
In-Depth Information
Table 8-3. ( continued )
Original exp Parameter
Similar Data Pump expdp Parameter
LOG
Database directory object and LOGFILE
OBJECT_CONSISTENT
N/A
OWNER
SCHEMAS
RECORDLENGTH
N/A
RESUMABLE
N/A; Data Pump automatically provides functionality.
RESUMABLE_NAME
N/A
RESUMABLE_TIMEOUT
N/A
ROWS
CONTENT=ALL
STATISTICS
N/A; Data Pump export always exports statistics for tables.
TABLESPACES
TRANSPORT_TABLESPACES
TRANSPORT_TABLESPACE
TRANSPORT_TABLESPACES
TRIGGERS
EXCLUDE=TRIGGER
TTS_FULL_CHECK
TRANSPORT_FULL_CHECK
VOLSIZE
N/A; Data Pump doesn't support tape devices.
In many instances, there isn't a one-to-one mapping. Often, Data Pump automatically provides features that used
to require a parameter in the legacy utilities. For example, whereas you used to have to specify DIRECT=Y to get a direct
path export, Data Pump automatically uses direct path whenever possible.
Data Pump Mapping to the imp Utility
As with Data Pump export, Data Pump import often doesn't have a one-to-one mapping of the legacy utility
parameter. Data Pump import automatically provides many features of the old imp utility. For example, COMMIT=Y isn't
required because Data Pump import automatically commits after each table is imported. Table 8-4 describes how the
legacy import parameters map to Data Pump import.
Table 8-4. Mapping of Old Import Parameters to Data Pump
Original imp Parameter
Similar Data Pump impdp Parameter
BUFFER
N/A
CHARSET
N/A
COMMIT
N/A; Data Pump import automatically commits after each table is exported.
COMPILE
N/A; Data Pump import compiles procedures after they're created.
CONSTRAINTS
EXCLUDE=CONSTRAINT
DATAFILES
TRANSPORT_DATAFILES
DESTROY
REUSE_DATAFILES=y
( continued )
 
Search WWH ::




Custom Search