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
还没有评论,来说两句吧...