Parameter File Syntax

Import 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:

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

The Oracle username for the account to run Import.

password

The password for the username.

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 Import parameters. See the section Section 16.3.4, later in this chapter, for details on parameter files and their values. 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.