Skip to Main Content
  • Questions
  • How to activate the auto-index feature in Oracle 19c Enterprise Edition?

Breadcrumb

Question and Answer

Chris Saxon

Thanks for the question, Eduardo.

Asked: January 08, 2026 - 4:11 pm UTC

Last updated: January 12, 2026 - 6:15 pm UTC

Version: 19.29.0.0.0

Viewed 100+ times

You Asked

How to activate the auto-index feature in Oracle 19c Enterprise Edition?

To activate on PDB send me the error:

BEGIN dbms_auto_index.configure('AUTO_INDEX_MODE','IMPLEMENT'); END;
Informe de error -
ORA-40216: función no soportada
ORA-06512: en "SYS.DBMS_SYS_ERROR", línea 79
ORA-06512: en "SYS.DBMS_AUTO_INDEX_INTERNAL", línea 10967
ORA-06512: en "SYS.DBMS_AUTO_INDEX", línea 301
ORA-06512: en línea 1
40216. 00000 -  "feature not supported"
*Cause:    The feature was not supported in the API.
*Action:   Modify the code to avoid usage of the feature.

and Chris said...

Automatic indexing is only supported on:

Autonomous Database
Oracle Database Enterprise Edition on Engineered Systems
Oracle Exadata Database Service on Dedicated Infrastructure
Oracle Exadata Database Service on Cloud@Customer

https://docs.oracle.com/en/database/oracle/oracle-database/19/dblic/Licensing-Information.html#GUID-0F9EB85D-4610-4EDF-89C2-4916A0E7AC87__GUID-0DA9277F-CD0F-4DE9-A904-62E382BD41D5

So if you're not on one of these platforms, it's unavailable.

More to Explore

Multitenant

Need more information on Multitenant? Check out the Multitenant docs for the Oracle Database