Home » RDBMS Server » Server Utilities » import dmp exported by DB 10gR1 (DB 10gR2 , Win XP SP2)
icon4.gif  import dmp exported by DB 10gR1 [message #355372] Thu, 23 October 2008 19:10 Go to next message
Hany Freedom
Messages: 256
Registered: May 2007
Location: Egypt
Senior Member

my friend exported his schema by someway , and he using ORACLE DB 10gR1 , and when I took the dmp file from him , I tried to import it to my new - empty - schema ..... by the way I use DB 10gR2 ... I did like that :-

drop user Reports cascade;
create user Reports identified by h;
grant dba to Reports;


and when I wrote the import statement in command prompt :-
imp Reports/h@orcl file=C:\GER.dmp full=y

it stops like in this photo :-

http://img372.imageshack.us/img372/6273/dmperrhy6.png

and I ensured that the GER.dmp on Drive C and I waited for long time but I didn't saw any progress , it just stops for this point.

any suggests or solutions ?
Re: import dmp exported by DB 10gR1 [message #355420 is a reply to message #355372] Fri, 24 October 2008 00:38 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Is there any other user connected? Maybe holding locks on ULTRA's objects?
Not sure if imp would wait for that..
Re: import dmp exported by DB 10gR1 [message #355535 is a reply to message #355420] Fri, 24 October 2008 15:45 Go to previous message
Hany Freedom
Messages: 256
Registered: May 2007
Location: Egypt
Senior Member

that not logical ...... anyway I uploaded the file ..... and you see what version is :-

http://rapidshare.com/files/157218624/imp.zip.html
Previous Topic: ORA 7445
Next Topic: importing dump in oracle 10g
Goto Forum:
  


Current Time: Thu Dec 08 02:20:09 CST 2016

Total time taken to generate the page: 1.66950 seconds