Home » RDBMS Server » Server Utilities » Import ...
Import ... [message #398187] Wed, 15 April 2009 10:10 Go to next message
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 Go to previous messageGo to next message
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 #398194 is a reply to message #398188] Wed, 15 April 2009 10:39 Go to previous messageGo to next message
zanric
Messages: 6
Registered: April 2009
Junior Member
the lastrow in the output file is

imported 17.965... records
Re: Import ... [message #398196 is a reply to message #398194] Wed, 15 April 2009 10:46 Go to previous messageGo to next message
ThomasG
Messages: 3212
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 Go to previous messageGo to next message
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 Go to previous message
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.
Previous Topic: Export using Batch but hiding cmd prompt
Next Topic: SQL LOADER INDEX ISSUE
Goto Forum:
  


Current Time: Mon Dec 23 20:25:19 CST 2024