During Install Domain Indexes (Text and Spatial) on HR Tables Do Not Compile (Doc ID 2569680.1)

Last updated on SEPTEMBER 01, 2022

Applies to:

Goal

While applying a patch we are receiving this set of errors:
DOC> **********************************************************************
DOC> SECTION-34 [minimal]
DOC> **********************************************************************
DOC> "Index Must be usable."
DOC>
DOC> - P1: Unusable indexes block DML access to the table
DOC> - Fix: Rebuild the index.
DOC> SQL> alter index owner.index_name rebuild;
DOC> - Indexes on unused tables can be ignored
DOC> - Note: Unusable indexes where ITYP_OWNER='CTXSYS' will not block
DOC> DML and are not P1 issues.
DOC>#

OWNER INDEX_NAME TABLE_NAME
---------------- -------------------------------------------------------------------------------------------------------------------------------- ------------------------------
ITYP_OWNER
--------------------------------------------------------------------------------------------------------------------------------
HR PER_ADDRESSES_N4 PER_ADDRESSES
CTXSYS

HR PER_ADDRESSES_SPT PER_ADDRESSES
MDSYS


2 rows selected.

Please advise on how to correct the issue on these tables ( if needed)

We have tried the following:
SQL> alter index HR.PER_ADDRESSES_N4 rebuild;
alter index HR.PER_ADDRESSES_N4 rebuild
*
ERROR at line 1:
ORA-28337: the specified index may not be defined on an encrypted column


SQL> alter index HR.PER_ADDRESSES_SPT rebuild;
alter index HR.PER_ADDRESSES_SPT rebuild
*
ERROR at line 1:
ORA-28337: the specified index may not be defined on an encrypted column

Please provide help on how to resolve this issue with these Indexes.

Solution

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