mardi 24 juillet 2012

Oracle : Correspondance Export DataPump / Export

Quand on a des scripts d'import et qu'on veux passer à DATA PUMP, rien de mieux qu'une table de correspondance.
http://download.oracle.com/docs/cd/B28359_01/server.111/b28319/dp_export.htm

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.