Tuesday 18 March 2014

9i Export/Import Parameters

9i Export/Import Parameters


USERID:   username/passwordBUFFER:   size of data bufferFILE:   output file (EXPDAT.DMP)COMPRESS:   import into one extent (Y)GRANTS:   export grants (Y)INDEXES:   export indexes(Y)ROWS:   export data rows (Y)CONSTRAINTS:   export table constraints (Y)CONSISTENT:   cross-table consistency (N)LOG:   log file of screen output (None)STATISTICS:   analyze objects (ESTIMATE)DIRECT:   Bypass the SQLcommand processing layer (N) (new in Oracle8)FEEDBACK:   Show a process meter (a dot) every X rows exported (0 – Xvalue)HELP:   Shows help listing MLS MLS_LABEL_FORMAT Used with secure Oracle; we won't cover
these.FULL:   export entire file (N)OWNER:   list of owner usernamesTABLES:   list of table namesRECORDLENGTH:  length of IO recordINCTYPE:  incremental export typeRECORD:   track incr. export (Y)PARFILE:   parameter file name

No comments:

Post a Comment