DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: IMPORT QUESTION

  1. #1
    Join Date
    Apr 2002
    Posts
    55
    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

  2. #2
    Join Date
    Apr 2002
    Location
    Chennai
    Posts
    27
    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
  •  


Click Here to Expand Forum to Full Width