Oracle Database Administration: The Essential Refe

Import Parameters

The following is a description of the parameters that may be specified to Import, either on a command line or in a parameter file:

ANALYZE={Y | N}

Specifies whether the Import utility executes SQL ANALYZE statements found in the export file. See STATISTICS in the section Section 16.2.4. The default is ANALYZE=Y.

BUFFER=buffersize

Specifies the size, in bytes, of the buffer used to load rows. This parameter determines the maximum number of rows in an array loaded by Import as:

rows = buffer / maximum_row_size

If you specify zero, Import loads one row at a time. Tables with LONG, LOB, BFILE, REF, ROWID, or type columns are always loaded one row at a time. The default is operating system dependent.

CHARSET=charsetname

Applies to Oracle Version 6 export files only, and specifies the actual character set used at the time of export. The Import utility will verify whether the specified character set is ASCII or EBCDIC based on the character set in the Export file. If that file was created with Oracle7 or Oracle8, the character set is specified within the Export file, and conversion to the current database’s character set is automatic. There is no default.

COMMIT={Y | N}

Specifies whether Import should commit after each array insert. The default is COMMIT=N, which causes Import to commit after loading each table. If COMMIT=N and a table is partitioned, each partition in the Export file is imported in a separate transaction. Specifying COMMIT=Y prevents rollback segments from growing ...