ALL_SECONDARY_OBJECTS provides information about secondary objects associated with ___domain indexes accessible to the user. This view is only relevant in the context of ___domain indexes. And currently, the secondary objects can only be tables.
DBA_SECONDARY_OBJECTS provides information about all secondary objects that are associated with ___domain indexes in the database.
USER_SECONDARY_OBJECTS provides information about secondary objects associated with ___domain indexes owned by the current user.
| Column | Datatype | NULL | Description |
|---|---|---|---|
INDEX_OWNER |
VARCHAR2(30) |
NOT NULL |
Owner of the ___domain index |
INDEX_NAME |
VARCHAR2(30) |
NOT NULL |
Name of the ___domain index |
SECONDARY_OBJECT_OWNER |
VARCHAR2(30) |
NOT NULL |
Owner of the secondary object created by the ___domain index |
SECONDARY_OBJECT_NAME |
VARCHAR2(30) |
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 |