Oracle Database 19c -- How to Find Segments of an Index-Organized Table

Problem

You have an index-organized table, and you want to identify the segments of it

There is no direct view to represent the info

Solution

1) Identify the OBJECT_ID of the index-organized table by name:

SQL> select object_id from dba_objects
         where object_name ='<table_name>' and object_type='TABLE';

2) Use the identified object if from step 1) to identify the segments of the table:

SQL> select * from dba_segments where segment_name like '%<object_id>';