oracle导入时要,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;