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.