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;
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博客 ” ，链接：https://blog.itpub.net/12361284/viewspace-594410/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
