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

Thread: create index (local partition) and undo

  1. #1
    Join Date
    Sep 2000
    Location
    Chicago, IL
    Posts
    316

    create index (local partition) and undo

    I got a snapshot too old on a create index (local -partition). I know no one was updating the table/partitions that I was building an index on. There were other transactions happening; but on other objects.

    Why would the create index stmt be using the UNDO segments ? Does it ?

    Please explain or point me to some doc. -thanks.

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    search metalink about delayed block cleanout

  3. #3
    Join Date
    Sep 2000
    Location
    Chicago, IL
    Posts
    316

    what does on during a CREATE INDEX statement

    Can someone point me to a doc that shows exactly what goes on during a CREATE INDEX statement ?

  4. #4
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    Post your script here.

    To avoid ora-1555, do a full table scan on the table and then create index.

    Do you have a script that creates many indexes on many tables?

    Tamil

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