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.
search metalink about delayed block cleanout
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 ?
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?
Click Here to Expand Forum to Full Width