My Oracle Support Banner

Transformation Install Fails With ORA-01502: Index Or Partition Of Such Index Is In Unusable State (Doc ID 2466927.1)

Last updated on DECEMBER 03, 2019

Applies to:

Oracle Health Sciences Data Management Workbench - Version 2.4.7 and later
Information in this document applies to any platform.


The user was able to load the metadata and data for a study however, it is failing in the transformations which involve Inform Metadata and Inform operational data. Also user is having issue while promoting the data model. Its not promoted yet.


The tablespace for the Work Area objects was restored. The new one was created as 16 KB (the old one was 8 KB)


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.