DBMS_CLOUD_AI_AGENT Views

The DBMS_CLOUD_AI_AGENT package uses the following views.

See Also:

Select AI Agent

DBA_AI_AGENTS View

The view display agents created by all users inside their database.

Only the Database Administrator is privileged to access this view. They can grant access to other users. The DBA* views show objects of all Database users.

Column Datatype NULL Description
AGENT_ID NUMBER NOT NULL Stores the unique number assigned to an agent.
AGENT_NAME VARCHAR2(128) NOT NULL Specifies the agent name.
OWNER VARCHAR2(128) NOT NULL

Specifies the owner of the agent.

DESCRIPTION CLOB - Provides a description summarizing the purpose or context of the agent.
CREATED TIMESTAMP(6) WITH TIME ZONE -

The timestamp the agent was created.

LAST_MODIFIED TIMESTAMP(6) WITH TIME ZONE -

Indicates the timestamp of the most recent modification to the agent.

STATUS VARCHAR2(8) -

Specifies the status of the agent.

ORACLE_MAINTAINED CHAR(1) -

Indicates that the object is maintained by Oracle.

DBA_AI_AGENTS_ATTRIBUTES View

The view displays attributes of the agents created by all users inside their database.

Only the Database Administrator is privileged to access this view. They can grant access to other users. The DBA* views show objects of all Database users.

Column Datatype NULL Description
AGENT ID NUMBER NOT NULL Stores the unique number assigned to an agent.
AGENT_NAME VARCHAR2(128) NOT NULL Specifies the name of the agent.
OWNER VARCHAR2(128) NOT NULL Specifies the owner of the agent attributes.
ATTRIBUTE_NAME VARCHAR2(128) - Specifies the name of the attributes.
ATTRIBUTE_VALUE CLOB NOT NULL

Specifies the attribute value.

LAST_MODIFIED TIMESTAMP(6) WITH TIME ZONE NOT NULL

Indicates the timestamp of the most recent modification to the agent attribute.

USER_AI_AGENTS View

The view displays details on conversations in your schema.

The current user can see the agents they own. You cannot grant access to other users. The Database Administrator can access these views but sees only the objects they own.

Column Datatype NULL Description
AGENT_ID NUMBER NOT NULL Stores the unique number assigned to an agent.
AGENT_NAME VARCHAR2(128) NOT NULL Specifies the name of the agent.
DESCRIPTION CLOB - Provides a description summarizing the purpose or context of the agent.
CREATED TIMESTAMP(6) WITH TIME ZONE NOT NULL

The timestamp the agent was created.

LAST_MODIFIED TIMESTAMP(6) WITH TIME ZONE NOT NULL

Indicates the timestamp of the most recent modification to the agent.

STATUS VARCHAR2(8) -

Specifies the status of the agent.

ORACLE_MAINTAINED NUMBER -

Indicates if it is maintained by Oracle.

USER_AI_AGENTS_ATTRIBUTES View

The view displays attributes of agents created by the current user inside their schema.

The current user can see the agent attributes they own. You cannot grant access to other users. The Database Administrator can access these views but sees only the objects they own.

Column Datatype NULL Description
AGENT ID NUMBER NOT NULL Stores the unique number assigned to an agent.
AGENT_NAME VARCHAR2(128) NOT NULL Specifies the name of the agent.
ATTRIBUTE_NAME VARCHAR2(128) - Specifies the name of the attributes.
ATTRIBUTE_VALUE CLOB NOT NULL

Specifies the attribute value.

LAST_MODIFIED TIMESTAMP(6) WITH TIME ZONE NOT NULL

Indicates the timestamp of the most recent modification to the agent attribute.

DBA_AI_AGENT_TOOL View

The view displays details of the tools created by all users inside their database.

Only the Database Administrator is privileged to access this view. They can grant access to other users. The DBA* views show objects of all Database users.

Column Datatype NULL Description
TOOL ID NUMBER NOT NULL

Stores the unique number assigned to a tool.

TOOL_NAME VARCHAR2(128) NOT NULL

Specifies the name of the tool.

OWNER VARCHAR2(128) NOT NULL

Specifies the owner of the tool.

DESCRIPTION CLOB -

Provides a description summarizing the purpose or context of the tool.

CREATED TIMESTAMP(6) WITH TIME ZONE NOT NULL

The timestamp the tool was created.

LAST_MODIFIED TIMESTAMP(6) WITH TIME ZONE NOT NULL

Indicates the timestamp of the most recent modification to the tool.

STATUS VARCHAR2(8) -

Specifies the status of the tool.

ORACLE_MAINTAINED CHAR(1) -

Indicates if the object is maintained by Oracle.

DBA_AI_AGENT_TOOL_ATTRIBUTES View

The view displays attributes of tools created by all users inside their database.

