../E40402-16.epub /> ../E40402-16.mobi />

ALL_SECONDARY_OBJECTS

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.

Related Views

  • 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