Re: PLS-00302 in

supernova wrote:
> 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

Run dbv to see what it reports for that data file. http://www.psoug.org/reference/utilities.html

-- 
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