DBA_SECONDARY_OBJECTS
provides information about all secondary objects that are associated with ___domain indexes in the database. This view is only relevant in the context of ___domain indexes. Its columns are the same as those in "ALL_SECONDARY_OBJECTS".