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

Thread: commit=y

  1. 07-26-2002, 05:33 AM #1
    soniaarora
    soniaarora is offline Member
    Join Date
    Jul 2002
    Posts
    132
    I still did not find an answer for my doubt as to after how many rows/bytes of data does commit=y work while importing?
    Reply With Quote Reply With Quote
  2. 07-26-2002, 05:35 AM #2
    aarroyob
    aarroyob is offline Senior Advisor
    Join Date
    Oct 2001
    Location
    Madrid, Spain
    Posts
    763
    I'm not sure but I think it is every row.

    Cheers

    Angel
    Reply With Quote Reply With Quote
  3. 07-26-2002, 05:36 AM #3
    aarroyob
    aarroyob is offline Senior Advisor
    Join Date
    Oct 2001
    Location
    Madrid, Spain
    Posts
    763
    Excuse for my english "EACH" row.

    Cheers

    Angel
    Reply With Quote Reply With Quote
  4. 07-26-2002, 05:52 AM #4
    SANJAY_G's Avatar
    SANJAY_G
    SANJAY_G is offline Senior Advisor
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    Is it about IMPORT?

    The rows will be commited after each array insert.

    No. of rows in array = buffer_size/maximum_row_size.

    But if the table contains LONG. LOB, BFILE, DATE. ROWID columns the commit will be after each row.

    HTH
    Sanjay

    Reply With Quote Reply With Quote
  5. 07-26-2002, 05:58 AM #5
    pando
    pando is offline Pando & Company
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    DATE doesnt do that, it´s a doco bug
    Reply With Quote Reply With Quote
  6. 07-26-2002, 06:02 AM #6
    SANJAY_G's Avatar
    SANJAY_G
    SANJAY_G is offline Senior Advisor
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    By Pando:
    DATE doesnt do that, it´s a doco bug
    Thanks Pando,
    I too was wondering..

    Sanjay
    Reply With Quote Reply With Quote
  7. 07-26-2002, 07:07 AM #7
    soniaarora
    soniaarora is offline Member
    Join Date
    Jul 2002
    Posts
    132
    Thanx Sanjay!
    If I do not specify the buffer parameter along with the commit parameter, what will be the default buffer_size parameter?
    Reply With Quote Reply With Quote
  8. 07-26-2002, 07:18 AM #8
    pando
    pando is offline Pando & Company
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    operating system dependant, go technet and download admin guide for your platform
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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