| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Q:alter table and rollback problem - urgent
Take all the rollback segments, except the temporary one, offline.
(Offcourse you cannot offline the SYSTEM rollback segment).
And now do the operation.
An ALTER TABLE can use non-system rollback segment.
Only the recursive SQL generating UNDO and REDO to UNDO$ will
mandatorily go to the SYSTEM rollback segment.
regards
Srivenu
Received on Fri Mar 05 2004 - 06:19:34 CST
 |
 |