Home » RDBMS Server » Server Utilities » the user data import problem in window 8
the user data import problem in window 8 [message #665319] Wed, 30 August 2017 00:44 Go to next message
adil shakeel
Messages: 47
Registered: August 2017
Member
Hi all,

I have a dump file dadu.dmp placed in E drive.

When i try to import from window 7 then there is no issue.

But when I try to import from window 8 there is error

IMP-00000: Import terminated unsuccessfully

In the windows 8 I opened CMD and did following

>imp
>e:\dadu.dmp

when I press entered the above error is displayed.

Now I have dedcided to import the full user data into oracle database by writing the following command into the Note pad and saving it with .bat extenstion.

Please guide me that the below command which I should write into that batch file is ok?

imp dadu/d@xe file=E:\dadu.dmp full=yes

Just guide me whether the above command into the bat file would import the whole data successfully in windows 8?
Re: the user data import problem in window 8 [message #665349 is a reply to message #665319] Thu, 31 August 2017 18:31 Go to previous message
ctvarner
Messages: 11
Registered: August 2017
Junior Member
I use expdp/impdp, so I'm not sure of the syntax for imp, but:

imp dadu/d@xe file=E:\dadu.dmp full=yes 

...in a .BAT file is identical to just entering that complete command on the command line. Point being, there's no magic to putting it in a .BAT...
Previous Topic: IMP-00010: not a valid export file, header failed verification
Next Topic: IMP-00017: following statement failed with ORACLE error 922
Goto Forum:
  


Current Time: Thu Mar 28 14:50:28 CDT 2024