OraFAQ Forum: Server Utilities » import dmp exported by DB 10gR1

Home » RDBMS Server » Server Utilities » import dmp exported by DB 10gR1 (DB 10gR2 , Win XP SP2)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

import dmp exported by DB 10gR1 [message #355372]

Thu, 23 October 2008 19:10

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 ?

Report message to a moderator