1、如果是非分区表
select object_id from oceanbase.dba_objects where object_name=‘t3’; --假设返回 500440
select * from DBA_OB_TABLE_LOCATIONS where table_type=‘index’ and data_table_id=500440;
2、如果是分区表
select object_id from oceanbase.dba_objects where object_name=‘t_part2’ and data_object_id is null; – 假设返回 500443
select * from DBA_OB_TABLE_LOCATIONS where table_type=‘index’ and data_table_id=500443;