| Import ... [message #398187] |
Wed, 15 April 2009 10:10  |
zanric
Messages: 6
Registered: April 2009
|
Junior Member |
|
|
Dear All
After import of 17 mln of records the output log file is stopped.
No line is written.
What i have to do?
I'm waiting about 8h
Please help me.
|
|
|
|
| Re: Import ... [message #398188 is a reply to message #398187] |
Wed, 15 April 2009 10:13  |
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
|
Senior Member |
|
|
Have a look at v$session and check you're still connected to the Db.
Have a look at v$session_wait ans see what the session is waiting on.
What was the last entry in the log file, and what is the screen currently showing?
|
|
|
|
|
|
| Re: Import ... [message #398196 is a reply to message #398194] |
Wed, 15 April 2009 10:46 |
ThomasG
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany
|
Senior Member |
|
|
Then there have been 17.965 records imported and the database is doing something else now.
Probably creating indexes or stuff. Which you might find out if you follow JRowbottoms other advice.
|
|
|
|
| Re: Import ... [message #398199 is a reply to message #398187] |
Wed, 15 April 2009 11:03 |
 |
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
|
Senior Member |
|
|
>Please help me.
You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
Please, please, please Read & Follow Posting Guidelines above.
Go to the section labeled "Practice" & do as directed.
You need to determine the SESSION ID (SID) of the import process.
Then repeatedly run the following SQL.
SELECT * FROM V$SESS_IO WHERE SID = <import_sessionID>;
if the import is still actively processing data,
then one or more columns will display ever increasing values.
If the values are static, the import session is comatose & should be aborted.
[Updated on: Wed, 15 April 2009 11:37] Report message to a moderator |
|
|
|
| Re: Import ... [message #398213 is a reply to message #398187] |
Wed, 15 April 2009 12:59 |
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
|
Senior Member |
|
|
|
Also possible you have run out of file system space where your archive logs are. Many many possibilities, some being mentioned here already.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
