–触发器编译
select ‘alter trigger ‘||OWNER||’.’||TRIGGER_NAME||’ compile;’ from dba_triggers where OWNER=‘XXXX’;

–存储过程编译
select ‘alter procedure ‘||OWNER||’.’||object_NAME||’ compile;’ from dba_procedures where OWNER=‘XXXX’;

–函数编译
select ‘alter FUNCTION ‘||OWNER||’.’||object_NAME||’ compile;’ from dba_objects WHERE OBJECT_TYPE=‘FUNCTION’;

–视图编译
select ‘alter view ‘||OWNER||’.’||VIEW_NAME||’ compile;’ from dba_views where OWNER=‘XXXX’;

–包／包体编译
select ‘alter PACKAGE ‘||OWNER||’.’||object_NAME||’ compile;’ from dba_objects WHERE OBJECT_TYPE IN (‘PACKAGE’,‘PACKAGE BODY’);

–批量启用约束
select ‘ALTER TABLE ‘||OWNER||’.’|| TABLE_NAME||’ ENABLE constraint ‘||CONSTRAINT_NAME||’;’ from dba_constraints where OWNER=‘XXXX’;

–批量禁用约束
select ‘ALTER TABLE ‘||OWNER||’.’|| TABLE_NAME||’ DISABLED constraint ‘||CONSTRAINT_NAME||’;’ from dba_constraints where OWNER=‘XXXX’;

–批量启用外键约束
select ‘ALTER TABLE ‘||OWNER||’.’|| TABLE_NAME||’ enable constraint ‘||CONSTRAINT_NAME||’;’ from dba_constraints where CONSTRAINT_TYPE=‘R’ and STATUS=‘DISABLED’ and OWNER=‘XXXX’;

–授予TEST1用户可读写TEST2用户下的所有表的权限
select ‘grant select ,insert,update ,delete on TEST2.’||table_name||’ to TEST1;’ from dba_tables where owner=‘TEST2’;