Home » RDBMS Server » Server Utilities » Import Utility Hang
icon8.gif  Import Utility Hang [message #265804] Fri, 07 September 2007 07:58 Go to next message
srelia
Messages: 4
Registered: September 2007
Junior Member
Hiya,

I was running a from user-touser import and my import operation got hung midway. There was nothing in the logs. There was plenty of space available. The cpu cycles and memeory was sufficient. Infact the server was practically idle. I added more datafiles to the tablespace. That didn't help either. Eventually somehow I was thrown out of the ssh session. I had to restart the import. I have 3 questions around this:

1)What could be the reason for the hang?
2)When doing a re-run of the import operation, is IGNORE=y the nest option?
3)What should be taken care of whilst re-running the operation? Should the user be dropped and re-created?

Please advise.

Thanks and Regards,
Rob
Re: Import Utility Hang [message #265810 is a reply to message #265804] Fri, 07 September 2007 08:10 Go to previous messageGo to next message
joy_division
Messages: 4643
Registered: February 2005
Location: East Coast USA
Senior Member
1) Maybe you got to a big table with a LONG datatype, which would bring the import to a crawl.

2 & 3) What kind of import? User or entire database?
Re: Import Utility Hang [message #265812 is a reply to message #265810] Fri, 07 September 2007 08:11 Go to previous messageGo to next message
srelia
Messages: 4
Registered: September 2007
Junior Member
It was hung for almost 24 hours. I doubt that it was a big table. It was a user import.
Re: Import Utility Hang [message #265846 is a reply to message #265812] Fri, 07 September 2007 10:21 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Quote:
1)What could be the reason for the hang?

In addition to JOY how many partitions table you have and data inside the tables.

Quote:
2)When doing a re-run of the import operation, is IGNORE=y the nest option?


Yes

Quote:
3)What should be taken care of whilst re-running the operation? Should the user be dropped and re-created?


No need because you using IGNORE clause,better if you can do.
Re: Import Utility Hang [message #265847 is a reply to message #265812] Fri, 07 September 2007 10:22 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
srelia wrote on Fri, 07 September 2007 07:11
It was hung for almost 24 hours. I doubt that it was a big table. It was a user import.



Whats the count of records in tables).
Re: Import Utility Hang [message #265860 is a reply to message #265804] Fri, 07 September 2007 12:03 Go to previous messageGo to next message
joy_division
Messages: 4643
Registered: February 2005
Location: East Coast USA
Senior Member
When you say there was plenty of space available, do you mean space in the database or space on the filesystem where archive logs/alert logs/autoextensible tablespaces reside?
Re: Import Utility Hang [message #265926 is a reply to message #265804] Sat, 08 September 2007 00:16 Go to previous message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

There are seveal things that your import utility may hanged.
The most 1) insuficinet disk space
2)In the tablespace data file is full and autoextend is off.
3)In the tablespace the user has not quota permission.

I stronngly suggest you to see you (default) tablespace and make autoextend on+ maxsize unlimited.

I hope you problem will go down.
Previous Topic: ORA-00942 (merged)
Next Topic: How to recreate a tablespace
Goto Forum:
  


Current Time: Thu Dec 08 12:23:45 CST 2016

Total time taken to generate the page: 0.14313 seconds