Received: from postgresql.org.org (webmail.postgresql.org [216.126.85.28]) by postgresql.org (8.11.3/8.11.1) with SMTP id f4GJtLA51977 for ; Wed, 16 May 2001 15:55:21 -0400 (EDT) (envelope-from pgsql-sql-owner@postgresql.org) Received: from imail.activ8tech.com ([203.199.69.86]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f4FEqSA39612 for ; Tue, 15 May 2001 10:52:28 -0400 (EDT) (envelope-from ameet@imail.activ8tech.com) Date: Tue, 15 May 2001 20:22:36 +0530 Message-Id: <200105152022.AA134676672@imail.activ8tech.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii From: "ameet" Reply-To: To: Subject: Exp/Imp Problems... X-Mailer: X-Archive-Number: 200105/176 X-Sequence-Number: 2993 We are trying to export a tablespace 'XYZ' from an Oracle8i Database server to a Oracle 9i Application Server, both residing on different machines. As far the Export is concerned,we are succesfully able to create the required 'abc.dmp' file on the 8i server. We then copy the 'abc.dmp' file and the 'XYZ.DBF'(approx. 150 MB) to the machine where the 9i server is located. And finally when we try to utilise the import utility from the 9i server,it gives us the following messages. --------------------- Export file created by EXPORT:V08.01.07 via conventional path About to import transportable tablespace(s) metadata... import done in WE8ISO8859P1 character set and WE8ISO8859P1 NCHAR character set . importing SYS's objects into SYS IMP-00017: following statement failed with ORACLE error 19722: "BEGIN sys.dbms_plugts.checkDatafile(NULL,1722002184,8,64000,7,8,0,0,21160" "6,3279934,1,NULL,NULL,NULL,NULL); END;" IMP-00003: ORACLE error 19722 encountered ORA-19722: datafile c:\a\b\XYZ.dbf is an incorrect version ORA-06512: at "SYS.DBMS_PLUGTS", line 1577 ORA-06512: at line 1 IMP-00000: Import terminated unsuccessfully -------------------------------- Your help will be appreciated.Kindly acknowledge. Ameet Setlur.