What may be going on ?

[badrinathn]

Hi,

I was inserting a bulk data from one table to a partitioned table. I am using a terminal emulator which automatically ends connection with the host every 10-15 minutes.

Thus my session was closed. I donot know if the inserts will still be continuing or not. When queried on those tables, there will be a lock, so I am unable to get even the record count.

What should I do?
Badrinath

[tamilselvan]

Query from v$session for INACTIVE sessions and kill them. The transaction will be rolled back.

[badrinathn]

But this is a ever occuring problem, so is there any way I can submit this 'sql ' to a background process, so that even if the terminal is off, still the inserts keep going on;
BAdrinath

[nirasha]

Hello there,

I am not sure if I can help, but if it is unix, then:

You can send it on command line and end it with an & (to say run in the background).

eg if an sql script:
sqlplus system/manager @test.sql &

Good luck,
Nirasha

[pando]

& wont work since the process would be killed after your session ends, may you could try nohup, check unix manual for this command

[jmodic]

Why don't you wrap your INSERT into PL/SQL procedure and invoke that with DBMS_JOB? As yoon as you submit a job with dbms_job you can log off, since the yob is carried out entirely on server.

[hanselrl]

u can use the "AT" function of UNIX in running the script.
do.

$ at now
at> sqlplus system/manager @test.sql
at> ^D
$

[Dave_A]

Combining the nohup and & solutions from previous posts is the way I tend to do it. If you do this, you may want to redirect any output to a log file (default is nohup.out)

e.g.

nohup sqlplus system/manager @test.sql &