Hi Richard
There is no data in the corrupt blocks in the datafiles, so they are
empty. So do you think that the export will fail
because of empty corrupt blocks?
Richard Foote wrote:
Hi Birkir,
You maybe forgetting that your export will fail once it comes across one of the corrupted blocks !!
You need to fix the corruptions which depends entirely on the nature of the corruption, what's actually corrupted, are the objects re-creatable, is the corruption in your backups (else restore and recover of datafiles could be an option), database version (dbms_repair), can you afford to lose the corrupted data, is it in a LOB (nasty but solvable), investigate block dumps, etc. etc.
I've fixed plenty of corruptions in my time and it's usually a case of horses for courses.
But exp/imp is unlikely to be your solution.
Good Luck
Richard ----- Original Message ----- From: "Birkir Bjornsson" <birkir@xxxxxxxx> To: <oracle-l@xxxxxxxxxxxxx> Sent: Friday, March 05, 2004 10:47 PM Subject: EXP/IMP due to corrupt blocks
Hi
I hava a database with corrupt blocks. And I was thinking of exporting the database and then import it on another machine because of faulty hardware.
So isnt this the right approach for this, create the tablespaces, and users on the new database and then import from user to user?
Is there anything im forgetting?
Kind Regards Bippi
---------------------------------------------------------------- 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
-----------------------------------------------------------------
---------------------------------------------------------------- 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 -----------------------------------------------------------------