Monday , April 22 2024

Stop The Job

It may be necessary to temporarily stop a running export/import process for some reason. In this case, we may need to attach it first.

1. Let’s have an export as below.

2. From another terminal window, connect to the database with SQL*Plus and learn the owner of the job and the name of the job with the following query.

3. Attach expdp tool from another terminal window.

4. The job is stopped.

5. The Attach process is restarted and the job is started.

6. When the SQL statement is run again, the job is seen to be completed.

It is then seen that it has been removed from the list.



Leave a Reply

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