Sqlplus run in background with nohup

Sometimes you have to run a query that takes FOREVER, and you want to go home with your laptop. If you have access to a server with SQL*Plus, you can run the query there in the background. Here’s how:

nohup sqlplus /as sysba @file.sql &

show output

tail -123f nohup.out

have a good day.

 

Hits: 9

Leave a Reply

Your email address will not be published. Required fields are marked *