查看那些表使用了表分区

SELECT OWNER,TABLE_NAME FROM DBA_TABLES WHERE TABLE_NAME NOT IN(SELECT SEGMENT_NAME FROM DBA_SEGMENTS WHERE SEGMENT_TYPE = 'TABLE'） AND OWNER='GISAP';