DBA Data[Home] [Help] [Dependency Information]

VIEW: SYS.DBA_IDENTIFIERS

Object Details
Object Name: DBA_IDENTIFIERS
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

Identifiers in stored objects accessible to sys

[View Source]

Columns
Name Datatype Length Mandatory Comments
OWNER VARCHAR2 (128) Yes
NAME VARCHAR2 (128)
Name of the identifier
SIGNATURE VARCHAR2 (32)
Signature of the identifier
TYPE VARCHAR2 (18)
Type of the identifier
OBJECT_NAME VARCHAR2 (128) Yes Name of the object where the identifier usage occurred
OBJECT_TYPE VARCHAR2 (13)
Type of the object where the identifier usage occurred
USAGE VARCHAR2 (11)
Type of the identifier usage
USAGE_ID NUMBER

Unique key for an identifier usage within the object
LINE NUMBER

Line number of the identifier usage
COL NUMBER

Column number of the identifier usage
USAGE_CONTEXT_ID NUMBER

Context USAGE_ID of an identifier usage
ORIGIN_CON_ID NUMBER

ID of Container where row originates
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT OWNER
,      NAME
,      SIGNATURE
,      TYPE
,      OBJECT_NAME
,      OBJECT_TYPE
,      USAGE
,      USAGE_ID
,      LINE
,      COL
,      USAGE_CONTEXT_ID
,      ORIGIN_CON_ID
FROM SYS.DBA_IDENTIFIERS;

Dependencies

[top of page]

SYS.DBA_IDENTIFIERS references the following:

SchemaSYS
ViewINT$DBA_IDENTIFIERS
SYS.DBA_IDENTIFIERS is referenced by following:

SchemaPUBLIC
SynonymDBA_IDENTIFIERS