Oracle执行脚本时遇到ORA-01653: unable to extend table X by Y in tablespace错误
来源:互联网 发布:aoi编程手册 编辑:程序博客网 时间:2024/05/16 09:34
问题描述:insert操作数据量为1000000,delete数据量亦为1000000,同时执行,一段时间后,delete完成后,insert操作后面报错,ORA-01653: unable to extend table X by Y in tablespace,看提示信息是表空间不足,现提供几个sql来查看相关信息,便于定位问题。
一、查询表空间相关信息
SELECT a.tablespace_name ,
a.bytes / 1024 / 1024 Total_tablespace,--表空间大小(M)
( a.bytes - b.bytes ) / 1024 / 1024 Used_tablespace,--已使用空间(M)
b.bytes / 1024 / 1024 Idel_tablespace,--空闲空间(M)
Round(( ( a.bytes - b.bytes ) / a.bytes ) * 100, 2) UseRate_tablespace--使用比率
FROM (SELECT tablespace_name,
SUM(bytes) bytes
FROM dba_data_files
GROUP BY tablespace_name) a,
(SELECT tablespace_name,
SUM(bytes) bytes,
Max(bytes) largest
FROM dba_free_space
GROUP BY tablespace_name) b
WHERE a.tablespace_name = b.tablespace_name
ORDER BY ( ( a.bytes - b.bytes ) / a.bytes ) DESC;
二、查看表空间对应的datafile的信息
select file_name,tablespace_name,bytes/1024/1024,maxbytes/1024/1024 from dba_data_files where tablespace_name='USERS';
三、查看表空间对应的datafile是否可以自动扩展(当然有些场景开启自动扩展功能可能会带来一些潜在的问题,所以不是所有公司都开启这个)
select file_id,file_name,tablespace_name,autoextensible,increment_by from dba_data_files where tablespace_name ='USERS' order by file_id desc;
- Oracle执行脚本时遇到ORA-01653: unable to extend table X by Y in tablespace错误
- 关于“ORA-01653: unable to extend table SYS.AUD$ by 128 in tablespace SYSTEM”的错误
- ORA-01653: unable to extend table string.string by string in tablespace string
- ORA-01653: unable to extend table XXXX by 8497 in tablespace DAT
- ORA-01653 unable to extend table TSSA.PROFESSOR_TABLE by 8192 in tablespace TSSAPUB
- ORA-01653: unable to extend table FND_CONCURRENT_REQUESTS by 16 in tablespace APPS_TS_TX_DATA
- ORA-01653: unable to extend table SYS.AUD$ by 128 in tablespace SYSTEM
- ORA-01653:unable to extend table SYS.AUD$ by 128 in tablespace SYSTEM
- ORA-01653: unable to extend table STEVEN3.FOXT_RESULT by 8192 in tablespace USERS
- ORA-01653: unable to extend table FD by 128 in tablespace
- Oracle unable to extend table in tablespace
- ORA-01688:unable to extend table name。name partition NAME by NUM in tablespace NAME
- ORA-01653: unable to extend table SYS.AUD$ by 8192 in tablespace SYSTEM系统表空间满
- ORA-1652错误 unable to extend temp segment by 128 in tablespace
- ORACLE ORA-01653: unable to extend table 的错误
- ORACLE ORA-01653: unable to extend table 的错误
- ORACLE ORA-01653: unable to extend table 的错误
- ORACLE ORA-01653: unable to extend table 的错误(转)
- 现在的项目中一段js翻页的实现 可能有bug
- 修改默认输入法
- Hibernate+Spring中取得当前Session的方法
- 柯达首款手机亮相:中国设计 定位小众
- MyEclipse6.5的反编译插件的安装
- Oracle执行脚本时遇到ORA-01653: unable to extend table X by Y in tablespace错误
- SaaS系统中的数据模型设计思路
- 预计无人机市场规模2018年将增至10亿美元
- sharesdk,微信不能分享
- Git中git commit -m ""与git commit -a -m "" 的区别
- iOS代码修改音量
- mysql简单教程
- unity3d--高级查询
- cxf 3.0.3 与spring 3结合初探