ORA-01502:Index 'SIEBEL.S_NOTE_BUS_PLAN_P1' Or Partition Of Such Index Is In Unusable State
Last updated on JULY 12, 2017
Applies to:Siebel Tools - Version 188.8.131.52 [IP2013] and later
Information in this document applies to any platform.
A custom CLOB extension column was added to the S_NOTE_BUS_PLAN table.
Then the Apply schema changes were done for this table in Siebel Tools with the Apply button.
At that time, Siebel Tools converted the existing "out of the box" vanilla Long column to a CLOB data type.
This is the expected behavior when adding a custom CLOB column to a table with an existing Long column.
Then when testing creating new records in this business component, Users receive an error message.
An error has occurred writing to a record.
Please continue or ask your systems administrator to check your application configuration if the problem persists.
ORA-01502: index 'SIEBEL.S_NOTE_BUS_PLAN_P1' or partition of such index is in unusable state
Error mentioned above is similar to doc 1447276.1
A custom column extension with data type CLOB was added and applied to a table that already had an "out of the box" or "vanilla" Long column.
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