RE: Export error ..
- From: "Mercadante, Thomas F" <thomas.mercadante@xxxxxxxxxxxxxxxxx>
- To: 'Chirag DBA' <ChiragDBA@xxxxxxxxx>
- Date: Thu, 7 Oct 2004 09:20:10 -0400
What?
You are trying to export from an 817 database and import into a 9.2
database.
Use the 817 export utility and the 92 import utility.
Tom Mercadante
Oracle Certified Professional
-----Original Message-----
From: Chirag DBA [mailto:ChiragDBA@xxxxxxxxx]
Sent: Thursday, October 07, 2004 9:16 AM
To: thomas.mercadante@xxxxxxxxxxxxxxxxx
Cc: ChiragDBA@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx; askdba@xxxxxxxxxxxxx;
dba_gurus@xxxxxxxxxxxxxxx
Subject: Re: Export error ..
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
> --
> //www.freelists.org/webpage/oracle-l
> --
> //www.freelists.org/webpage/oracle-l
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
