http://www.dba.5341.com/
http://www.dba.5341.com/
Sami
As per your other respondent - I had the same issue and was told that Oracle is still trying to check UNDO in the offlined tablespace. If the tablespace had been dropped then Oracle would not have bothered, making the assumption that the drop would not have taken place if there was still data in the UNDO tablespaces. So the solution is as posted if you feel confident to do so (I must admit I did not and ended up shrinking the old UNDO as small as possible and leaving it on-line but not used).
HTH
Tim
Tim Onions
Head Of Oracle Development
Phone: +44 (0) 1684 312364 ext. 364
Cell: +44 (0) 7736 634556
www.medquist.com
This electronic mail transmission contains confidential information intended only for the person(s) named.
Any use, distribution, copying or disclosure by another person is strictly prohibited.
If you are not the intended recipient of this e-mail, promptly delete it and all attachments.
"Sami Seerangan" <dba.orcl@gmail.com>
Sent by: oracle-l-bounce@freelists.org 16/03/2006 21:25
|
|