expdb/impdb 数据导入导出报错停止任务方法

查询正在执行的任务

SELECT * FROM DBA_DATAPUMP_JOBS;

SELECT * FROM DBA_DATAPUMP_SESSIONS;

OWNER_NAME	JOB_NAME	OPERATION	JOB_MODE	STATE	DEGREE	ATTACHED_SESSIONS	DATAPUMP_SESSIONS
aideqi	SYS_IMPORT_FULL_01	IMPORT	FULL	NOT RUNNING	0	0	0
aideqi	SYS_EXPORT_TABLE_01	EXPORT	TABLE	NOT RUNNING	0	0	0
OWNER_NAME	JOB_NAME	INST_ID	SADDR	SESSION_TYPE

expdp 'aideqi/"aideqi"' DIRECTORY=EXPDP_DIR parallel=8 dumpfile=aideqi_0920.dump logfile=aideqi_0920.log tables=aideqitest cluster=n;

impdp 'aideqidb/"aideqidb"'  DIRECTORY=EXPDP_DIR dumpfile=aideqi_0920.dump logfile=aideqi_0920.log remap_schema=aideqi:aideqidb remap_tablespace=aideqi:aidqi remap_table=aideqitest:aideqitest_tmp table_exists_action=append parallel=8 cluster=n

导出或者导入过程中报错解决办法，由于报错任务没有停止别的导入导出命令无法执行，本文提供两种处理方式：

1.在导数页面直接ctrl+c，退出当前导入导出操作

Import>
--查看任务执行状态
Import>status
Job: SYS_IMPORT_FULL_01
  Operation: IMPORT                         
  Mode: FULL                           
  State: EXECUTING                      
  Bytes Processed: 0
  Current Parallelism: 8
  Job Error Count: 0
  Dump File: /data/expdp_dir/aideqi_0920.dump
  
Worker 1 Status:
  Process Name: DW00
  State: EXECUTING                      
  Object Schema: aideqidb
  Object Name: aideqi_test
  Object Type: TABLE_EXPORT/TABLE/TABLE_DATA
  Completed Objects: 1
  Completed Rows: 108,547,231
  Completed Bytes: 23,332,076,760
  Percent Done: 97
  Worker Parallelism: 8
--停止当前任务
Import> stop_job=immediate
Are you sure you wish to stop this job ([yes]/no): yes

等这个命令执行完再次查看最上边两个表内容，DBA_DATAPUMP_JOBS这个表中任务的执行状态应该是NOT RUNNING，DBA_DATAPUMP_SESSIONS这个表应该是空的，这种情况才能算是任务停止

2.直接删除运行表

文章开头查出两张表的结果集中包含系统表SYS_IMPORT_FULL_01

drop table SYS_IMPORT_FULL_01;

这个需要等5~10分钟吧，看情况，再次复查DBA_DATAPUMP_JOBS、DBA_DATAPUMP_SESSIONS两张表，两张表应该都查不到相关SYS_IMPORT_FULL_01表的信息，此时任务停止完成

希望本文能帮到你，转载请注明出处