I have exported a table with a corrupted block and get the following:
EXP-00056: ORACLE error 1578 encountered
ORA-01578: ORACLE data block corrupted (file # 5, block # 112676)
ORA-01110: data file 5: '/u12/oradata/SPFHD1/fh_datal01_001.dbf'
Export terminated successfully with warnings.
If I drop the corrupted table, and try to import the table back from the exported dump file which gave the above error during export, would I get my rows back minus what was in the corrupted block??? What are the consequences??? Please - your input highly awaited!!
Click Here to Expand Forum to Full Width