Wednesday , May 29 2024

Export/Import Job Attach

We can monitor the status of an export/import operation running in the background by attaching it with the ATTACH parameter.

For this, we first need to know the owner of the running process.

The owner of the running process can be seen by querying the DBA_DATAPUMP_JOBS view.

In order to see the query results in a single line, the set linesize command is run.


It is stated that the job that exports a schema named SYS_EXPORT_SCHEMA_02, whose owner is SYS user, is running.

As seen above, since the owner of the job is SYS, we will do the ATTACH transaction to him.

You exit the interactive mode with exit or exit_client.



Leave a Reply

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