Specifies whether Import should commit after each array insert. By default, Import commits only after loading each table, and Import performs a rollback when an error occurs, before continuing with the next object.
If a table has nested table columns or attributes, then the contents of the nested tables are imported as separate tables. Therefore, the contents of the nested tables are always committed in a transaction distinct from the transaction used to commit the outer table.
If COMMIT=n
and a table is partitioned, then each partition and subpartition in the Export file is imported in a separate transaction.
For tables containing LOBs, LONG,
BFILE,
REF,
ROWID,
UROWID
, or TIMESTAMP
columns, array inserts are not done. If COMMIT=y
, then Import commits these tables after each row.