ORA-39171 Job is experiencing a resumable wait

现象

impdp报错：

ORA-39171: Job is experiencing a resumable wait.
ORA-01691: unable to extend lob segment CWAB.SYS_LOB0000116518C00007$$ by 8192 in tablespace CWAB
ORA-39171: Job is experiencing a resumable wait.
ORA-01691: unable to extend lob segment CWAB.SYS_LOB0000116518C00007$$ by 8192 in tablespace CWAB
ORA-39171: Job is experiencing a resumable wait.
ORA-01691: unable to extend lob segment CWAB.SYS_LOB0000116518C00007$$ by 8192 in tablespace CWAB
ORA-39171: Job is experiencing a resumable wait.
ORA-01691: unable to extend lob segment CWAB.SYS_LOB0000116518C00007$$ by 8192 in tablespace CWAB
ORA-39171: Job is experiencing a resumable wait.
ORA-01691: unable to extend lob segment CWAB.SYS_LOB0000116518C00007$$ by 8192 in tablespace CWAB

原因

表空间满了，可以添加数据文件，或者配置数据文件自动扩展，然后继续导入，而不必从头重新开始导入。

解决

How to restart Datapump

1. In the IMPDP command line, press CTRL-C to stop the job.
2. At the command line of the import
   Import> stop_job=immediate
   Are you sure you wish to stop this job ([yes]/no): y
3. Fix the tablespace error
4. Attach again the job. Check sqlplus>SELECT FROM DBA_DATAPUMP_JOBS;
   Use the job name which is something like "SYS_IMPORTFULL"

$impdp system/**** attach=SYS_IMPORT_FULL_01

5. At the command line of the import
   Import> start_job
6. Check sqlplus>SELECT * FROM DBA_DATAPUMP_JOBS; It is running again.