partition show for oracle version

Dear all

 

   You  may remember that my blog has a view script for checking sqlserver partition tables.  Now , it`s oracle version comes.

 

----- script --------

select part.table_owner,part.table_name,part.partition_name ,part.tablespace_name as "part_tablespacename",part.high_value as "high_value",part.num_rows,subpart.subpartition_name,subpart.tablespace_name as "subpart_tablespacename"

from dba_tab_partitions part left join dba_tab_subpartitions subpart

on part.table_name = subpart.table_name and part.partition_name = subpart.partition_name

where part.table_owner='DBA' and part.table_name in (select distinct segment_name from dba_segments where owner='DBA' and segment_type like 'TABLE%PARTITION' )

ORDER by part.table_owner,part.table_name,part.partition_name,part.tablespace_name

 

Then you can get result like that .

 

 

  Thanks