Getting More Information about Partitions

 We can retrieve the information regarding partitions by accessing user_tables, dba_part_tables,and user_segments. Example queries to these three tables are displayed next with corresponding output for the examples in the preceding section.

select table_name, partitioned
from dba_tables
where table_name in ('DEPT','EMP');

select owner, table_name, partition_count
from dba_part_tables
where table_name = 'DEPT';

select segment_name, partition_name, segment_type, tablespace_name
from user_segments;

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/12361284/viewspace-594410/，如需轉載，請註明出處，否則將追究法律責任。