Re: Corrept Undo Tablespace and oracle internal problem

peter schreef:

> Thank you for your reponse.
> But I don't have any metalink user id.
> I am also facing current redo log file corrupt problem. According to
> books also we can issue one command through which we can remove this
> problem, which is :
>
> Alter database clear noarchive logfile group 4;
>
> But it is giving error so right now I am not able to remove this two
> problem.
> You are looking very senior with 5 yrs. of experience, I just have
> nearly 3 months of experience, please help me.
>
> Thank You
>
> DA Morgan wrote:
> > peter wrote:
> > > I know when my undo tablespace is corrupted then we can change undo
> > > tablespace to new undo tablespace but what are the problems we can
> > > face. Like what will happen with pending transactions.
> > > And could anyone please tell me which book or site can help me to
> > > explore database internally.
> >
> > Having never seen a corrupt undo tablespace in what is it now ... 5
> > years ... I have no idea. But my first instinct, if I had this question,
> > would be to hit metalink.
> > --
> > Daniel A. Morgan
> > University of Washington
> > damorgan_at_x.washington.edu
> > (replace x with u to respond)
> > Puget Sound Oracle Users Group
> > www.psoug.org

Always state version of the oracle products, and platform on which you run.
In your case, also state the error code and message Received on Wed Aug 16 2006 - 08:46:15 CDT