oracle 常用于表、索引的查询
查看某个用户下所有类型为视图的表名
select * from dba_tab_comments where owner='名字' and table_type='VIEW';
开启某用户下所有表的全列
select 'alter table ' || OWNER||'.'||TABLE_NAME || ' add supplemental log data (all,primary key,unique,foreign key) columns' from dba_tables where owner='名字' ;
select 'info trandata ' || OWNER||'.'||TABLE_NAME from dba_tables where owner='名字' ;
查看xml表名
select * from all_xml_tables;
查看索引是否生效
select status from dba_indexes where index_name='PK_INPATITEM';
查看表的全部索引
select index_owner,index_name,column_name from dba_ind_columns where table_name=upper('表名') and table_owner='owner';
a用户下授权查询所有的表给b用户
select 'grant select on a.' || table_name || ' to b;' from user_tables;
查询表的大小
select segment_name, segment_type,owner,bytes/1024/1024 M from dba_segments where segment_type='TABLE' and segment_name = 'TABLE_NAME';
哪有什么胜利可言,坚持意味着一切。如想使用请备注转载链接~