Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
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.
1 | SQL> desc dba_datapump_jobs; |
In order to see the query results in a single line, the set linesize command is run.
1 2 3 | SQL> set linesize 9000; SQL> select OWNER_NAME, JOB_NAME, OPERATION, JOB_MODE, STATE from dba_datapump_jobs; |
So:
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.
1 | -bash-3.2$ expdp "'/ as sysdba'" attach=sys.SYS_EXPORT_SCHEMA_02 |
You exit the interactive mode with exit or exit_client.
