RE: Export error ..

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_at_gmail.com] Sent: Thursday, October 07, 2004 9:16 AM To: thomas.mercadante_at_labor.state.ny.us
Cc: ChiragDBA_at_gmail.com; oracle-l_at_freelists.org; askdba_at_freelists.org; dba_gurus_at_yahoogroups.com
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_at_labor.state.ny.us> 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_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 ?????
>
> - Chiku
> --
> http://www.freelists.org/webpage/oracle-l
> --
> http://www.freelists.org/webpage/oracle-l
>

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