What is the table name? -----Original Message----- From: M Rafiq [mailto:rafiq9857@xxxxxxxxxxx]=20 Sent: Wednesday, July 28, 2004 8:18 PM To: oracle-l@xxxxxxxxxxxxx Subject: System tablespace corrupted Env: Windows 2000 SP 4 Oracle 9.2.0.5 While exporting full database, it was observed that there is 1 block is=20 corrupted and other is fractured as per dbv. After checking it was tracked=20 as a sys.table. dbinv alos points that corrupt block due media failure. SA=20 ran Compaq provided utility which says no corruption of media. Database is a development instance and no archive on. Simple way to restore=20 complete database from cold backup of previous week. Is there any other way to recover the table completely. DBMS_REPAIR package=20 does not look to work for complete recovery. Full export hanging after=20 generating errors for that block. Regards Rafiq _________________________________________________________________ Planning a family vacation? Check out the MSN Family Travel guide!=20 http://dollar.msn.com ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------