USER_DEPENDENCIES v16

The USER_DEPENDENCIES view provides information about dependencies between objects owned by a current user, with the exception of synonyms.

Name	Type	Description
`schema_name`	`CHARACTER VARYING(128)`	Name of the schema in which the dependent object resides.
`name`	`CHARACTER VARYING(128)`	Name of the dependent object.
`type`	`CHARACTER VARYING(18)`	Type of the dependent object.
`referenced_owner`	`CHARACTER VARYING(128)`	Owner of the referenced object.
`referenced_schema_name`	`CHARACTER VARYING(128)`	Name of the schema in which the referenced object resides.
`referenced_name`	`CHARACTER VARYING(128)`	Name of the referenced object.
`referenced_type`	`CHARACTER VARYING(18)`	Type of the referenced object.
`referenced_link_name`	`CHARACTER VARYING(128)`	Included only for compatibility. Always `NULL`.
`schemaid`	`NUMERIC`	ID of the current schema.
`dependency_type`	`CHARACTER VARYING(4)`	Included only for compatibility. Always set to `HARD`.

← Prev

USER_DB_LINKS

↑ Up

Oracle catalog views

Next →

USER_INDEXES