RE: Export error ..

Chiku,

I can think of the following reasons for the problem:

1. A table is being given in the exp script (tables=3D ), not found in = the database?
2. Export do need some data dictionary tables / packages.(catexp.sql or = so?). Those are missing / not created properly?

HTH Arul.

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Chirag DBA Sent: 07 October 2004 11:13
To: oracle-l_at_freelists.org; askdba_at_freelists.org; dba_gurus_at_yahoogroups.com
Subject: Export error ..

One of my frnd is trying to generate development DB from production.

Production machine is 8.1.7 and development DB where he want to upload a DB is 9.2. He is taking export from his machine n getting this error. There is no DB migration is done.

Connected to: Oracle8i Enterprise Edition Release 8.1.7.4.1 - Production JServer Release 8.1.7.4.1 - Production

EXP-00056: ORACLE error 942 encountered
ORA-00942: table or view does not exist
EXP-00000: Export terminated unsuccessfully

Any Idea ?????

• Chiku
  --
  http://www.freelists.org/webpage/oracle-l
  --
  http://www.freelists.org/webpage/oracle-l