Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> Partition Advice

Partition Advice

From: Sanjay Mishra <>
Date: Mon, 26 Jul 2004 11:14:14 -0700 (PDT)
Message-ID: <>

I have a prod database where we have one of the big table been partioned on Weekly basis and each week data is around 40G. Today I checked that our RMAN backup is still showing Sucess at the end but been failing from last one week on one of the datafile and generated an IO error and then found that there are several block is been corrupted and it is Sun platform. I cannot copy the 30 G datafile using any OS utilities from one filesystem to another as it fail with same error.

Now I cannot recover as I don't have good backup of this file but as the user are not accessing this old partition and so there are no report been made and system is fine. I had create new table now and populated all of the 2 million record in it and only lost 10 records. Now can somebody suggest as how can I put this data back to the parititon. I am going to drop the old parition and it is of no issue [ I hope so ] as I had made the file offline and online yesterday with problem and even bounced the database. So is there any way that I can drop the old partition and put this new data into this place. Original table is emp and new recovered table is Employee

Thanks for all help                 

Do you Yahoo!?
New and Improved Yahoo! Mail - Send 10MB messages!

Please see the official ORACLE-L FAQ:

To unsubscribe send email to: put 'unsubscribe' in the subject line.

Archives are at FAQ is at
Received on Mon Jul 26 2004 - 13:10:43 CDT

Original text of this message