-
when u do a import from export backup dump file is it neccessary to give this parameter COMMIT =Y /N
what this parameter stand for. ?
VenDe ChukPeen Zuri
Someone who quotes himself as a DBA and posts simple question in forums is a big idiot to me . I donot care what others think
-
Default: N
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, 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, each partition and subpartition in the
Export file is imported in a separate transaction.
Specifying COMMIT=Y prevents rollback segments from growing inordinately
large and improves the performance of large imports. Specifying COMMIT=Y is
advisable if the table has a uniqueness constraint. If the import is restarted, any
rows that have already been imported are rejected with a nonfatal error.
If a table does not have a uniqueness constraint, Import could produce duplicate
rows when you reimport the data.
For tables containing LONG, LOB, BFILE, REF, ROWID, UROWID, DATE, or type
columns, array inserts are not done. If COMMIT=Y, Import commits these tables
after each row.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|