create index (local partition) and undo

[khussain]

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.

[pando]

search metalink about delayed block cleanout

[khussain]

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

[tamilselvan]

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