My Oracle Support Banner

OCI DBCS : Datapatch Fails With "ORA-29868: cannot issue DDL on a domain index marked as LOADING" Error (Doc ID 2483222.1)

Last updated on FEBRUARY 10, 2020

Applies to:

Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.


When attempting to complete the patch post-install steps by running "datapatch -verbose", the following error is reported

Patch 27270399 rollback (pdb CDB$ROOT): WITH ERRORS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/27270399/21800936/27270399_rollback_ORCL_CDBROOT_2018Dec07_07_25_35.log (errors)
Error at line 22747: ORA-29868: cannot issue DDL on a domain index marked as LOADING
Patch 28239892 apply (pdb CDB$ROOT): WITH ERRORS





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.