ORA-40216: feature not supported

Is auto index supported in non-exadata ?

No, it is not supported

SQL> begin
   dbms_auto_index.configure ('AUTO_INDEX_MODE','REPORT ONLY');
/  2    3    4
ERROR at line 1:
ORA-40216: feature not supported
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79
ORA-06512: at "SYS.DBMS_AUTO_INDEX_INTERNAL", line 10364
ORA-06512: at "SYS.DBMS_AUTO_INDEX", line 301
ORA-06512: at line 2
oerr ora 40216
40216, 00000, "feature not supported"
// *Cause:  The feature was not supported in the API.
// *Action: Modify the code to avoid usage of the feature.

Leave a Reply