OraFAQ Forum: Server Utilities » import from client 9.2.0.1, it always hang

Home » RDBMS Server » Server Utilities » import from client 9.2.0.1, it always hang (oracle 9208 window xp)

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

import from client 9.2.0.1, it always hang [message #345515]

Wed, 03 September 2008 22:41

Mrs Xu
Messages: 9
Registered: December 2005
Location: China

Junior Member

1. Client 9.2.0.1
2. Server 9.2.0.8
3. import from client 9.2.0.1, it always hang.
import trace shows:
ALTER SESSION SET EVENTS '28657 TRACE NAME CONTEXT FOREVER, LEVEL 1'
4. import statement:
imp userid=trade/trade@test fromuser=yrlo32 touser=trade feedback=10000 buffer=3000000 file=f:\all_0415sp1.d
mp statistics=none log=aaaa.log
5. This issue can be reproduced at will
Eventhough create 2 test tables and export them, imported those 2 tables. it will hang a
lso.
6. Using client 9.2.0.8 works, but I unable to upgrade the clinet to 9208.

thanks a lot.

Report message to a moderator

Re: import from client 9.2.0.1, it always hang [message #345531 is a reply to message #345515]

Thu, 04 September 2008 00:41

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

but I unable to upgrade the clinet to 9208

why?

and did you found any error in alertsid.log file during database is hang.

Report message to a moderator

Re: import from client 9.2.0.1, it always hang [message #345639 is a reply to message #345531]

Thu, 04 September 2008 06:19

Mrs Xu
Messages: 9
Registered: December 2005
Location: China

Junior Member

We have too many oracle client to upgrade and My clients disagree upgrade the client. there is nothing about hang in alertsid.log

Report message to a moderator

Re: import from client 9.2.0.1, it always hang [message #345715 is a reply to message #345639]

Thu, 04 September 2008 10:27

macdba
Messages: 27
Registered: May 2005
Location: US

Junior Member

try exporting using 9.2.0.1 client and then use the same client to import

regards
--Mak

Report message to a moderator

Previous Topic:	Importing CSV file into multiple tables using a script
Next Topic:	TKPROF error

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 24 11:16:35 CST 2024