表空间问题,ORA-1654:unabletoextendindexAPPLSYS.SYS_IOT_TOP_245575

标签:
erp中科院itoracle |
分类: DB |
空间扩展的问题大部分的问题都在这里,请对号入座吧!
update 2019.01.17
----------------------------------------------
在实际环境中,有时发现数据库表空间明显还有数G的空闲,日志却报空间不足的错误,多是由于数据库自动扩展时,next extent的值比较大,超出了整个tablespace的最大值。
以下举例即是,缩小next extet值即可。
问题一:
ORA-1654:
unable to extend index APPLSYS.SYS_IOT_TOP_245575 by 311075
in tablespace
[oraprod@arpinfo ~]$ sqlplus /nolog
SQL*Plus: Release 9.2.0.3.0 -
Production on Thu Oct 17 10:46:47 2013
Copyright (c) 1982, 2002, Oracle Corporation.
SQL> conn
apps/xxxxxxx;
Connected.
SQL> select table_name from
dba_indexes where index_name =
'SYS_IOT_TOP_245575';
TABLE_NAME
------------------------------
AQ$_WF_CONTROL_H
SQL>alter table applsys.AQ$_WF_CONTROL_H
SQL>ALTER TABLE
"APPLSYS"."AQ$_WF_CONTROL_H"
Table altered.
--------看图说话,用oracle client处理上面的问题-----------------
http://s10/mw690/002aGv9xzy6YS8pzySBb9&690
------------------------------------------------
问题二:
http://s10/mw690/002aGv9xzy7eAqeHBFLf9&690
ORA-1653: unable to extend table
APPLSYS.WF_LOCAL_ROLES_STAGE by 138255 in
http://s1/mw690/002aGv9xzy7eAqkDTFub0&690
或执行sql语句:
ALTER TABLE "APPLSYS"."WF_LOCAL_ROLES_STAGE"
问题三:
-------------------我是分隔线-----------------------------
ORA-1653: unable to extend table
APPS.CAS_COMN_FIN_LATEST3 by 311075
in
ALTER TABLE
"APPS"."CAS_COMN_FIN_LATEST3"
ALTER TABLE "APPS"."CAS_COMN_FIN"
------------------我是分隔线---------------------------
select
from
where
order
alter
------------------------------------------------------------------------------------
对next_extent排序
select segment_name,next_extent,tablespace_name from
dba_segments order by
--------------------我是分隔线-----------------------------------
问题四:
su - oraprod
sqlplus /nolog
conn / as sysdba
ALTER TABLE "PA"."CFA_ALERT_INSERT_F"
--------------------------------------------------
ORA-1631: max # extents 505 reached in table APPLSYS.WF_ERROR
select owner,segment_name,segment_type,tablespace_name,extents,max_extents from dba_segments where segment_name='WF_ERROR';
ALTER TABLE
"APPLSYS"."WF_ERROR"
-----------------------------------------------------
问题五:
http://s16/bmiddle/002aGv9xzy7qQkDffbh6f&690
alter index
------------------------------------------
其它相关:
数据库扩展表空间:http://blog.sina.com.cn/s/blog_769f68db01015oq7.html
erp 过帐报错: http://blog.sina.com.cn/s/blog_769f68db0101esbs.html
会计期间无法打开 http://blog.sina.com.cn/s/blog_769f68db0100y7yh.html