java.sql.SQLException: ORA-01652: unable to extend temp segment by 128 in tablespace TEMP

最新推荐文章于 2022-05-16 20:36:55 发布

zoe_邹

最新推荐文章于 2022-05-16 20:36:55 发布

阅读量3.7k

点赞数

分类专栏：数据库学习文章标签： oracle 表空间不足

本文链接：https://blog.youkuaiyun.com/sdizoea/article/details/65446664

版权

数据库学习专栏收录该内容

3 篇文章

订阅专栏

数据库更新操作报错：

Error updating database. Cause: java.sql.SQLException: ORA-01652: unable to extend temp segment by 128 in tablespace TEMP

; uncategorized SQLException for SQL []; SQL state [72000]; error code [1652]; ORA-01652: unable to extend temp segment by 128 in tablespace TEMP
; nested exception is java.sql.SQLException: ORA-01652: unable to extend temp segment by 128 in tablespace TEMP

原因：表空间太小

1.删除掉原表空间，新建一个表空间temp02

查找表空间：

select file_name,bytes/1024/1024 "MB",autoextensible,tablespace_name from dba_temp_files

新建temp02;

create temporary tablespace TEMP02 TEMPFILE '/u01/app/oracle/product/10.2.0/db_1/dbs/temp02.dbf' SIZE 512M REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED;

Tablespace created.

更改数据库的默认临时表空间为temp02

alter database default temporary tablespace temp02;

删除原来的默认临时表空间TEMP01

drop tablespace temp01 including contents and datafiles;

2.更改临时表空间大小

alter database tempfile '/u01/app/oracle/product/10.2.0/db_1/dbs/temp01.dbf' RESIZE 1000m;