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.
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 ?