Only the Database Administrator is privileged to access this view. They can grant access to other users. The DBA* views show objects of all Database users.

Column Datatype NULL Description
TOOL ID NUMBER NOT NULL

Stores the unique number assigned to a tool attribute.

AGENT_NAME VARCHAR2(128) NOT NULL

Specifies the name of the tool.

OWNER VARCHAR2(128) NOT NULL

Specifies the owner of the tool attribute.

ATTRIBUTE_NAME VARCHAR2(128) -

Specifies the name of the attribute.

ATTRIBUTE_VALUE CLOB NOT NULL

Specifies the attribute value.

LAST_MODIFIED TIMESTAMP(6) WITH TIME ZONE NOT NULL

Indicates the timestamp of the most recent modification to the tool attributes.

USER_AI_AGENT_TOOL View

The view displays details tools created by the current user inside their schema.

The current user can see the tools they own. You cannot grant access to other users. The Database Administrator can access these views but sees only the objects they own.

Column Datatype NULL Description
TOOL ID NUMBER NOT NULL Stores the unique number assigned to a tool.
TOOL_NAME VARCHAR2(128) NOT NULL Specifies the name of the tool.
DESCRIPTION CLOB - Provides a description summarizing the purpose or context of the tool.
CREATED TIMESTAMP(6) WITH TIME ZONE NOT NULL

The timestamp the tool was created.

LAST_MODIFIED TIMESTAMP(6) WITH TIME ZONE NOT NULL

Indicates the timestamp of the most recent modification to the tool.

STATUS VARCHAR2(8) -

Specifies the status of the tool.

ORACLE_MAINTAINED CHAR(1) -

Indicates if the object is maintained by Oracle.

USER_AI_AGENT_TOOL_ATTRIBUTES View

The view displays attributes of tools created by the current user inside their schema.

The current user can see the tool attributes they own. You cannot grant access to other users. The Database Administrator can access these views but sees only the objects they own.

Column Datatype NULL Description
TOOL ID NUMBER NOT NULL Stores the unique number assigned to a tool.
AGENT_NAME VARCHAR2(128) NOT NULL Specifies the name of the tool.
ATTRIBUTE_NAME VARCHAR2(128) - Specifies the name of the attribute.
ATTRIBUTE_VALUE CLOB NOT NULL

Specifies the attribute value.

LAST_MODIFIED TIMESTAMP(6) WITH TIME ZONE NOT NULL

Indicates the timestamp of the most recent modification to the tool attributes.

DBA_AI_AGENT_TASK View

The view display tasks created by all users inside their database.

Only the Database Administrator is privileged to access this view. They can grant access to other users. The DBA* views show objects of all Database users.

Column Datatype NULL Description
TASK ID NUMBER NOT NULL

Stores the unique number assigned to a task.

TASK_NAME VARCHAR2(128) NOT NULL

Specifies the task name.

OWNER VARCHAR2(128) NOT NULL

Specifies the owner of the task.

DESCRIPTION CLOB -

Provides a description summarizing the purpose or context of the task.

CREATED TIMESTAMP(6) WITH TIME ZONE -

The timestamp the task was created.

LAST_MODIFIED TIMESTAMP(6) WITH TIME ZONE -

Indicates the timestamp of the most recent modification to the task.

STATUS VARCHAR2(8) -

Specifies the status of the task.

ORACLE_MAINTAINED CHAR(1) -

Indicates that the object is maintained by Oracle.

DBA_AI_AGENT_TASK_ATTRIBUTES View

The view displays attributes of tasks created by all users inside their database.

Only the Database Administrator is privileged to access this view. They can grant access to other users. The DBA* views show objects of all Database users.

Column Datatype NULL Description
TASK ID NUMBER NOT NULL Stores the unique number assigned to a task.
TASK_NAME VARCHAR2(128) NOT NULL Specifies the name of the task.
OWNER VARCHAR2(128) NOT NULL Specifies the owner of the task attributes.
ATTRIBUTE_NAME VARCHAR2(128) - Specifies the name of the attributes.
ATTRIBUTE_VALUE CLOB NOT NULL

Specifies the attribute value.

LAST_MODIFIED TIMESTAMP(6) WITH TIME ZONE NOT NULL

Indicates the timestamp of the most recent modification to the task attribute.

USER_AI_AGENTS View

The view displays details on tasks created by the current user inside their schema.

The current user can see the tasks they own. You cannot grant access to other users. The Database Administrator can access these views but sees only the objects they own.

Column Datatype NULL Description
TASK ID NUMBER NOT NULL Stores the unique number assigned to a task.
TASK_NAME VARCHAR2(128) NOT NULL Specifies the name of the task.
DESCRIPTION CLOB - Provides a description summarizing the purpose or context of the task.
CREATED TIMESTAMP(6) WITH TIME ZONE NOT NULL

