Click here to Skip to main content
14,970,700 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I have use following commands for import data in to oracle 11g express which is exported from oracle 9i

impdp  BANKUSER/BANKUSER directory=KUMARS dumpfile=12345G2.dmp FULL='Y'

But it gives following error

ORA 39001:INVALID ARGUMENT VALUE
ORA 39000: BAD DUMP FILE SPESIFICATION
ORA 39143:DUMP FILE C:\KUMARS\12345G2.dmp MAY BE AN ORIGINAL DUMP FILE

Please give any solution to me!!!!!!!!!!!!!!!!!!

[edit]SHOUTING removed - OriginalGriff[/edit]
Posted
Updated 20-Dec-11 2:21am
v2
Comments
OriginalGriff 20-Dec-11 8:21am
   
DON'T SHOUT. Using all capitals is considered shouting on the internet, and rude (using all lower case is considered childish). Use proper capitalisation if you want to be taken seriously.

1 solution

AFAIK expdp does not exist for 9i so you cannot directly import it in 11g. If you have used exp in 9i then use imp in 11g to import the data.
   
Comments
kumar_jadhav 23-Dec-11 23:49pm
   
Thanks!!!!!!
Wendelius 24-Dec-11 3:07am
   
You're welcome :)

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900