Home » RDBMS Server » Backup & Recovery » Import dmp in 10g express
Import dmp in 10g express [message #229853] Tue, 10 April 2007 03:11 Go to next message
joosthaarman
Messages: 2
Registered: April 2007
Junior Member
I want to import a database from Oracle 8.1.7.3 enterprise edition to 10 g Express i have de dmp file from Oracle 8 Prod.dmp

i give the following command :

impdp prod/prod dumpfile=prod.dmp logfile=import.log [enter]

i get the following error:

Ora-39001: invalid argment value
Ora-39000: bad dump file specification
Ora-39143: dump file "C:\oraclexe\app\oracle\admin\XE\dpdump\prod.dmp" may be an original export dump file

Does somebody know how to solve this ?
Or know a other solution ? to import de dmp file?

Greetz

J

Student




Re: Import dmp in 10g express [message #229870 is a reply to message #229853] Tue, 10 April 2007 03:46 Go to previous messageGo to next message
rtjk
Messages: 33
Registered: February 2005
Member
Try with "imp" instead of "impdp". (Assumed u have taken the dump using the oracle8 export).




[Updated on: Tue, 10 April 2007 03:51]

Report message to a moderator

icon9.gif  Re: Import dmp in 10g express [message #229953 is a reply to message #229870] Tue, 10 April 2007 07:11 Go to previous message
joosthaarman
Messages: 2
Registered: April 2007
Junior Member
I tried this

Import tool:


C:\oraclexe\app\oracle\product\10.2.0\server\BIN>imp prod/prod full=yes

Import: Release 10.2.0.1.0 - Production on Tue Apr 10 14:58:28 2007

Copyright (c) 1982, 2005, Oracle. All rights reserved.


Connected to: Oracle Database 10g Express Edition Release 10.2.0.1.0 - Productio
n

Export file created by EXPORT:V08.01.07 via conventional path
import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
export client uses WE8ISO8859P1 character set (possible charset conversion)
IMP-00067: Could not convert to server character set's handle
IMP-00000: Import terminated unsuccessfully

Importdp tool:


C:\oraclexe\app\oracle\product\10.2.0\server\BIN>impdp prod/prod

Import: Release 10.2.0.1.0 - Production on Tuesday, 10 April, 2007 15:00:58

Copyright (c) 2003, 2005, Oracle. All rights reserved.

Connected to: Oracle Database 10g Express Edition Release 10.2.0.1.0 - Productio
n
ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-39143: dump file "C:\oraclexe\app\oracle\admin\XE\dpdump\expdat.dmp" may be
an original export dump file
Previous Topic: How to verify the validity of an Export dump
Next Topic: Questionable Statistics
Goto Forum:
  


Current Time: Sat Dec 14 01:14:16 CST 2024