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

Home -> Community -> Usenet -> c.d.o.tools -> Re: Clear Rollback Segement

Re: Clear Rollback Segement

From: Syltrem <syltrem_at_videotron.ca>
Date: Mon, 6 Nov 2000 09:43:38 -0500
Message-ID: <CkzN5.4614$m31.110759@wagner.videotron.net> 






ALTER DATABASE CLEAR [UNARCHIVED] LOGFILE GROUP N [UNRECOVERABLE DATAFILE]


Will even re-create the redo file if non existant.



Syltrem



"Rayfil Cheung" <rayfilcheung_at_hket.com> wrote in message
news:3A0398BF.24D825BC_at_hket.com...


> How to clear a Rollback Segment or recover a corrupted Rollback

> Segment.  Thank you.

>

Received on Mon Nov 06 2000 - 08:43:38 CST












Original text of this message













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