--query权限即可查看系统有哪些失效的PKG。（我们系统的PKG一般是OPER用户创建的）
select * from all_objects a where a.owner = ‘GNBSOPER‘ and a.status = ‘INVALID‘;
--查看系统表的约束
select * from all_contraints;
|
Type Code |
Type Description |
Acts On Level |
|
C |
Check on a table |
Column |
|
O |
Read Only on a view |
Object |
|
P |
Primary Key |
Object |
|
R |
Referential AKA Foreign Key |
Column |
|
U |
Unique Key |
Column |
|
V |
Check Option on a view |
Object |
--oper权限 查看所有job
select * from all_jobs;
原文：http://www.cnblogs.com/bonnie-lbn/p/4187311.html