I got this error today, while importing a dump into a 10g database (regular dump and not data pump). This error occurred on all tables that contained a BLOB column.
The source dump file was exported from a 10g database.
Here is a sample
. . importing table "TBL_OBSERVATION"
IMP-00058: ORACLE error 942 encountered
ORA-00942: table or view does not exist 2365 rows imported
Even though the imp complained about table not found, It did import all the records ( in my case 2365 rows imported)
After some debugging, I found that the error was happening as I was using 11g (11.2.0.1) client to import into a 10g (10.2.0.4) database.
When I used 10g (10.2.0.4) client to import, it worked fine.
There is no proper explanation available for this error, but seems to happen when you use 11g client to import a 10g dump into a 10g database
Workaround, Use 10g client to import into a 10g database.
Useful! Thank you! Met the same situation!:))
ReplyDelete