EXP-00008: ORACLE error 942 encountered
FranklinFaces.com
FranklinFaces.com - Oracle & SQL Server Database Forums for all IT Professionals
 Home          Members     Calendar     Who's On

Welcome Guest ( Login | Register )
        



EXP-00008: ORACLE error 942 encountered Expand / Collapse
Message
Posted 7/28/2009 4:29:55 PM Post #148
 

Supreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme Being
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,

« Prev Topic | Next Topic »


Reading This Topic Expand / Collapse
Active Users: 0 (0 guests, 0 members, 0 anonymous members)
No members currently viewing this topic.

Permissions Expand / Collapse

All times are GMT -5:00, Time now is 7:29am

Powered By InstantForum.NET v4.1.4 © 2010
Execution: 0.071. 9 queries. Compression Disabled.