From oracle-l-bounce@freelists.org Thu Oct 7 08:15:42 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i97DFgW09561 for ; Thu, 7 Oct 2004 08:15:42 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i97DFgI09556 for ; Thu, 7 Oct 2004 08:15:42 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 5603672C4CB; Thu, 7 Oct 2004 08:21:47 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 08693-20; Thu, 7 Oct 2004 08:21:47 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id BE1B572C4BA; Thu, 7 Oct 2004 08:21:46 -0500 (EST) Message-ID: X-Sybari-Trust: 193b3148 d5d84915 08448468 0000013d From: "Mercadante, Thomas F" To: "'Chirag DBA'" Cc: oracle-l@freelists.org, askdba@freelists.org Subject: RE: Export error .. Date: Thu, 7 Oct 2004 09:20:10 -0400 MIME-Version: 1.0 Content-type: text/plain Content-Transfer-Encoding: 8bit X-archive-position: 10791 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: thomas.mercadante@labor.state.ny.us Precedence: normal Reply-To: thomas.mercadante@labor.state.ny.us X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org 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@gmail.com] Sent: Thursday, October 07, 2004 9:16 AM To: thomas.mercadante@labor.state.ny.us Cc: ChiragDBA@gmail.com; oracle-l@freelists.org; askdba@freelists.org; dba_gurus@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 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@gmail.com] > Sent: Thursday, October 07, 2004 6:13 AM > To: oracle-l@freelists.org; askdba@freelists.org; > dba_gurus@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