[askdba] Re: Export error ..

  • From: Chirag DBA <ChiragDBA@xxxxxxxxx>
  • To: thomas.mercadante@xxxxxxxxxxxxxxxxx
  • Date: Thu, 7 Oct 2004 18:45:52 +0530

but as the version from where he is trying to export is newer then the
production machine. so I don think there can be any problem Thomas.

 - Chiku


On Thu, 7 Oct 2004 09:02:30 -0400, Mercadante, Thomas F
<thomas.mercadante@xxxxxxxxxxxxxxxxx> wrote:
> 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@xxxxxxxxx]
> Sent: Thursday, October 07, 2004 6:13 AM
> To: oracle-l@xxxxxxxxxxxxx; askdba@xxxxxxxxxxxxx; dba_gurus@xxxxxxxxxxxxxxx
> 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
>

Other related posts: