OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » NO import !

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

NO import ! [message #306780]

Sun, 16 March 2008 15:24

Hany Freedom
Messages: 256
Registered: May 2007
Location: Egypt

Senior Member

I made that in system schema :-

create user de identified by l;
grant dba to de;
grant create table to de;
grant connect , resource to de;

and then went to RUN to write
every code of those separately :-

exp system/l@orcl file=c:\hr.dmp owner=hr log=hr.log

imp system/l@orcl file=c:\hr.dmp fromuser=hr touser=de log=de.log

exp system/l@orcl file=c:\scott.dmp owner=scott log=scott.log

imp system/l@orcl file=c:\scott.dmp fromuser=scott touser=de log=de.log

first one pass ok

exp system/l@orcl file=c:\hr.dmp owner=hr log=hr.log

but second one stopped like in the following screen :-

http://img230.imageshack.us/img230/7270/deimpti6.png

I waited for more 20 minutes without any progress ...... same problem happened with the fourth code :-

imp system/l@orcl file=c:\scott.dmp fromuser=scott touser=de log=de.log

while the third code ( that I made of course before the fourth one ) pass ok :-

exp system/l@orcl file=c:\scott.dmp owner=scott log=scott.log

that's mean the exporting operation have no problem , but the importing operation have problem .

I wonder what is this problem and how can be solve Rolling Eyes

Report message to a moderator

Re: NO import ! [message #306784 is a reply to message #306780]

Sun, 16 March 2008 17:04

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Post the contents of the import log files.

When doing the import & export are you logged directly onto the same system where Oracle RDBMS is installed & running?

Report message to a moderator

Re: NO import ! [message #306789 is a reply to message #306784]

Sun, 16 March 2008 18:42

Hany Freedom
Messages: 256
Registered: May 2007
Location: Egypt

Senior Member

Quote:

Post the contents of the import log files.

I attached the Log files.

Quote:

When doing the import & export are you logged directly onto the same system where Oracle RDBMS is installed & running?

well .... I'm not sure if I quite understand what you mean .... but I installed the Oracle in C partition.
and the Four Codes :-

exp system/l@orcl file=c:\hr.dmp owner=hr log=hr.log

imp system/l@orcl file=c:\hr.dmp fromuser=hr touser=de log=de.log

exp system/l@orcl file=c:\scott.dmp owner=scott log=scott.log

imp system/l@orcl file=c:\scott.dmp fromuser=scott touser=de log=de.log

I executed everyone of them separately in RUN ( start > Run ).
and the files that attached with this message were in { C:\ }

that's all ..... I hope my reply is clear ..... and I'm still waiting for the answer Rolling Eyes