pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedExp/Imp Problems...
2+ messages / 2 participants
[nested] [flat]
* Exp/Imp Problems...
@ 2001-05-15 14:52 ameet <ameet@imail.activ8tech.com>
2001-05-17 01:22 ` Re: Exp/Imp Problems... Roberto Mello <rmello@cc.usu.edu>
0 siblings, 1 reply; 2+ messages in thread
From: ameet @ 2001-05-15 14:52 UTC (permalink / raw)
To: pgsql-sql
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.
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Exp/Imp Problems...
2001-05-15 14:52 Exp/Imp Problems... ameet <ameet@imail.activ8tech.com>
@ 2001-05-17 01:22 ` Roberto Mello <rmello@cc.usu.edu>
0 siblings, 0 replies; 2+ messages in thread
From: Roberto Mello @ 2001-05-17 01:22 UTC (permalink / raw)
To: ameet <ameet@imail.activ8tech.com>; +Cc: pgsql-sql
On Tue, May 15, 2001 at 08:22:36PM +0530, ameet wrote:
>
> 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.
Heh? I think you asked this on the wrong list. This list is for help
with the PostgreSQL database. For Oracle support you should look for an
Oracle forum/list or call their support.
http://www.arsdigita.com/bboard (web/db forum) has lots of Oracle
users.
-Roberto
--
+----| http://fslc.usu.edu USU Free Software & GNU/Linux Club |------+
Roberto Mello - Computer Science, USU - http://www.brasileiro.net
http://www.sdl.usu.edu - Space Dynamics Lab, Developer
"Call it a hunch." -- Quasimodo
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2001-05-17 01:22 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-05-15 14:52 Exp/Imp Problems... ameet <ameet@imail.activ8tech.com>
2001-05-17 01:22 ` Roberto Mello <rmello@cc.usu.edu>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox