ora-01652
来源:互联网 发布:php startup 编辑:程序博客网 时间:2024/06/06 20:49
建索引发生ora-01652无法通过128(在escalade表空间中)扩展temp段...
的错误,错误解决很简单,如下
1.查看表空间使用率(包括临时表空间)
select * from (
Select a.tablespace_name,
to_char(a.bytes/1024/1024,'99,999.999') total_bytes,
to_char(b.bytes/1024/1024,'99,999.999') free_bytes,
to_char(a.bytes/1024/1024 - b.bytes/1024/1024,'99,999.999') use_bytes,
to_char((1 - b.bytes/a.bytes)*100,'99.99') || '%' use
from (select tablespace_name,
sum(bytes) bytes
from dba_data_files
group by tablespace_name) a,
(select tablespace_name,
sum(bytes) bytes
from dba_free_space
group by tablespace_name) b
where a.tablespace_name = b.tablespace_name
union all
select c.tablespace_name,
to_char(c.bytes/1024/1024,'99,999.999') total_bytes,
to_char( (c.bytes-d.bytes_used)/1024/1024,'99,999.999') free_bytes,
to_char(d.bytes_used/1024/1024,'99,999.999') use_bytes,
to_char(d.bytes_used*100/c.bytes,'99.99') || '%' use
from
(select tablespace_name,sum(bytes) bytes
from dba_temp_files group by tablespace_name) c,
(select tablespace_name,sum(bytes_cached) bytes_used
from v$temp_extent_pool group by tablespace_name) d
where c.tablespace_name = d.tablespace_name
)
order by tablespace_name
2.查看文件是否自动扩展
select d.file_name,d.tablespace_name,d.autoextensible from dba_data_files d
如果想查看临时表空间文件是否自动扩展
select d.file_name,d.tablespace_name,d.autoextensible from dba_temp_files d;
3.在检查表文件时 发现 表空间escalade使用率接近100%,且不可扩展
修改文件自动可扩展性
alter database datafile 'E:xxxxxxESCALADE.ORA' autoextend on;
4.重建索引就可以了
- ora-01652
- ORA-01652
- ORA-01652 错误提示....
- ORA-01652的解决
- 解决ora-01652
- ORA
- ora
- ORACLE ORA-01652 错误解决
- Oracle rebuild index 报 ORA-01652 解决办法
- Oracle rebuild index 报 ORA-01652 解决办法
- ORA-20000: -1652:ORA-01652: unable to extend temp segment by 8192 in tablespace
- ORA-01034 ORA-27101
- ORA-10567,ORA-00313
- ora-01128,ora-00275
- ORA-03113,ORA-07445
- ORA-32017 ORA-16179
- ORA-12012,ORA-12005
- ora-01034 ,ora-27101
- S.E.O
- 用Qt树型控件做文件浏览器的简单实现
- 如何编写高效的Android代码
- 基于功能更丰富的基础类构建您自己的 ASP.NET 页面
- 312312
- ora-01652
- C/C++——memset,memcpy,strcpy 的区别
- ORA-00362
- C# 操作注册表全攻略
- POJO
- 2010-06-03
- 前端优化方案-CSS 优化方案
- Scrum简介
- Add a static route item in OSX