Creating a SEARCH INDEX for JSON Fails with ORA-29855, ORA-20000, DRG-50857, DRG-10550, ORA-01741 (Doc ID 2939302.1)

Last updated on JULY 20, 2024

Applies to:

Oracle Text - Version 19.3.0.0.0 and later
Oracle Database - Enterprise Edition - Version 19.3.0.0.0 and later
Information in this document applies to any platform.

Symptoms

Creating a LOCAL partitioned SEARCH INDEX with OPTIMIZE AUTO_DAILY parameter fails with errors:

Cause

In this Document

Sign In

To view full details, sign in with your My Oracle Support account.

Register

Don't have a My Oracle Support account? Click to get started!

Symptoms

Cause

Solution

References

---

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts. Oracle offers a comprehensive and fully integrated stack of cloud applications and platform services. For more information about Oracle (NYSE:ORCL), visit oracle.com . � Oracle | Contact and Chat | Support | Communities | Connect with us | | | | Legal Notices | Terms of Use