Differences between Data Pump impdp and import utility
January 13th, 2011 Comments Off on Differences between Data Pump impdp and import utility
BUFFER |
A parameter comparable to BUFFER is not needed. |
CHARSET |
A parameter comparable to CHARSET is not needed. |
COMMIT |
A parameter comparable to COMMIT is not supported. |
COMPILE |
A parameter comparable to COMPILE is not supported. |
CONSTRAINTS |
EXCLUDE=CONSTRAINT |
DATAFILES |
TRANSPORT_DATAFILES |
DESTROY |
REUSE_DATAFILES |
FEEDBACK |
STATUS |
FILE |
DUMPFILE |
FILESIZE |
Not necessary. It is included in the dump file set. |
FROMUSER |
SCHEMAS |
FULL |
FULL |
GRANTS |
EXCLUDE=GRANT |
HELP |
HELP |
IGNORE |
TABLE_EXISTS_ACTION |
INDEXES |
EXCLUDE=INDEX |
INDEXFILE |
SQLFILE with INCLUDE INDEX |
LOG |
LOGFILE |
PARFILE |
PARFILE |
RECORDLENGTH |
A parameter comparable toRECORDLENGTH is not needed. |
RESUMABLE |
A parameter comparable to RESUMABLE is not needed. It is automatically defaulted for privileged users. |
RESUMABLE_NAME |
A parameter comparable toRESUMABLE_NAME is not needed. It is automatically defaulted for privileged users. |
RESUMABLE_TIMEOUT |
A parameter comparable toRESUMABLE_TIMEOUT is not needed. It is automatically defaulted for privileged users. |
ROWS=N |
CONTENT=METADATA_ONLY |
ROWS=Y |
CONTENT=ALL |
SHOW |
SQLFILE |
SKIP_UNUSABLE_INDEXES |
SKIP_UNUSABLE_INDEXES |
STATISTICS |
A parameter comparable to STATISTICS is not needed. If the source table has statistics, they are imported. |
STREAMS_CONFIGURATION |
STREAMS_CONFIGURATION |
STREAMS_INSTANTIATION |
A parameter comparable toSTREAMS_INSTANTIATION is not needed. |
TABLES |
TABLES |
TABLESPACES |
This parameter still exists, but some of its functionality is now performed using theTRANSPORT_TABLESPACES parameter. |
TOID_NOVALIDATE |
A command comparable toTOID_NOVALIDATE is not needed. OIDs are no longer used for type validation. |
TOUSER |
REMAP_SCHEMA |
TRANSPORT_TABLESPACE |
TRANSPORT_TABLESPACES (see command description) |
TTS_OWNERS |
A parameter comparable to TTS_OWNERS is not needed because the information is stored in the dump file set. |
USERID |
A parameter comparable to USERID is not needed. This information is supplied as theusername/password when you invoke Import. |
VOLSIZE |
A parameter comparable to VOLSIZE is not needed because tapes are not supported. |