bad undo, can I just rebuild it?

  • From: patrick obrien <po04541@xxxxxxxxx>
  • To: Oracle L <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 12 May 2010 12:43:15 -0700 (PDT)

Oracle experts,

oracle 10gR2, the alert log says the undo tablepace is bad,
ORA-00604: error occurred at recursive SQL level 1
ORA-01552: cannot use system rollback segment for non-system tablespace 'TOOLS'
Can I just drop the undo and recreate it? 

thank you,
Patrick.

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 05-2010