Oracle-导入数据时报错：ORA-39171、ORA-01652

ORA-39082: Object type ALTER_PROCEDURE:"AMI"."PROC_DB_HEALTH_SQL_SECURITY" created with compilation warnings
ORA-39082: Object type ALTER_PROCEDURE:"AMI"."PROC_S_TBS_GROW_MONTH" created with compilation warnings
ORA-39171: Job is experiencing a resumable wait./INDEX
ORA-01652: unable to extend temp segment by 128 in tablespace BPAS
ORA-39171: Job is experiencing a resumable wait.
ORA-01652: unable to extend temp segment by 128 in tablespace BPAS
ORA-39171: Job is experiencing a resumable wait.
ORA-01652: unable to extend temp segment by 128 in tablespace BPAS
ORA-39171: Job is experiencing a resumable wait.
ORA-01652: unable to extend temp segment by 128 in tablespace BPAS
ORA-39171: Job is experiencing a resumable wait.
ORA-01652: unable to extend temp segment by 128 in tablespace BPAS
ORA-39171: Job is experiencing a resumable wait.
ORA-01652: unable to extend temp segment by 128 in tablespace BPAS

网上找了找大致意思是说表空间没有剩余空间进行存储。需要增加

增加时需要注意：在原有的dbf文件上面增加，看着顺序一点。

--查看表空间绝对路径
select name from v$datafile;

--查看临时表空间绝对路径
select name from v$tempfile;
alter tablespace BPAS add datafile '/home/oracle/oradata/bpas/bpas02.dbf' size 30G autoextend off;

--增加表空间并开启自动增加
alter tablespace BPAS add datafile '/home/oracle/oradata/bpas/bpas03.dbf' size 30G autoextend on;