RE: Partition Advice

partition exchange

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Sanjay Mishra
Sent: Monday, July 26, 2004 2:14 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: Partition Advice



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


        =09
__________________________________
Do you Yahoo!?
New and Improved Yahoo! Mail - Send 10MB messages!
http://promotions.yahoo.com/new_mail=20
----------------------------------------------------------------
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 http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------


BEGIN-ANTISPAM-VOTING-LINKS
------------------------------------------------------
Teach CanIt if this mail (ID 5552372) is spam:
Spam:        =
https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3Ds&i=3D5552372&m=3D36068=
24c7f8b
Not spam:    =
https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3Dn&i=3D5552372&m=3D36068=
24c7f8b
Forget vote: =
https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3Df&i=3D5552372&m=3D36068=
24c7f8b
------------------------------------------------------
END-ANTISPAM-VOTING-LINKS

----------------------------------------------------------------
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 http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: