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