Hameed wrote:Not a good start!
I have some doubts to export a 7 database, my plan to export this 7 and import into new version [ie 11gR2].
Expected Issues in this database are :
1) This 7 DB is not having a valid backup
*2) Lot of Database block corruption*Make the not a good start changed to worse .
*3) Is there any way to skip the corrupted blocks on export*You can use the package dbms_repair which can be used to skip the corrupted blocks. But the package came in 8i so I am not sure that what you are going to do in version 7 for teh same.
*4) If i can skip this corrupted blocks on export do i face any problem*The export would throw ora-1578 error to you.
Kindly explain me what is Corruption and how to rectify this,,,The block corruption is that the block is not readable for some reason by oracle. To rectify it , you would need a valid backup and RMAN.