Home » RDBMS Server » Server Utilities » ORA-00942 (merged)
ORA-00942 (merged) [message #265367] Thu, 06 September 2007 03:37 Go to next message
roblvl
Messages: 27
Registered: June 2003
Junior Member
Hi all

We have encountered the follwing error when doing an Export from Oracle 9i . Can any body tell us why the following error is coming and how it can be rectified
Connected to: Oracle9i Enterprise Edition Release 9.2.0.7.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.7.0 - Production
Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set

About to export specified users ...
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user UATPREMIA
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user UATPREMIA
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
Ora-00942 Error During Export in Oracle 9i [message #265370 is a reply to message #265367] Thu, 06 September 2007 03:39 Go to previous messageGo to next message
roblvl
Messages: 27
Registered: June 2003
Junior Member
Hi all

We have encountered the following error when doing an Export from Oracle 9i . Can any body tell us why the following error is coming and how it can be rectified
Connected to: Oracle9i Enterprise Edition Release 9.2.0.7.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.7.0 - Production
Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set

About to export specified users ...
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user UATPREMIA
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user UATPREMIA
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
Re: Ora-00942 Error During Export in Oracle 9i [message #265371 is a reply to message #265370] Thu, 06 September 2007 03:42 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Do you have permission to export table/views?

Probably not.

So export as a user who have permission on that table/view.
Re: Help!! Error In Export in 9i Ora-00942 [message #265372 is a reply to message #265367] Thu, 06 September 2007 03:47 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Avoid duplicate entry. What is your export command?

This one is already posted by you in server utilities section.

[Updated on: Thu, 06 September 2007 03:47]

Report message to a moderator

Re: Ora-00942 Error During Export in Oracle 9i [message #265375 is a reply to message #265370] Thu, 06 September 2007 03:55 Go to previous messageGo to next message
roblvl
Messages: 27
Registered: June 2003
Junior Member
The table was created in the same db user id .so it will have the rights on its tables right .is there any other cause of this issue
Re: Ora-00942 Error During Export in Oracle 9i [message #265376 is a reply to message #265370] Thu, 06 September 2007 03:57 Go to previous messageGo to next message
roblvl
Messages: 27
Registered: June 2003
Junior Member
Hi

How Do we check whether we have permission to export table/views.

Re: Ora-00942 Error During Export in Oracle 9i [message #265379 is a reply to message #265370] Thu, 06 September 2007 04:05 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Quote:
ORA-00942: table or view does not exist


You raised this . According to you Oracle have made the wrong.
Note that if you create synonym but the table in other schema then you must have exp_full_database privilege before exporting objects in other schema.
Re: Help!! Error In Export in 9i Ora-00942 [message #265385 is a reply to message #265367] Thu, 06 September 2007 04:13 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
EXP-00024: Export views not installed, please notify your DBA

So do it.

Regards
Michel
Previous Topic: Backup & Import Database | Problems with user-rules
Next Topic: Import Utility Hang
Goto Forum:
  


Current Time: Sun Dec 04 02:18:00 CST 2016

Total time taken to generate the page: 0.08381 seconds