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;