Forum Stats

  • 3,769,020 Users
  • 2,252,898 Discussions
  • 7,874,841 Comments

Discussions

Question about environment for automatic indexing workshop

Hi Experts,

I try to go through the Database 19c - Automatic Indexing Workshop (https://apexapps.oracle.com/pls/apex/dbpm/r/livelabs/view-workshop?wid=576).

The environment prepared for this workshop is oracle 19c deployed in a compute instance. But automatic indexing feature only work on Exadata machine. So when we follow the steps to call package DBMS_AUTO_INDEX, we will hit ORA-40216.

How could we solve the problem?

Thanks.

Answers