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: idl_sb4$ contains corrupted block !

Re: idl_sb4$ contains corrupted block !

From: Carl Bruhn <crb_at_dde.dk>
Date: Wed, 10 Feb 1999 09:40:26 +0100
Message-ID: <36C145FA.141CE0BD@dde.dk>


Hi Ayoub,

we had an incident on idl_ub1$ table with corrupted block, but where able to make a full export of the database (because sys tables is not exported during export), recreate the database and make an import. If you have an backup using archivelog mode, you would probably be better of by recreating from this backup. But make an exp first if you can.

Hope this help but corrupted blocks are normally a matter of restoring from backup.

best regards.
Carl Bruhn.
crb_at_dde.dk

abenbouzid_at_omnidata.co.ma wrote:

> Hello all,
>
> I had ORA-1578 & ORA-1110 when trying to connect to the db as a simple user.
> I found the corrupted block in the DB dictionnary table idl_sb4$.
> CAn any body show me how can I resolve this.
>
> Regards.
>
> Ayoub.
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Wed Feb 10 1999 - 02:40:26 CST

Original text of this message

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