ORA-39171: Job is experiencing aresumable wait. string
Cause: TheData Pump job is stalled with one or more of its sessions having a
resumable wait. Resumable waits aretypically caused by a non-expandable
tablespace running out of space. Thefollow-on message describes the nature of the
wait.
Action: Correctthe condition causing the wait. This will typically involve adding
datafiles to the tablespace that is full.
使用IMPDP全库导入的时候遇到报错,报错信息:
ORA-39171: Job isexperiencing a resumable wait.
ORA-30036: unableto extend segment by 8192 in undo tablespace 'UNDOTBS1'
解决方法:
1) 设置数据文件为自增,问题解决。
1) 添加数据文件
当提示ORA-39171报错时,马上给表空间添加新的数据文件:
alter tablespace XXX_DATA adddatafile '/path/to/xxx_data02.dbf' size 100M autoextendon next 10M;
[姜彦国1]DB的db_block_size 为8Kbytes