OraFAQ Forum: Server Utilities

Home » RDBMS Server » Server Utilities » hanged import

Tue, 14 August 2007 05:16

anamika_025
Messages: 81
Registered: July 2007
Location: Indore

Member

i have export after that i m doing import

after some time import is hanged
what to do

Tue, 14 August 2007 05:23

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

Check out disk space usage. In unix use

df -h

to see disk usage. Possibly out of disk space. Delete unnecessary files and reimport.

Tue, 14 August 2007 05:24

anamika_025
Messages: 81
Registered: July 2007
Location: Indore

Member

i m using window

Tue, 14 August 2007 06:13

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Check properties of your disk.

Regards
Michel

Tue, 14 August 2007 09:04

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

What makes you think it is hanged? I have run an import that takes 6 hours on a single table due to a LONG datatype.

Tue, 14 August 2007 15:56

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

Senior Member
Account Moderator

I'd suggest you to make it SHORT prior to import session /forum/fa/917/0/

This is the tool: LtS Now!

[Updated on: Tue, 14 August 2007 15:59]

Previous Topic:	External Table - Wrong line number in error log.
Next Topic:	import utilities (Merged)

Goto Forum:

]

Current Time: Wed Dec 25 09:47:11 CST 2024