在12c的$ORACLE_HOME/rdbms/admin下找到 INT$DBA_CONSTRAINTS 的定义
来源:互联网 发布:网络兼职淘宝代刷员 编辑:程序博客网 时间:2024/06/15 06:05
[oracle@rhel59 admin]$ pwd/u01/app/oracle/product/12.1.0/dbhome_1/rdbms/admin[oracle@rhel59 admin]$ grep -rn 'INT$DBA_CONSTRAINTS' ././e1201000.sql:138:Rem thbaby 09/17/13 - lrg 9710290: reload INT$DBA_CONSTRAINTS./e1201000.sql:150:Rem thbaby 08/13/13 - 16956123: drop view INT$INT$DBA_CONSTRAINTS./e1201000.sql:881:drop view INT$INT$DBA_CONSTRAINTS;./e1201000.sql:883:-- lrg 9710290: 12.1.0.2->12.1.0.1 downgrade drops INT$INT$DBA_CONSTRAINTS, ./e1201000.sql:884:-- which causes INT$DBA_CONSTRAINTS to be marked invalid. This, in turn, ./e1201000.sql:887:-- definition of INT$DBA_CONSTRAINTS right after INT$INT$DBA_CONSTRAINTS ./e1201000.sql:889:create or replace view INT$DBA_CONSTRAINTS COMMON_DATA ./cdcore.sql:37:Rem querying INT$DBA_CONSTRAINTS./cdcore.sql:76:Rem thbaby 05/31/13 - 16813682: INT$DBA_CONSTRAINTS is not common data ./cdcore.sql:14122:create or replace view INT$INT$DBA_CONSTRAINTS COMMON_DATA ./cdcore.sql:14181:-- INT$DBA_CONSTRAINTS has two object types - a view and a table../cdcore.sql:14191:create or replace view INT$DBA_CONSTRAINTS./cdcore.sql:14205:from INT$INT$DBA_CONSTRAINTS INT$INT$DBA_CONSTRAINTS./cdcore.sql:14206:where INT$INT$DBA_CONSTRAINTS.OBJECT_TYPE# = 4./cdcore.sql:14207: OR (INT$INT$DBA_CONSTRAINTS.OBJECT_TYPE# = 2./cdcore.sql:14208: AND (INT$INT$DBA_CONSTRAINTS.ORIGIN_CON_ID IN (0,1)./cdcore.sql:14209: OR INT$INT$DBA_CONSTRAINTS.SHARING = 0))./cdcore.sql:14211:-- Even though DBA_CONSTRAINTS and INT$DBA_CONSTRAINTS look very similar ./cdcore.sql:14213:-- selects fewer columns than INT$DBA_CONSTRAINTS../cdcore.sql:14228:from INT$DBA_CONSTRAINTS ./cdcore.sql:14320:from NO_ROOT_SW_FOR_LOCAL(INT$INT$DBA_CONSTRAINTS) INT$INT$DBA_CONSTRAINTS./cdcore.sql:14321:where INT$INT$DBA_CONSTRAINTS.OBJECT_TYPE# = 4 /* views */./cdcore.sql:14322: and INT$INT$DBA_CONSTRAINTS.OWNER=SYS_CONTEXT('USERENV', 'CURRENT_USER')./cdcore.sql:14330:from NO_COMMON_DATA(INT$INT$DBA_CONSTRAINTS) INT$INT$DBA_CONSTRAINTS./cdcore.sql:14331:where INT$INT$DBA_CONSTRAINTS.OBJECT_TYPE# = 2 /* tables */./cdcore.sql:14332: and INT$INT$DBA_CONSTRAINTS.OWNER=SYS_CONTEXT('USERENV', 'CURRENT_USER')./cdcore.sql:14416:from INT$DBA_CONSTRAINTS ./upobjxt.lst:60914:SYS,INT$DBA_CONSTRAINTS,,4, ./upobjxt.lst:61068:SYS,INT$INT$DBA_CONSTRAINTS,,4, ./e1102000.sql:9039:drop view INT$DBA_CONSTRAINTS;
于是定位到下面的一行:
./cdcore.sql:14191:create or replace view INT$DBA_CONSTRAINTS
然后vi cdcore.sql ,找到如下的信息:
-- INT$DBA_CONSTRAINTS has two object types - a view and a table.-- The dictionary information about linked views is stored only in ROOT,-- with a dummy obj$ row in PDB to indicate this. Hence we can use common-- data view mechanism to fetch view constraints.-- The dictionary information about linked tables however is stored in-- all the containers. Hence using common data view mechanism would fetch-- duplicate constraints. So we added a condition that if the object is-- a not a linked table then fetch the constraint and if it is a linked-- table then fetch the constraint only if the origin con id is root or-- non-cdb.create or replace view INT$DBA_CONSTRAINTS (OWNER, CONSTRAINT_NAME, CONSTRAINT_TYPE, TABLE_NAME, OBJECT_ID, OBJECT_TYPE#, SEARCH_CONDITION, SEARCH_CONDITION_VC, R_OWNER, R_CONSTRAINT_NAME, DELETE_RULE, STATUS, DEFERRABLE, DEFERRED, VALIDATED, GENERATED, BAD, RELY, LAST_CHANGE, INDEX_OWNER, INDEX_NAME, INVALID, VIEW_RELATED, SHARING, ORIGIN_CON_ID)asselect OWNER, CONSTRAINT_NAME, CONSTRAINT_TYPE, TABLE_NAME, OBJECT_ID, OBJECT_TYPE#, SEARCH_CONDITION, SEARCH_CONDITION_VC, R_OWNER, R_CONSTRAINT_NAME, DELETE_RULE, STATUS, DEFERRABLE, DEFERRED, VALIDATED, GENERATED, BAD, RELY, LAST_CHANGE, INDEX_OWNER, INDEX_NAME, INVALID, VIEW_RELATED, SHARING, ORIGIN_CON_IDfrom INT$INT$DBA_CONSTRAINTS INT$INT$DBA_CONSTRAINTSwhere INT$INT$DBA_CONSTRAINTS.OBJECT_TYPE# = 4 OR (INT$INT$DBA_CONSTRAINTS.OBJECT_TYPE# = 2 AND (INT$INT$DBA_CONSTRAINTS.ORIGIN_CON_ID IN (0,1) OR INT$INT$DBA_CONSTRAINTS.SHARING = 0))/-- Even though DBA_CONSTRAINTS and INT$DBA_CONSTRAINTS look very similar-- in their definitions, we need both these views because DBA_CONSTRAINTS-- selects fewer columns than INT$DBA_CONSTRAINTS.create or replace view DBA_CONSTRAINTS (OWNER, CONSTRAINT_NAME, CONSTRAINT_TYPE, TABLE_NAME, SEARCH_CONDITION, SEARCH_CONDITION_VC, R_OWNER, R_CONSTRAINT_NAME, DELETE_RULE, STATUS, DEFERRABLE, DEFERRED, VALIDATED, GENERATED, BAD, RELY, LAST_CHANGE, INDEX_OWNER, INDEX_NAME, INVALID, VIEW_RELATED, ORIGIN_CON_ID)asselect OWNER, CONSTRAINT_NAME, CONSTRAINT_TYPE, TABLE_NAME, SEARCH_CONDITION, SEARCH_CONDITION_VC, R_OWNER, R_CONSTRAINT_NAME, DELETE_RULE, STATUS, DEFERRABLE, DEFERRED, VALIDATED, GENERATED, BAD, RELY, LAST_CHANGE, INDEX_OWNER, INDEX_NAME, INVALID, VIEW_RELATED, ORIGIN_CON_IDfrom INT$DBA_CONSTRAINTS/
0 0
- 在12c的$ORACLE_HOME/rdbms/admin下找到 INT$DBA_CONSTRAINTS 的定义
- 12c Oracle_Home下的监听器监听11g数据库的问题
- $ORACLE_HOME/bin下的utilities解释
- oracle_base 和 oracle_home 的区别
- [django]定义django admin的list_display
- Codd 提出的 RDBMS 12项准则
- 【翻译自mos文章】oracle支持在RDBMS HOME 下的 符号链接( Symbolic Links)吗?
- 找到int最左边的那个1
- Hive定义、Hive与HBase关系、Hive与RDBMS的关系、数据库与数据仓库的区别
- Weblogic 12c 在集群部署程序的时候,启动受管服务器。状态是Admin,而不是RUNJING
- 误删除$ORACLE_HOME/dbs下的参数文件、密码文件,如何快速重建
- 解释$ORACLE_HOME和$ORACLE_BASE的区别? .
- DBMS与RDBMS的区别
- DAL – RDBMS 的分区
- RDBMS与NOsql的区别
- RDBMS与NOsql的区别
- hbase和RDBMS的区别
- 数据库的学习--RDBMS,NoSQL
- nginx上搭建HLS流媒体服务器
- 简单谈谈session机制的原理
- 将JavaFX运行到Android上
- php 操作数组 (合并,拆分,追加,查找,删除等)
- 高斯消元
- 在12c的$ORACLE_HOME/rdbms/admin下找到 INT$DBA_CONSTRAINTS 的定义
- 2014年最后的碎碎念...
- Linux内核设计与实现之内核同步介绍
- HLS自己总结
- LEETCODE: Convert Sorted Array to Binary Search Tree
- iOS Swift教程 Core Data (三)Core Data栈 下
- 传统企业电商峰值系统应对实践
- PHP下对数组进行排序的函数
- android获得控件在屏幕中的绝对坐标 getLocationInWindow 和 getLocationOnScreen