JavaScript must be enabled to correctly display this content

ALL_ANNOTATIONS_USAGE

ALL_ANNOTATIONS_USAGE provides usage information about schema annotations accessible to the current user.

DBA_ANNOTATIONS_USAGE provides usage information about all schema annotations in the database.
USER_ANNOTATIONS_USAGE provides usage information about schema annotations owned by the current user. This view does not display the ANNOTATION_OWNER column.

Column	Datatype	NULL	Description
`OBJECT_NAME`	`VARCHAR2(128)`		Object name
`OBJECT_TYPE`	`VARCHAR2(9)`		Object type
`COLUMN_NAME`	`VARCHAR2(128)`		If the annotation is specified for a table column, view column, or domain column, the name of the column; otherwise NULL
`DOMAIN_NAME`	`VARCHAR2(128)`		If the annotation is carried over from a domain or a domain column, the name of the domain; otherwise NULL Note that domains carry over their annotations to objects that reference them.
`DOMAIN_OWNER`	`VARCHAR2(128)`		If the annotation is carried over from a domain or domain column, the owner of the domain; otherwise NULL Note that domains carry over their annotations to objects that reference them.
`ANNOTATION_OWNER`	`VARCHAR2(128)`		Annotation owner
`ANNOTATION_NAME`	`VARCHAR2(1024)`		Annotation name
`ANNOTATION_VALUE`	`VARCHAR2(4000)`		Optional annotation value A NULL value is possible when the annotation does not require a value, that is, when the annotation is defined solely by its name.

Note: This view is available starting with Oracle AI Database 26ai.

See Also:

“DBA_ANNOTATIONS_USAGE”
“USER_ANNOTATIONS_USAGE”