Home » RDBMS Server » Server Administration » NO import !
icon5.gif  NO import ! [message #306780] Sun, 16 March 2008 15:24 Go to next message
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 Exclamation Question
Re: NO import ! [message #306784 is a reply to message #306780] Sun, 16 March 2008 17:04 Go to previous messageGo to next message
BlackSwan
Messages: 25033
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?
icon1.gif  Re: NO import ! [message #306789 is a reply to message #306784] Sun, 16 March 2008 18:42 Go to previous messageGo to next message
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
  • Attachment: hr.zip
    (Size: 98.54KB, Downloaded 122 times)

[Updated on: Sun, 16 March 2008 19:02]

Report message to a moderator

Re: NO import ! [message #306813 is a reply to message #306780] Sun, 16 March 2008 23:34 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Check the tablespace size. They are full or not.
Re: NO import ! [message #306944 is a reply to message #306813] Mon, 17 March 2008 06:07 Go to previous message
Hany Freedom
Messages: 256
Registered: May 2007
Location: Egypt
Senior Member

Quote:
Check the tablespace size. They are full or not.

how can i do that ?
Previous Topic: archive log file get increased very high
Next Topic: ASM problem
Goto Forum:
  


Current Time: Fri Dec 02 22:58:13 CST 2016

Total time taken to generate the page: 0.04894 seconds