Oracle Cloud Infrastructure Documentation

DBMS_CLOUD_AI Views

The DBMS_CLOUD_AI package uses the following views.

  • DBA_CLOUD_AI_PROFILES View
    The list of profiles created in the current database can be obtained by querying DBA_CLOUD_AI_PROFILES. The view displays the details of AI profiles in the database.
  • USER_CLOUD_AI_PROFILES View
    The list of profiles created in the current database can be obtained by querying USER_CLOUD_AI_PROFILES. The view displays the details of AI profiles in your schema.
  • DBA_CLOUD_AI_PROFILE_ATTRIBUTES View
    Attributes of AI profile manage the configuration and behavior of the AI profile. The view displays details of all AI profiles in the database.
  • USER_CLOUD_AI_PROFILE_ATTRIBUTES View
    Attributes of AI profile manage the configuration and behavior of the AI profile. The view displays details of AI profiles in your schema.

Parent topic: Autonomous Database Views

DBA_CLOUD_AI_PROFILES View

The list of profiles created in the current database can be obtained by querying DBA_CLOUD_AI_PROFILES. The view displays the details of AI profiles in the database.

Only the ADMIN user is privileged to access DBA_CLOUD_AI_PROFILES. You cannot grant access to other users.

Column Datatype NULL Description
PROFILE_ID NUMBER NOT NULL Unique number assigned to the AI profile
PROFILE_NAME VARCHAR2(128) NOT NULL Name of the AI profile
OWNER VARCHAR2(128) NOT NULL Owner schema of the AI profile
STATUS VARCHAR2(7) NOT NULL Current status of AI profile - ENABLED or DISABLED
DESCRIPTION VARCHAR2(4000) NOT NULL User specified description for the AI profile
CREATED TIMESTAMP(6) WITH TIME ZONE NOT NULL Creation time for the AI profile.
LAST_MODIFIED TIMESTAMP(6) WITH TIME ZONE NOT NULL Last modification time for the AI profile

Parent topic: DBMS_CLOUD_AI Views

USER_CLOUD_AI_PROFILES View

The list of profiles created in the current database can be obtained by querying USER_CLOUD_AI_PROFILES. The view displays the details of AI profiles in your schema.

Only the user is privileged to access USER_CLOUD_AI_PROFILES. You cannot grant access to other users.

Column Datatype NULL Description
PROFILE_ID NUMBER NOT NULL Unique number assigned to the AI profile
PROFILE_NAME VARCHAR2(128) NOT NULL Name of the AI profile
STATUS VARCHAR2(7) NOT NULL Current status of AI profile - ENABLED or DISABLED
DESCRIPTION VARCHAR2(4000) - User specified description for the AI profile
CREATED TIMESTAMP(6) WITH TIME ZONE NOT NULL Creation time for the AI profile
LAST_MODIFIED TIMESTAMP(6) WITH TIME ZONE NOT NULL Last modification time for the AI profile

Parent topic: DBMS_CLOUD_AI Views

DBA_CLOUD_AI_PROFILE_ATTRIBUTES View

Attributes of AI profile manage the configuration and behavior of the AI profile. The view displays details of all AI profiles in the database.

Only the ADMIN user is privileged to access DBA_CLOUD_AI_PROFILE_ATTRIBUTES. You cannot grant access to other users.

Column Datatype NULL Description
PROFILE_ID NUMBER NOT NULL Unique number assigned to the AI profile
PROFILE_NAME VARCHAR2(128) NOT NULL Name of the AI profile
OWNER VARCHAR2(128) NOT NULL Owner schema of the AI profile
ATTRIBUTE_NAME VARCHAR2(128) NOT NULL Name of the AI profile attribute
ATTRIBUTE_VALUE CLOB - Value of the AI profile attribute
LAST_MODIFIED TIMESTAMP(6) WITH TIME ZONE NOT NULL Last modification time of the AI profile attribute

Parent topic: DBMS_CLOUD_AI Views

USER_CLOUD_AI_PROFILE_ATTRIBUTES View

Attributes of AI profile manage the configuration and behavior of the AI profile. The view displays details of AI profiles in your schema.

Only the user is privileged to access USER_CLOUD_AI_PROFILE_ATTRIBUTES. You cannot grant access to other users.

Column Datatype NULL Description
PROFILE_ID NUMBER NOT NULL Unique number assigned to the AI profile
PROFILE_NAME VARCHAR2(128) NOT NULL Name of the AI profile
ATTRIBUTE_NAME VARCHAR2(128) NOT NULL Name of the AI profile attribute
ATTRIBUTE_VALUE CLOB - Value of the AI profile attribute
LAST_MODIFIED TIMESTAMP(6) WITH TIME ZONE NOT NULL Last modification time of the AI profile attribute

Parent topic: DBMS_CLOUD_AI Views