EXP-00008: ORACLE error 942 encountered

Admin — Tue, 28 Jul 2009 16:29:55 GMT

When exporting, we're getting the following error:

EXP-00008: ORACLE error 942 encountered
ORA-00942: table or view does not exist
EXP-00024: Export views not installed, please notify your DBA
EXP-00000: Export terminated unsuccessfully

Regarding this error you want to first make sure that the user you are using has EXP_FULL_DATABASE granted to it.

Then you you must run the following when you create the db and make sure there are no errors:
%ORACLE_HOME%/rdbms/admin/catalog.sql
%ORACLE_HOME%/rdbms/admin/catproc.sql

Hope this helps.

Thanks,

FranklinFaces.com - Oracle & SQL Server Database Forums for all IT Professionals / Oracle Forum / ORA - Oracle Database Error Codes - Search via specific error codes. / EXP- IMP- Error Codes / EXP-00008: ORACLE error 942 encountered / Latest Posts

EXP-00008: ORACLE error 942 encountered