 Posted 6/15/2010 4:09:10 PM
|
|
|
|
| oerr ora 00942 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, |
|
|
|
Posted 6/15/2010 4:13:27 PM
|
|
|
|
SQL> select * from mytable;
select * from mytable
*
ERROR at line 1:
ORA-00942: table or view does not exist
SQL> !oerr ora 942
00942, 00000, "Do you think this table or view exists? "
// *Cause: It could be a typo.
// *Action: Learn to type correctly.
TGIF... 
|
|
|
|