Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle tries to read RBS in Automatic Undo Mode?

Re: Oracle tries to read RBS in Automatic Undo Mode?

From: chao_ping <zhuchao_at_gmail.com>
Date: 28 Apr 2005 00:49:44 -0700
Message-ID: <1114674584.233898.213470@z14g2000cwz.googlegroups.com> 





So have you dropped your rollback segment related tablespace already?



Try to enable SQL_TRACE to find out which recursive SQL is trying to
read from the old rollback segment. If necessary, export the table and
drop the table and import back, see if solves the problem.
Received on Thu Apr 28 2005 - 02:49:44 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US