Hi lists, I tried execting the dbms_repair with the following steps:
sql> variable x number; sql> exec dbms_repair.check_object('SCOTT','EMP',:x); it is giving the error: PLS-00306: wrong number or types of arguments in call to 'CHECK_OBJECT' can anybody tell me how to execute this procedure. Thnx and Regards, Srinivas +++++++++++++++++++++++++ Hello By using DBMS_REPAIR.CHECK_OBJECT I have found 3 corrupt datablocks in our database, all with error: Block Checking: DBA = 184607007, Block Type = KTB-managed data block kdbchk: the amount of space used is not equal to block size used=8169 fsc=0 avsp=112 dtl=8120 My plan now is to fix these data blocks. I have never done this before, so I consulted my Oracle manual and the manual recomends the following: First run DBMS_REPAIR.CHECK_OBJECT on the object to find out if the object contains any corrupt blocks. Then I run DBMS_REPAIR.FIX_CORRUPT_BLOCKS to mark the block as corrupt. After that run DBMS_REPAIR.DUMP_ORPHAN_KEYS to dump all the index references to these blocks. Then run DBMS_REPAIR.SKIP_CORRUPT_BLOCKS on the object, and after that recreate the table. By doing this the corrupt blocks are removed from the object. Now I have some questions about this. (My environments is a Oracle 8.1.7 on a Windows 2000 Advanced Server): Is this a good way, or is there a better way? Can I access the data in the corrupt blocks in anyway so I can se whats in the blocks? I'm afraid that i will loose some data by doing it this way. Regards Jonas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonas A Wetterberg INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).