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;
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/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/12361284/viewspace-594410/