同步WF时总提示APPLSYSD表空间不足.docVIP

[求助] 同步WF时总提示APPLSYSD表空间不足 我执行一个请求,同步 WF 局部表,结果报错ORA-1653: unable to extend table APPLSYS.WF_LOCAL_ROLES_STAGE by 138255 in tablespace APPLSYSD而该表空间空闲剩余3.7GB啊!!!出现好几次了,每次要增加1GB的数据文件才行。而且该表空间有时候一下增加1GB左右空间,有时候又自己变少了。有人能帮助、解释一下吗? 解决过程： 1 try to resize the tbss datafile,but no use 2 这是他的数据文件分布情况document.body.clientWidth-230) this.width=document.body.clientWidth-230 border=0 / 3 有人建议扩大这个table的maxextents，我们不妨看看具体报错 ORA-1653: unable to extend table APPLSYS.WF_LOCAL_ROLES_STAGE by 138255 in tablespace APPLSYSD题是很明显，使这个table要申请那么多空间，可是tbs不能满足，而非tbs由空间，可是table的maxextents到了，所以这种说法否掉 4 后来我建议对方察看这个tbs的连续的free_space,因为oracle存取数据的时候要找的是连续的space,但是对方察看后发现freespace也足够 5最后在metalink发现如下bug2812945 Cause The table storage parameters are fixed in 11i.OWF.H - Bug 3258819This problem was detected on Bug 2812945When a next extent is required for any of the following tables is requested, as the PCTINCREASE is set to 50, it asks each time for a bigger space. WF_LOCAL_ROLESWF_LOCAL_USER_ROLESWF_LOCAL_USER_ROLES_STAGEWF_LOCAL_ROLES_STAGEWF_LOCAL_ROLES_TL_STAGE Feedback from development. 解决方案： To implement the solution, please execute the following steps: 1. List storage parameters for wfds tables. select table_name, partition_name, initial_extent, next_extent, pct_increasefrom dba_tab_partitionswhere table_name in (WF_LOCAL_USER_ROLES_STAGE,WF_LOCAL_USER_ROLES,WF_LOCAL_ROLES_STAGE,WF_LOCAL_ROLES,WF_LOCAL_ROLES_TL,WF_LOCAL_ROLES_TL_STAGE)Unionselect table_name, No partition, initial_extent, next_extent, pct_increasefrom sys.dba_tables twhere table_name in (WF_LOCAL_USER_ROLES_STAGE,WF_LOCAL_ROLES_STAGE,WF_LOCAL_ROLES_TL_STAGE)order by 1, 2; 2. All partitions that have next extent over 16M or pctincrease different to 0 need to be modified.Generate the statements to correct these storage parameters using this SQL statement: Select Alter table APPLSYS. || table_name || modify partition || partition_name || storage ( next 16M pctincrease 0); statementfrom