oracle,查询分区表和非分区表，索引对应的表空间sql

SELECT  TABLESPACE_NAME  FROM DBA_INDEXES WHERE INDEX_NAME = 'BUSTB_TESTRESULT_IDX1';--非分区表

SELECT SEGMENT_NAME,PARTITION_NAME,TABLESPACE_NAME FROM DBA_SEGMENTS WHERE SEGMENT_NAME='BUSTB_TESTRESULT_IDX1';--分区表

--表与索引对应关系，索引对应表空间，表空间是空的说明是分区索引，不空则是全局索引
SELECT * FROM dba_indexes WHERE table_name IN ('BUSTB_TESTSUMMARY','BUSTB_TESTRESULT');


--存在记录说明是分区索引，不存在是全局索引
SELECT * FROM dba_part_indexes WHERE index_name IN (
'BUSTB_TESTRESULT_IDX1',
'BUSTB_TESTSUMMARY_INDX1',
'BUSTB_TESTSUMMARY_INDX2',
'BUSTB_TESTSUMMARY_INDX3',
'BUSTB_TESTSUMMARY_INDX4')
;


--非分区表
SELECT  TABLESPACE_NAME  FROM DBA_INDEXES WHERE INDEX_NAME = 'BUSTB_TESTSUMMARY_INDX3';
--分区表
SELECT SEGMENT_NAME,PARTITION_NAME,TABLESPACE_NAME FROM DBA_SEGMENTS WHERE SEGMENT_NAME
IN (
'BUSTB_TESTRESULT_IDX1',
'BUSTB_TESTSUMMARY_INDX1',
'BUSTB_TESTSUMMARY_INDX2',
'BUSTB_TESTSUMMARY_INDX4')
;