Re: PLS-00302 in

From: supernova <nova67f_at_yahoo.de>
Date: 7 Dec 2006 13:52:05 -0800
Message-ID: <1165528325.224119.49140@73g2000cwn.googlegroups.com>

Daniel,

Thanks for the answer. I had done that.

so then i ran DBMS_REPAIR.CHECK_OBJECT (*not OBJECTS*)

and got this :
You have 0 corrupt block(s)

which is good news at first but my export of last night showed this :

. . export de la table                ACSALES
EXP-00056: Erreur ORACLE 1578 rencontr

ORA-01578: bloc de donnes ORACLE altr (fichier # 7, bloc # 435968) ORA-01110: fichier de donnes 7 :
'F:\ORACLE\ORADATA\AGR\AGRTRANS_01.DBF' and in the alert file i get this :

***
Corrupt block relative dba: 0x01c6a700 (file 7, block 435968) Fractured block found during user buffer read Data in bad block -
 type: 40 format: 2 rdba: 0x01c6a700
 last change scn: 0x0000.0003c56c seq: 0x2 flg: 0x04  consistency value in tail: 0xc40f2802
 check value in block header: 0xa65c, computed block checksum: 0x73a2  spare1: 0x0, spare2: 0x0, spare3: 0x0
***
Reread of rdba: 0x01c6a700 (file 7, block 435968) found same corrupted data

So since it seems to be the ACSALES table, DBMS_REPAIR.CHECK_OBJECT doesnt think so. why ?

thks,
Andy

> First do this:
>
> exec dbms_repair.admin_tables('REPAIR_TABLE',1,1,'<tablespace_name>');
> --
> 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 Thu Dec 07 2006 - 15:52:05 CST