Wednesday, February 8, 2023

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


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

There is no direct view to represent the info


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>';


No comments: