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
Backup and Recovery
|
37
RESUMABLE_NAME = name
Used to identify the resumable operation for the opera-
tor. Requires RESUMABLE to be Y.
RESUMABLE_TIMEOUT = n
Specifies the time, in seconds, that the operation will
wait for the operator to resume it after allocating more
space. The default is 7200.
ROWS = {Y | N}
Specifies whether the rows of data in tables are included
in the export or import. Specify ROWS=N to export the
structure of all objects without their contents or to
import the structures without any data.
TABLESPACES = (tablespace_name[, tablespace_name
...])
For Export, exports all tables that exist in the listed
tablespaces or that have a partition in a listed tablespace.
For Import, specifies a list of the tablespaces to be
imported.
USERID = username/password@service
Specifies the username/password@service of the user ini-
tiating the export or import if it is not specified on the
command line. password and @service (net service name)
are optional; if you do not include them as part of the
parameter, the utility will prompt you for them.
VOLSIZE = n
Specifies the maximum number of bytes in an export file
on a tape.
Export-only parameters
The following parameters can be used only with the Export
utility:
COMPRESS = {Y | N}
Specifies how Export manages the initial extent for table
data. The default causes Export to write a CREATE com-
mand that will cause a subsequent import to create the
object with
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