impdp导入备份数据的时候,碰到了temp表空间不足。
ORA-39171: Job is experiencing a resumable wait.
ORA-01652: unable to extend temp segment by 128 in tablespace TEMP
ORA-01652: unable to extend temp segment by 128 in tablespace TEMP
紧接着又碰到了undo表空间不足
ORA-39171: Job is experiencing a resumable wait.
ORA-30036: unable to extend segment by 8 in undo tablespace 'UNDOTBS1'
ORA-30036: unable to extend segment by 8 in undo tablespace 'UNDOTBS1'
在老的imp工具下,我们可以使用commit=y来解决这个问题,但是impdp却没这个参数。查了一下metalink,找到了解决办法,在
Run Out Of Space On Undo Tablespace Using Import/Export DataPump [ID 735366.1]
中描述有办法,使用参数:access_method=direct_path
执行成功: