Wednesday 5 December 2012

exp & expdp parameter gap mapping

file
dumpfile
log
logfile
owner
schema
userid
userid
direct
optional
conventional
Optional
grant
EXCLUDE=GRANT
STATISTICS
A parameter comparable to STATISTICS is not needed. Statistics are always saved for tables.
Buffer
no need (Data Pump Export and Import are self-tuning utilities, are neither required nor supported by Data Pump Export and Import)
compress
no need
consistent
no need(A parameter comparable to CONSISTENT is not needed. Use FLASHBACK_SCN and FLASHBACK_TIME for this functionality.)
CONSTRAINTS
EXCLUDE=CONSTRAINT
DIRECT
not needed. Data Pump Export automatically chooses the best method (direct path mode or external tables mode).
FEEDBACK
STATUS
FILESIZE
FILESIZE
FLASHBACK_SCN
FLASHBACK_SCN
FLASHBACK_TIME
FLASHBACK_TIME
FULL
FULL (For example, suppose you perform an export with FULL=Y, followed by an import using SCHEMAS=HR.
 continue ....
This will produce the same results as if you performed an export with SCHEMAS=HR, followed by an import with FULL=Y)
INDEXES
EXCLUDE=INDEX
PARFILE
PARFILE
QUERY
QUERY
ROWS=N
CONTENT=METADATA_ONLY
ROWS=Y
CONTENT=ALL
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
VOLSIZE
A parameter comparable to VOLSIZE is not needed.


No comments:

Post a Comment