Q
Problem solve Get help with specific problems with your technologies, process and projects.

ORA-00942 error during export

When exporting data from our database, I get the ORA-00942 error. Why?

When exporting data from our database, I get the below 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
Can you tell me why?
One reason for the above errors is that the version of the export utility is higher than the database version. Use the same version of exp as the RDBMS. The other reason for the above errors is that the Data Dictionary is not correctly set up for exports. Sign on as SYS and run the ORACLE_HOME/rdbms/admin/catexp.sql script.

Dig Deeper on Oracle database backup and recovery

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close