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

VIEW: SYS.CDB_IDENTIFIERS

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

Identifiers in stored objects accessible to sys in all containers

[View Source]

Columns
Name Datatype Length Mandatory Comments
OWNER VARCHAR2 (30) 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 (30) 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
CON_ID NUMBER

container id
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
,      CON_ID
FROM SYS.CDB_IDENTIFIERS;

Dependencies

[top of page]

SYS.CDB_IDENTIFIERS does not reference any database object

SYS.CDB_IDENTIFIERS is referenced by following:

SchemaPUBLIC
SynonymCDB_IDENTIFIERS