 Import Utility Hang [message #265804] |
Fri, 07 September 2007 07:58  |
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  |
joy_division
Messages: 4963
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 #265846 is a reply to message #265812] |
Fri, 07 September 2007 10:21 |
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 |
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 |
joy_division
Messages: 4963
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?
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
