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@(protected)]
Sent: Thursday, October 07, 2004 9:16 AM
To: thomas.mercadante@(protected)
Cc: ChiragDBA@(protected); oracle-l@(protected); askdba@(protected);
dba_gurus@(protected)
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@(protected) > 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@(protected)]
> Sent: Thursday, October 07, 2004 6:13 AM
> To: oracle-l@(protected); askdba@(protected);
> dba_gurus@(protected)
> 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 (See ORA-00942.ora-code.com): 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
