ORA-25153：临时表空为空

问题原因

select * from dba_tablespaces where contents='TEMPORARY';
TEMP
BPX_TMP

select tablespace_name, file_name from dba_temp_files;
no rows selected.

解决方案

show parameter db_create
alter tablespace TEMP add tempfile size 30G autoextend off;
alter tablespace BPX_TMP add tempfile  size 30G autoextend off;

select tablespace_name, file_name from dba_temp_files;

cd 数据目录
ls *.tmp