Change the executed SQL statement to a Linux background process

A few days ago, when operating the database, you needed to execute SQL statements that took a long time. However, at that time, the LAN network was not good and frequent disconnection occurred.

In this case, you need to add the statement to the background process on the Oracle server for execution. The procedure is as follows:

1. First, write the SQL statements to be executed as scripts and store them in SQL. SQL. And place it in a path on the database server.

2. Run the following linux Command:

Nohup sqlplus username/password @ host connection string @ created executable file &

For example: [LINUX community www.LinuxIDC.com]

Nohup sqlplus Oracle/Oracle @ orcl @ SQL. SQL &

You can. In this way, you are not afraid of network interruptions and the impact on SQL Execution. The SQL Execution result can be viewed in the nohup file.