今天在用impdp导入时,Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX卡在建索引的过程一直不动,也不报错,重试了好几遍还是这样。
于是登录到oracle的导入日志查看是什么情况。查看alert日志发现:
statement in resumable session ‘SYSTEM.SYS_IMPORT_FULL_06.1‘ was suspended due to
ORA-01652: unable to extend temp segment by 1024 in tablespace USERS
USERS表空间不足导致的报错,随后加大表空间:
alter tablespace USERS add datafile ‘/data/oradata/eas/user06.dbf‘ size 31g
但是导到一半的时候又报错了:
Co