Archive

Archive for the ‘Oracle’ Category

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.