ALL_REFS
describes the REF
columns and REF
attributes in object type columns accessible to the current user.
DBA_REFS
describes all REF
columns and REF
attributes in the database.
USER_REFS
describes the REF
columns and REF
attributes in object type columns owned by the current user. This view does not display the OWNER
column.
Column | Datatype | NULL | Description |
---|---|---|---|
OWNER |
VARCHAR2(30) |
NOT NULL |
Name of the owner |
TABLE_NAME |
VARCHAR2(30) |
NOT NULL |
Name of the table |
COLUMN_NAME |
VARCHAR2(4000) |
Name of the REF column or attribute. If it is not a top-level attribute, the value of COLUMN_NAME should be a path name starting with the column name |
|
WITH_ROWID |
VARCHAR2(3) |
Indicates whether the REF value is stored with ROWID (YES ) or not (NO ) |
|
IS_SCOPED |
VARCHAR2(3) |
Indicates whether the REF column is scoped (YES ) or not (NO ) |
|
SCOPE_TABLE_OWNER |
VARCHAR2(30) |
Name of the owner of the scope table, if it exists and is accessible by the user | |
SCOPE_TABLE_NAME |
VARCHAR2(30) |
Name of the scope table, if it exists and is accessible by the user | |
OBJECT_ID_TYPE |
VARCHAR2(16) |
If user-defined OID, then USER-DEFINED , else if system generated OID, then SYSTEM GENERATED |