ORA-1654: unable to extend index %s.%s by %s in tablespace %s Cause: Failed to allocate an extent of the required number of blocks for an index segment in the tablespace indicated. Action: Use ALTER TABLESPACE ADD DATAFILE statement to add one or more files to the tablespace indicated. ORA...
各种情况对应解决方法参考: Troubleshooting Guide - 'Unable to Extend / Create' Errors (文档 ID 1025288.6) Overview Of ORA-01654: Unable To Extend Index %s.%s By %s In Tablespace %s (文档 ID 146595.1)
create index IDX_ANA_PNR_OFFICE on ANA (OFFICE_CITY, OFFICE_NO) tablespace IDX; 查看SQL是: storage ( initial 64K next 1M minextents 1 maxextents unlimited ); 问题追查: 1、首先针对1654这个报错,MOS是这样介绍的: Error: ORA-01654 Text: unable to extend index %s.%s by %s in tablespace %s...
Oracle Database - Enterprise Edition - Version 7.0.16.0 and later: Overview Of ORA-01654: Unable To Extend Index %s.%s By %s In Tablespace %s
create index IDX_ANA_PNR_OFFICE on ANA (OFFICE_CITY, OFFICE_NO) tablespace IDX; 查看SQL是: storage ( initial 64K next 1M minextents 1 maxextents unlimited ); 问题追查: 1、首先针对1654这个报错,MOS是这样介绍的: Error: ORA-01654 Text: unable to extend index %s.%s by %s in tablespace %s...
sqlcaid: sqlabc: 0 sqlcode: -1654 sqlerrml: 70 sqlerrmc: ORA-01654: unable to extend index GL.GL_POSTING_INTERIM_32239_N1 by 26 sqlerrp: sqlerrd: 0 0 0 0 19 0 sqlwarn: W W sqltext: *** SHRD0044: Process logging off database and exiting ...SHRD0075: Error in glbinp...
SQLError: (1654, 'ORA-01654: unable to extend index RHNSAT.RHN_SNAPSHOTPKG_SID_NID_UQ by 128 in tablespace DATA_TBS\nORA-06512: at "RHNSAT.RHN_SERVER", line 231\nORA-06512: at line 1\n') Satellite-sync fails with following error: ...
如果导致表空间满了,在alert日志中将会报ORA-1654: unable to extend index SYS...错误。 如果不用到审计功能,建议关闭审计。 处理过程: 1、用oracle用户登录到数据库服务器,执行: sqlplus / as sysdba 2、取消audit,将初始化参数audit_trail设置为NONE alter...
ORA-1654: unable to extend index SID.INDEX by 128 in tablespace TABLESPACE ORA-1653: unable to extend table SID.TABLE by 1024 in tablespace TABLESPACE 看来表空间已经满了并且无法扩展导致oracle出现core的。 $cd $ORACLE_BASE/oradada/SID
If the tablespace is full, the ORA-1654: unable to extend index sys... error is reported in the Alert Log. If you do not need the audit function, we recommend that you disable audit. Processing Process: 1. log on to the database server as an oracle user and ...