-
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?
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|