Enabling AI Enrichment for a Schema

To view enrichment opportunities for your schema and take action, you must first enable the AI enrichment feature in Oracle SQL Developer for VS Code.

This is a one-time process that sets up your schema by creating the necessary objects to store the enrichment metadata.

Note: Do not use the AI enrichment feature on SYS or SYSTEM schemas as the creation of AI enrichment objects in a SYS-level schema may fail due to potential conflicts during installation.

To enable the feature:

  1. In Oracle SQL Developer for VS Code, expand the Connections panel.

  2. Expand your database connection tree, and click the AI Enrichment folder.

    The image shows the AI Enrichment folder under your database connection.

  3. In the dialog box that appears, click Yes to confirm the creation of AI enrichment objects.

    Dialog box to confirm the creation of AI enrichment objects.

    The AI enrichment feature is now available for your schema.