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

Popular posts from this blog

SQL Tuning Task Creation ORA-13780: SQL statement does not exist.

Shareplex some commands

ORA-1092 : opitsk aborting process