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

Thread: Adding Index While Inserting Data Into The Table

  1. 10-24-2002, 10:50 AM #1
    mike2000
    mike2000 is offline Senior Member
    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.
    Reply With Quote Reply With Quote
  2. 10-24-2002, 11:18 AM #2
    pgoenka
    pgoenka is offline Just Me
    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 11:31 AM.
    Reply With Quote Reply With Quote
  3. 10-24-2002, 11:24 AM #3
    Cookies
    Cookies is offline Member
    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
    Reply With Quote Reply With Quote
  4. 10-24-2002, 03:57 PM #4
    stmontgo's Avatar
    stmontgo
    stmontgo is offline Senior Advisor
    Join Date
    Aug 2002
    Location
    Atlanta
    Posts
    1,187
    what version of oracle?
    I'm stmontgo and I approve of this message
    Reply With Quote Reply With Quote
  5. 10-24-2002, 04:14 PM #5
    marist89's Avatar
    marist89
    marist89 is offline Super-Genius
    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
    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