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.
|
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.
|
Wednesday, 5 December 2012
exp & expdp parameter gap mapping
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment