oracle 01652,案例:Oracle报错ORA-01652 分析永久表空间出现临时段不能扩展原因

天萃荷净

开发DBA反映，数据库alert日志报错ORA-01652，分析数据库的表空间为永久表空间，出现临时段不能自动扩展

1.查询Oracle数据库版本

SQL> select * from v$version;

BANNER

-----------------------------------------------------------------------

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production

PL/SQL Release 11.2.0.3.0 - Production

CORE 11.2.0.3.0 Production

TNS for Linux: Version 11.2.0.3.0 - Production

NLSRTL Version 11.2.0.3.0 - Production

创建5M测试表空间

SQL> CREATE TABLESPACE T_1652 DATAFILE '/tmp/t_1652_01.dbf' size 5M

2 AUTOEXTEND OFF LOGGING PERMANENT EXTENT MANAGEMENT LOCAL AUTOALLOCATE

3 SEGMENT SPACE MANAGEMENT AUTO blocksize 8192;

Tablespace created.

测试CTAS

SQL> create table CHF.T_oracleplus TABLESPACE T_1652 as

2 select LPAD('oracleplus',1024,'F') "C_XFF" from