To run sql statements in background
Copy all the sql statements to a file name test.sql on the unix server
Then run the following using nohup
nohup sqlplus / as sysdba @test.sql &
or
nohup sqlplus USERNAME/password@DBNAME @test.sql &
Copy all the sql statements to a file name test.sql on the unix server
Then run the following using nohup
nohup sqlplus / as sysdba @test.sql &
or
nohup sqlplus USERNAME/password@DBNAME @test.sql &
view output in nohup.out
No comments:
Post a Comment