Re: Corrept Undo Tablespace and oracle internal problem

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
Received on Wed Aug 16 2006 - 08:35:02 CDT