How to kill IMPDP/EXPDP job: nohup impdp \"/ as sysdba\" directory=PUMP dumpfile=FULL_EXPORT.dmp logfile=FULL_IMPORT.log & check import process from database: sqlplus / as sysdba SQL*Plus: Release 12.1.0.2.0 Production on Thu Mar 21 10:01:05 2019 Copyright (c) 1982, 2014, Oracle. All rights reserved. Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options SQL> select JOB_NAME,state from dba_datapump_jobs; JOB_NAME STATE ------------------------------ ------------------------------ SYS_IMPORT_FULL_02 EXECUTING SYS_IMPORT_SCHEMA_02 NOT RUNNING SYS_IMPORT_SCHEMA_01 NOT RUNNING SYS_IMPORT_FULL_01 NOT RUNNING SYS_IMPORT_SCHEMA_03 NOT RUNNING exit You can see that IMPORT process is run with SYS_IMPORT_FULL_02 EXECUTING name like above. We can attach or connect to this process like following: impdp \"/ as sysdba\" attach=SYS_IMPORT_FULL_02 check st
Posts
Showing posts from July 26, 2020