export/ import job monitor from data-pump (STATUS/ stop immediate)
when export/import running if you want to check status of use below procedure to check.
step1:
check JOB_NAME using dba_datapump_job.(like below ).
set lines 300;
set pages 300;
COL owner_name FORMAT a10;
COL job_name FORMAT a20
COL state FORMAT a11
COL operation LIKE state
COL job_mode LIKE state
select * from dba_datapump_jobs;
ouput like below
OWNER_NAME JOB_NAME OPERATION JOB_MODE STATE
---------- -------------------- ----------- ----------- -----------
OPER SYS_IMPORT_SCHEMA_01 IMPORT SCHEMA EXECUTING
step2: now you know current running job
impdp userid=usenmae/password attach=SYS_IMPORT_SCHEMA_01
(or)
impdp attach=SYS_IMPORT_SCHEMA_01 => eneter next it will ask user to connect you can connect thoutgh "/ as sysdba"
ouput like below some lines remove due to naming or safety perpous
Job: SYS_IMPORT_SCHEMA_01
Owner: OPER
Operation: IMPORT
Creator Privs: TRUE
Start Time:
Mode: SCHEMA
Instance:
Max Parallelism:
EXPORT Job Parameters:
CLIENT_COMMAND
IMPORT Job Parameters:
Parameter Name Parameter Value:
C
State: EXECUTING
Bytes Processed: 0
Current Parallelism: 1
Job Error Count: 0
Dump File:
Worker 1 Status:
Process Name: DW00
State: EXECUTING
Object Schema:
Object Name:
Object Type: SCHEMA_EXPORT/TABLE/TABLE_DATA
Completed Objects: 1
Completed Rows: 3,437,594
Completed Bytes: 40,101,139,632
Percent Done: 2
Worker Parallelism: 1
Import>
---------------if you want check status eneter command
Import>STATUS
---------------if you want check STOP_JOB eneter command
Import>STOP_JOB=IMMEDIATE
---------------and then it will ask you to conform if you really want to stop yes and proceed.
Are you sure you wish to stop this job ([yes]/no): yes
HELP
STATUS
CONTINUE_CLIENT
KILL_JOB
START_JOB
PARALLEL
STOP_JOB
-----------------all suggestion are welcome to receive-----------------------------
Comments
Post a Comment