OraFAQ Forum: Server Utilities

Home » RDBMS Server » Server Utilities » import problem

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

import problem [message #251762]

Mon, 16 July 2007 10:19

zoltanp
Messages: 58
Registered: March 2005
Location: Hungary

Member

Our client use several oracle RDBMS version on various platform.
(8i->10g)

Our software patch always contain a small .dmp file.
I make it in Oracle8i Enterprise Edition Release 8.1.7.4.1

In Oracle Database 10g Enterprise Edition Release 10.2.0.2.0,
the import is succesfull(i checked the data of tables), but after the importing process the imp.exe not return to the operating system.

It is wait for ever.....

What is my fault?

Thanks,
Zolt�n Patalenszki

Report message to a moderator

Re: import problem [message #251763 is a reply to message #251762]

Mon, 16 July 2007 10:36

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

Just kill the IMP process by OS command.

Report message to a moderator

Re: import problem [message #251770 is a reply to message #251763]

Mon, 16 July 2007 10:59

zoltanp
Messages: 58
Registered: March 2005
Location: Hungary

Member

OK.I kill the imp process,
but our user and my boss don't like to do that.

Zolt�n Patalenszki

Report message to a moderator

Re: import problem [message #251773 is a reply to message #251770]

Mon, 16 July 2007 11:03

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

Again try import for a small table and check wheather it still hangs..

Report message to a moderator

Re: import problem [message #251794 is a reply to message #251762]

Mon, 16 July 2007 12:19

Littlefoot
Messages: 21826
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

zoltanp

... but after the importing process the imp.exe not return to the operating system. It is wait for ever...

Could you copy the last few lines of the IMP session and paste it here (so that we could see it)?

Report message to a moderator

Re: import problem [message #251882 is a reply to message #251794]

Tue, 17 July 2007 01:22

zoltanp
Messages: 58
Registered: March 2005
Location: Hungary

Member

Hi!

I imported a smaller table, the symptom is the same.

I attached the screen of the import process.
It's hungarian version, but i hope it's not problem.

In the server side the events is "SQL*Net more data from client",
and the last statement is "ALTER SESSION SET EVENTS '28657 TRACE NAME CONTEXT FOREVER, LEVEL 1'"

Thanks,

Zolt�n Patalenszki