Tuesday, January 22, 2013

IMP-00058: ORACLE error 942 encountered ORA-00942: table or view does not exist

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.

1 comment: