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 |