3.65 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_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(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: