DM78经常使用的命令汇总2-查询信息类

1.查询数据库所有对象

select * from sysobject a，sysobject b
where a.schid = b.id and (sch.name='SYSDBA' ) and a.subtype$
in ('PROC', 'TRIG','FUNCTION', 'PKG','TYPE', 'SYNOM','CLASS','JAVACLASS', 'DOMAIN', 'CHARSET','CLLT','CONTEXT','VIEW','ROLE','USER') 
ORDER BY a.subtype$

2.获取view定义

call sp_viewdef('SYSDBA', 'TEST_MV');

3.获取同义词定义

select synonmdef('SYSDBA','S1',1,1);

4.获取文本信息

select * from systexts

5.获取错误码

select * from V$err_info where code = -2007

6.获取用户密码信息

select * from sysusers；

7.查看分区索引信息

select * from dba_ind_partitions;

8.查看动态视图的相关信息

select * from sys.V$dynamic_tables;
select * from sys.V$dynamic_table_columns;

9.