My Oracle Support Banner

Getting ORA-01654 "Unable to extend index" When Uploading Legacy OTL Data (Doc ID 1286345.1)

Last updated on MAY 12, 2021

Applies to:

Oracle Time and Labor - Version and later
Information in this document applies to any platform.


On, 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.


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.