速查表的名称和建表语句

select table_name from dict where table_name like '%STATIS%';
先设置set long 1000

select dbms_metadata.get_ddl('TABLESPACE','TEMP') from dual; 

select dbms_metadata.get_ddl('TABLE','KU$_LIST_FILTER_TEMP') from dual;   

侧重区上：这个分区表显示数据库所有分区表的详细分区信息

Desc dba_tab_partitions

 

侧重表上:显示当前用户可访问的所有分区表的信息

Desc dba_part_tables

 --查看表的stats

select * from user_tab_statistics where table_name = 'STUDENT'

--查看列的stats

select * from user_tab_col_statistics where table_name = 'STUDENT'

--查看索引的stats

select * from user_ind_statistics where table_name = 'STUDENT'

   

来自为知笔记(Wiz)