My Oracle Support Banner

Can Unusable SO% indexes be dropped ? (Doc ID 2757177.1)

Last updated on MARCH 08, 2021

Applies to:

Oracle Order Management - Version 12.2.6 and later
Information in this document applies to any platform.

Goal

On : 12.2.6 version, AD UTILITIES

We have UNUSABLE indexes on SO% tables.
Can we drop these UNUSABLE indexes ?

OWNER   INDEX_NAME                      TABLE_OWNER TABLE_NAME                  STATUS
------- ------------------------------- ----------- --------------------------- --------
OE      SO_ACTION_CLAUSES_U1            OE          SO_ACTION_CLAUSES           UNUSABLE
OE      SO_EXCEPTIONS_N1                OE          SO_EXCEPTIONS               UNUSABLE
OE      SO_EXCEPTIONS_U1                OE          SO_EXCEPTIONS               UNUSABLE
OE      SO_HEADERS_INTERFACE_N1         OE          SO_HEADERS_INTERFACE_ALL    UNUSABLE
OE      SO_HEADERS_INTERFACE_U1         OE          SO_HEADERS_INTERFACE_ALL    UNUSABLE
OE      SO_HOLD_RELEASES_N1             OE          SO_HOLD_RELEASES            UNUSABLE
OE      SO_HOLD_RELEASES_N2             OE          SO_HOLD_RELEASES            UNUSABLE
OE      SO_HOLD_RELEASES_U1             OE          SO_HOLD_RELEASES            UNUSABLE
OE      SO_HOLD_SOURCES_N1              OE          SO_HOLD_SOURCES_ALL         UNUSABLE
OE      SO_HOLD_SOURCES_N2              OE          SO_HOLD_SOURCES_ALL         UNUSABLE
OE      SO_HOLD_SOURCES_U1              OE          SO_HOLD_SOURCES_ALL         UNUSABLE
OE      SO_LINE_APPROVALS_N1            OE          SO_LINE_APPROVALS           UNUSABLE
OE      SO_LINE_APPROVALS_N2            OE          SO_LINE_APPROVALS           UNUSABLE
OE      SO_LINE_APPROVALS_N3            OE          SO_LINE_APPROVALS           UNUSABLE
OE      SO_LINE_APPROVALS_U1            OE          SO_LINE_APPROVALS           UNUSABLE
OE      SO_NOTES_N1                     OE          SO_NOTES                    UNUSABLE
OE      SO_NOTES_N2                     OE          SO_NOTES                    UNUSABLE
OE      SO_NOTES_U1                     OE          SO_NOTES                    UNUSABLE
OE      SO_OBJECTS_U1                   OE          SO_OBJECTS                  UNUSABLE
OE      SO_OBJECTS_U2                   OE          SO_OBJECTS                  UNUSABLE
OE      SO_OBJECTS_U3                   OE          SO_OBJECTS                  UNUSABLE
OE      SO_ORDER_CANCELLATIONS_N1       OE          SO_ORDER_CANCELLATIONS      UNUSABLE
OE      SO_ORDER_CANCELLATIONS_N2       OE          SO_ORDER_CANCELLATIONS      UNUSABLE
OE      SO_ORDER_CANCELLATIONS_N3       OE          SO_ORDER_CANCELLATIONS      UNUSABLE
OE      SO_ORDER_CANCELLATIONS_N4       OE          SO_ORDER_CANCELLATIONS      UNUSABLE
OE      SO_ORDER_CANCELLATIONS_N5       OE          SO_ORDER_CANCELLATIONS      UNUSABLE
OE      SO_ORDER_CANCELLATIONS_N6       OE          SO_ORDER_CANCELLATIONS      UNUSABLE
OE      SO_PICKING_CANCELLATIONS_N1     OE          SO_PICKING_CANCELLATIONS    UNUSABLE
OE      SO_STANDARD_VALUE_RULE_SETS_U1  OE          SO_STANDARD_VALUE_RULE_SETS UNUSABLE
OE      SO_STANDARD_VALUE_RULE_SETS_U2  OE          SO_STANDARD_VALUE_RULE_SETS UNUSABLE
SYSTEM  SO_EXCEPTIONS1907136882         OE          SO_EXCEPTIONS               UNUSABLE
.

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


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