查询依赖对象(嵌套)
来源:互联网 发布:起爆点指标公式源码 编辑:程序博客网 时间:2024/06/05 01:56
@E:/oracle/product/10.2.0/db_1/RDBMS/ADMIN/utldtree.sql
--/s01/oracle/product/11.2.0.1/db_home1/rdbms/admin/utldtree.sql
BEGIN
deptree_fill(name => 'OSS_PRODUCT_MID_DAY_201109',schema => 'OSS03',type => 'TABLE');
END;
SELECT * FROM ideptree;
ideptree 这个视图了
exec deptree_fill('TABLE','SCOTT','DEPT');
--依赖个人版:
select * from Dba_Objects where object_name like '%OSS_SP_MAIL_BATCH_TOTAL_STAT%'
BEGIN
deptree_fill(name => 'OSS_SP_MAIL_BATCH_TOTAL_STAT',schema => 'OSS03',type => 'PROCEDURE');
END;
select d.nest_level, o.object_type, o.owner, o.object_name, d.seq#,o.object_name
from deptree_temptab d, dba_objects o
where d.object_id = o.object_id (+)
union all
select d.nest_level+1, 'CURSOR', '<shared>', '"'||c.kglnaobj||'"', d.seq#+.5,g.kglnaobj
from deptree_temptab d, x$kgldp k, x$kglob g, obj$ o, user$ u, x$kglob c,
x$kglxs a
where d.object_id = o.obj#
and o.name = g.kglnaobj
and o.owner# = u.user#
and u.name = g.kglnaown
and g.kglhdadr = k.kglrfhdl
and k.kglhdadr = a.kglhdadr /* make sure it is not a transitive */
and k.kgldepno = a.kglxsdep /* reference, but a direct one */
and k.kglhdadr = c.kglhdadr
and c.kglhdnsp = 0
select d.nest_level
x$kgldp k, x$kglob g, obj$ o, user$ u, x$kglob c,
x$kglxs a
--在线重定义失败后的索引恢复:
DECLARE
isClean BOOLEAN;
BEGIN
isClean := FALSE;
WHILE isClean=FALSE
LOOP
isClean := dbms_repair.online_index_clean(dbms_repair.all_index_id, dbms_repair.lock_wait);
dbms_lock.sleep(5);
END LOOP;
END;
- 查询依赖对象(嵌套)
- MyBatis查询嵌套对象
- 嵌套查询
- 嵌套查询
- 嵌套查询
- 嵌套查询
- 嵌套查询
- 嵌套查询
- 嵌套查询
- 嵌套查询
- selenium实现嵌套页面对象实例--查询功能(POM)
- 嵌套依赖类型名
- 单表多条件查询,匿名类型,匿名对象,嵌套查询,Linq序列转换后调用外部方法
- 当对象包含嵌套对象时,使用Spark SQL执行sql查询抛出scala.MatchError异常
- oracle 查询自定的type为collection的所有对象和其依赖对象
- 嵌套查询的查询优化
- 多表查询,嵌套查询
- oracle子查询嵌套查询
- POI,java导出execl
- LeetCode problem 4:Sort List
- 使用KeyboardView导致EditText光标不显示的问题
- 00认证(Authentication)和授权(Authorization)
- 电脑高手常用的5个按钮
- 查询依赖对象(嵌套)
- Java基础---Java---网络编程---TCP、UDP、UDP-键盘录入方式数据、Socket、TCP复制文件、UDP-聊天
- Excel2003默认调色板颜色索引对照表
- 阿里实习生招聘笔试题目
- 刷新物化视图脚本
- 1006. 求和游戏--最大子数列求和(子数列长度大于1)
- sqlserver 锁
- Apple
- 给技术人上的管理课:激励与授权