Parameter File Syntax

Export may be invoked from a host system command line or batch script using the following syntax, which references detailed instructions stored in a parameter file:

exp [username[/password]][@hostname] parfile=filename
username

The Oracle username for the account to run Export.

password

The password for the username. If the password is omitted, SQL*Plus will prompt for the password.

hostname

The hostname assigned to the database being connected to, as contained in the tnsnames.ora file or Oracle Names.

filename

The name of an operating system file containing a list of Export parameters; see the description in “Export Parameters” for details. Specify one parameter per record, using one of the following syntax options:

parameter=value
parameter=(value)
parameter=(value1, value2, ...)

Get Oracle Database Administration: The Essential Refe now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.