
42
|
Oracle DBA Pocket Guide
remarks but can be edited. filename is a common identi-
fier, defined earlier. There is no default for this parame-
ter, and it can be used only with the FULL=Y,
FROMUSER, TOUSER, and/or TABLES parameters.
SHOW = {Y | N}
If SHOW=Y is specified, the SQL statements contained
in the export file are listed to the display only, and
objects are not imported. SHOW=Y can be used only
with the FULL=Y, FROMUSER, TOUSER, and/or
TABLES parameters.
TIP
You can use SHOW to regenerate Data Definition Lan-
guage (DDL). Do an export, then do an import with
SHOW=Y, redirecting the output to a file. Edit the file to
get rid of messages that are not DDL, and you will have
your DDL again.
SKIP_UNUSABLE_INDEXES = {Y | N}
Specifies whether Import skips building indexes set to
the Index Unusable state. Without this parameter, row
insertions that attempt to update unusable indexes fail.
STATISTICS = {ALWAYS | NONE | SAFE | RECALCULATE}
Specifies how optimize statistics should be handled by
the import process.
ALWAYS
Specifies that statistics should always be imported,
even if they are questionable.
NONE
Specifies that statistics are not to be imported nor
calculated.