Here are the mapping of Data Pump Export parameters to original Export parameters. In some cases, because of feature redesign, the original Export parameter is no longer needed, so there is no Data Pump parameter to compare it to. Also, some of the parameter names may be the same, but the functionality is slightly different. The parameter are as
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 users who have been granted the EXP_FULL_DATABASE role. |
RESUMABLE_NAME | A parameter comparable to RESUMABLE_NAME is not needed. This functionality is automatically provided for users who have been granted the EXP_FULL_DATABASE role. |
RESUMABLE_TIMEOUT | A parameter comparable to RESUMABLE_TIMEOUT is not needed. This functionality is automatically provided for users who have been granted the EXP_FULL_DATABASE role. |
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 and password when you invoke Export. |
VOLSIZE | A parameter comparable to VOLSIZE is not needed. |
Enjoy :-)
No comments:
Post a Comment