Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Export error ..

RE: Export error ..

From: <arul.kumar_at_bt.com>
Date: Thu, 7 Oct 2004 11:20:09 +0100
Message-ID: <83FC2D1BC95D884894735B11B562A41C083779E6@i2km06-ukbr.domain1.systemhost.net>


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 ?????

Received on Thu Oct 07 2004 - 05:14:46 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US