Original Export Parameter | Comparable Data Pump Export Parameter |
---|---|
BUFFER | A parameter comparable to BUFFER is not needed. |
COMPRESS | A parameter comparable to COMPRESS is not needed. |
CONSISTENT | A parameter comparable to CONSISTENT is not needed. Use FLASHBACK_SCN and FLASHBACK_TIME for this functionality. |
CONSTRAINTS | EXCLUDE=CONSTRAINT |
DIRECT | A parameter comparable to DIRECT is not needed. Data Pump Export automatically chooses the best method (direct path mode or external tables mode). |
FEEDBACK | STATUS |
FILE | DUMPFILE |
FILESIZE | FILESIZE |
FLASHBACK_SCN | FLASHBACK_SCN |
FLASHBACK_TIME | FLASHBACK_TIME |
FULL | FULL |
GRANTS | EXCLUDE=GRANT |
HELP | HELP |
INDEXES | EXCLUDE=INDEX |
LOG | LOGFILE |
OBJECT_CONSISTENT | A parameter comparable to OBJECT_CONSISTENT is not needed. |
OWNER | SCHEMAS |
PARFILE | PARFILE |
QUERY | QUERY |
RECORDLENGTH | A parameter comparable to RECORDLENGTH is not needed because sizing is done automatically. |
RESUMABLE | A parameter comparable to RESUMABLE is not needed. This functionality is automatically provided for privileged users. |
RESUMABLE_NAME | A parameter comparable to RESUMABLE_NAME is not needed. This functionality is automatically provided for privileged users. |
RESUMABLE_TIMEOUT | A parameter comparable to RESUMABLE_TIMEOUT is not needed. This functionality is automatically provided for privileged users. |
ROWS=N | CONTENT =METADATA_ONLY |
ROWS=Y | CONTENT =ALL |
STATISTICS | A parameter comparable to STATISTICS is not needed. Statistics are always saved for tables. |
TABLES | TABLES |
TABLESPACES | TABLESPACES (Same parameter; slightly different behavior) |
TRANSPORT_TABLESPACE | TRANSPORT_TABLESPACES (Same parameter; slightly different behavior) |
TRIGGERS | EXCLUDE=TRIGGER |
TTS_FULL_CHECK | TRANSPORT_FULL_CHECK |
USERID | A parameter comparable to USERID is not needed. This information is supplied as the username /password when you invoke Export. |
VOLSIZE | A parameter comparable to VOLSIZE is not needed. |
This table does not list all Data Pump Export command-line parameters.
What is this Datapump? How is it implemented? The parameters you've talked about, what are they meant for? Please elaborate.
ReplyDeleteDatapump = expdp/impdp (export datapump - an alternative to export/import (exp/imp))
ReplyDelete