Skip to Main Content
Oracle DBA Pocket Guide
book

Oracle DBA Pocket Guide

by David C. Kreines
August 2005
Intermediate to advanced content levelIntermediate to advanced
154 pages
4h 48m
English
O'Reilly Media, Inc.
Content preview from Oracle DBA Pocket Guide
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.
Backup and Recovery
|
43
SAFE
Specifies that statistics are to be imported only if they
are not questionable; otherwise, recalculate statistics.
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Oracle PL/SQL for DBAs

Oracle PL/SQL for DBAs

Arup Nanda, Steven Feuerstein
Oracle RMAN Pocket Reference

Oracle RMAN Pocket Reference

Darl Kuhn, Scott Schulze

Publisher Resources

ISBN: 9780596528843