How to import a corrupted file?
341851Mar 17 2004 — edited Mar 18 2004I got the following errors when I did import.
It seems that the file was corrupted.
But do you know if there are some tools or methods which can skip the corrupted rows and do the rest of the file.
Thanks,
Samuel
Connected to: Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production
With the Partitioning option
JServer Release 9.2.0.4.0 - Production
Export file created by EXPORT:V08.01.07 via direct path
import done in ZHT16BIG5 character set and AL16UTF16 NCHAR character set
import server uses WE8ISO8859P1 character set (possible charset conversion)
export server uses ZHT16BIG5 NCHAR character set (possible ncharset conversion)
. . importing table "RTX_020401"
IMP-00009: abnormal end of export file
IMP-00018: partial import of previous table completed: 7340500 rows imported
Import terminated successfully with warnings.