ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Getting More Information about Partitions

Getting More Information about Partitions

原创 Linux操作系统 作者:oracle_ace 时间:2009-05-07 13:01:49 0 删除 编辑
 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/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2007-12-10

  • 博文量
    284
  • 访问量
    797065