ALL_SECONDARY_OBJECTS
ALL_SECONDARY_OBJECTS provides information about secondary objects associated with domain indexes accessible to the user.
This view is only relevant for domain indexes. And currently, the secondary objects can only be tables.
Related Views
-
DBA_SECONDARY_OBJECTSprovides information about all secondary objects that are associated with domain indexes in the database. -
USER_SECONDARY_OBJECTSprovides information about secondary objects associated with domain indexes owned by the current user.
| Column | Datatype | NULL | Description |
|---|---|---|---|
INDEX_OWNER |
VARCHAR2(128) |
NOT NULL |
Owner of the domain index |
INDEX_NAME |
VARCHAR2(128) |
NOT NULL |
Name of the domain index |
SECONDARY_OBJECT_OWNER |
VARCHAR2(128) |
NOT NULL |
Owner of the secondary object created by the domain index |
SECONDARY_OBJECT_NAME |
VARCHAR2(128) |
NOT NULL |
Name of the secondary object created by the domain index |
SECONDARY_OBJDATA_TYPE |
VARCHAR2(20) |
Type of the secondary object created by the domain index |
See Also: