Adding Index While Inserting Data Into The Table
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Adding Index While Inserting Data Into The Table

  1. #1
    Join Date
    Sep 2002
    Posts
    411

    Adding Index While Inserting Data Into The Table

    I have a quick question: Can we add an index to a table while that table is in the porcess of insert data into it.

    We think we can but that index we add won't do any good after we analyze that table, right???

    Please confirm.

  2. #2
    Join Date
    Aug 2002
    Posts
    35
    hi
    u can create a index when the data is being inserted .. however issuing analyze command before data insert is complets may not be effective cos your statistics will change once the data is inserted and this will cause you statistics to become stale issues analyze command only after your insert operation is complete

    SORRY IT WONT LET U CREATE INDEX IT WIL GIVE THIS NOWAIT ERROR !!! SORRY I GOOFFED UP!!!
    Last edited by pgoenka; 10-24-2002 at 12:31 PM.

  3. #3
    Join Date
    Oct 2002
    Posts
    182

    Thumbs down

    I would be surprised if it even let you.
    It should not allow you to create an index if you have not committed the inserts ...

    You should get the "acquired with nowait" error since oracle needs a commit on the data you are inserting.
    - Cookies

  4. #4
    Join Date
    Aug 2002
    Location
    Atlanta
    Posts
    1,187
    what version of oracle?
    I'm stmontgo and I approve of this message

  5. #5
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Assuming 8.1.7, you can create your index ONLINE. http://download-west.oracle.com/docs...dexes.htm#3062
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

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