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: Mercadante, Thomas F <thomas.mercadante_at_labor.state.ny.us>
Date: Thu, 7 Oct 2004 09:02:30 -0400
Message-ID: <C9995D8C5E0DDA4A8FF9D68EE666CE07A7F94F@exchsen0a1ma>


Chiku,

Use the 8.1.7 export utility to export the tables and the 9.2 import utility to import the tables.

He is probably using the 9.2 export utility to export - and the utility is looking for the 9.2 version export support tables.

Good Luck!

Tom Mercadante
Oracle Certified Professional

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

From: Chirag DBA [mailto:ChiragDBA_at_gmail.com] Sent: Thursday, October 07, 2004 6:13 AM 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 - 07:58:16 CDT

Original text of this message

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