Getting ORA-01654 "Unable to extend index" When Uploading Legacy OTL Data
Last updated on MAY 10, 2018
Applies to:Oracle Time and Labor - Version 18.104.22.168 and later
Information in this document applies to any platform.
On 22.214.171.124, When loading the legacy data to OTL tables through OTL APIs getting the following error:
"ORA-01654: unable to extend index HXC.HXC_TIME_ATTRIBUTE_USAGES_FK2 by 16 in tablespace APPS_TS_TX_IDX"
"ORA-01654: unable to extend index APPLSYS.WF_ITEM_ACTIVITY_STATUSES_N4 by 16 in table space APPS_TS_TX_IDX"
Also we have extended the table-space many times before and concerned about keep extending the table-space!
Is there any other solution for this?
Note: Purgable workflow count and it is 0, means that all those records are active workflows.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms