How to Avoid the Error ORA-01654: Unable To Extend Index in General Ledger
(Doc ID 743950.1)
Last updated on MAY 28, 2024
Applies to:
Oracle General Ledger - Version 11.5.10.2 and laterInformation in this document applies to any platform.
Executable:GLBOYR - Open Budget Year
Executable:GLPPOS - Posting
Goal
Occasionally General Ledger programs will error with the ORA-01654 error. This document explains how to avoid this error.
Examples of the Error
-------------------
<x glpipi() 16-OCT-2008 11:33:13
Error in ROUTINE: glpipi, status: 0
SHRD0043: ERROR:
***************************************************
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: errexit().
<x glbinp() 11-AUG-2014 08:49:05
*****************************************************
sqlcaid: sqlabc: 0 sqlcode: -1654 sqlerrml: 70
sqlerrmc:
ORA-01654: unable to extend index GL.GL_BALANCES_N2 by 8192 in tablesp
sqlerrp: sqlerrd: 0 56254 0 0 0 538976288
sqlwarn: sqltext:
*****************************************************
Solution
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Goal |
| Solution |