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 queryingDBA_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 queryingUSER_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
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
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
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
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