The timestamp the task was created.

LAST_MODIFIED TIMESTAMP(6) WITH TIME ZONE NOT NULL

Indicates the timestamp of the most recent modification to the task.

STATUS VARCHAR2(8) -

Specifies the status of the task.

ORACLE_MAINTAINED NUMBER -

Indicates if the task is maintained by Oracle.

USER_AI_AGENT_TASK_ATTRIBUTES View

The view displays attributes of tasks created by the current user inside their schema.

The current user can see the agent task attributes they own. You cannot grant access to other users. The Database Administrator can access these views but sees only the objects they own.

Column Datatype NULL Description
TASK ID NUMBER NOT NULL

Stores the unique number assigned to an agent task.

TASK_NAME VARCHAR2(128) NOT NULL

Specifies the name of the task.

ATTRIBUTE_NAME VARCHAR2(128) -

Specifies the name of the attributes.

ATTRIBUTE_VALUE CLOB NOT NULL

Specifies the attribute value.

LAST_MODIFIED TIMESTAMP(6) WITH TIME ZONE NOT NULL

Indicates the timestamp of the most recent modification to the agent task attribute.

DBA_AI_AGENT_TEAMS View

The view displays details of the teams created by all users inside their database.

Only the Database Administrator is privileged to access this view. They can grant access to other users. The DBA* views show objects of all Database users.

Column Datatype NULL Description
TEAM ID NUMBER NOT NULL

Stores the unique number assigned to a tool.

TEAM_NAME VARCHAR2(128) NOT NULL

Specifies the name of the team.

OWNER VARCHAR2(128) NOT NULL

Specifies the owner of the team.

DESCRIPTION CLOB -

Provides a description summarizing the purpose or context of the team.

CREATED TIMESTAMP(6) WITH TIME ZONE NOT NULL

The timestamp the team was created.

LAST_MODIFIED TIMESTAMP(6) WITH TIME ZONE NOT NULL

Indicates the timestamp of the most recent modification to the team.

STATUS VARCHAR2(8) -

Specifies the status of the team.

ORACLE_MAINTAINED CHAR(1) -

Indicates if the object is maintained by Oracle.

DBA_AI_AGENT_TEAM_ATTRIBUTES View

The view displays attributes of teams created by all users inside their database.

Only the Database Administrator is privileged to access this view. They can grant access to other users. The DBA* views show objects of all Database users.

Column Datatype NULL Description
TEAM ID NUMBER NOT NULL

Stores the unique number assigned to a task.

TEAM_NAME VARCHAR2(128) NOT NULL

Specifies the name of the team.

OWNER VARCHAR2(128) NOT NULL

Specifies the owner of the team attributes.

ATTRIBUTE_NAME VARCHAR2(128) NOT NULL

Specifies the name of the attributes.

ATTRIBUTE_VALUE CLOB -

Specifies the attribute value.

LAST_MODIFIED TIMESTAMP(6) WITH TIME ZONE -

Indicates the timestamp of the most recent modification to the team attribute.

USER_AI_AGENT_TEAMS View

The view displays details on teams created by the current user inside their schema.

The current user can see the team they own. You cannot grant access to other users. The Database Administrator can access these views but sees only the objects they own.

Column Datatype NULL Description
TEAM ID NUMBER NOT NULL Stores the unique number assigned to an team.
TEAM_NAME VARCHAR2(128) NOT NULL Specifies the name of the team.
DESCRIPTION CLOB - Provides a description summarizing the purpose or context of the team.
CREATED TIMESTAMP(6) WITH TIME ZONE NOT NULL

The timestamp the team was created.

LAST_MODIFIED TIMESTAMP(6) WITH TIME ZONE NOT NULL

Indicates the timestamp of the most recent modification to the team.

STATUS VARCHAR2(8) -

Specifies the status of the team.

ORACLE_MAINTAINED NUMBER -

Indicates if the object is maintained by Oracle.

USER_AI_AGENT_TEAM_ATTRIBUTES View

The view displays details of attributes of teams created by the current user inside their schema.

The current user can see the team attributes they own. You cannot grant access to other users. The Database Administrator can access these views but sees only the objects they own.

Column Datatype NULL Description
TEAM ID NUMBER NOT NULL

Stores the unique number assigned to an agent team.

TEAM_NAME VARCHAR2(128) NOT NULL

Specifies the name of the team.

ATTRIBUTE_NAME VARCHAR2(128) NOT NULL

Specifies the name of the attribute.

ATTRIBUTE_VALUE CLOB -

Specifies the attribute value.

LAST_MODIFIED TIMESTAMP(6) WITH TIME ZONE -

Indicates the timestamp of the most recent modification to the agent team attribute.