Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> ORA-01546 Roll back segment error
hi! I am trying to take tablespace offline(which contains rollback
segments), but its giving me ORA-01546 error, saying there are some active
rollback segments in it, now my question is can I take tablespace offline
while there are some active rollback segment it it? if not how can I drop
this active segments? Which v$ view or tables gives more information about
active rollback segments?
Thanks in advance.
Received on Thu Feb 15 2001 - 15:20:54 CST