Since Oct-2017 I am quarterly writing a post dissecting the changes implemented by Oracle CPUs so we can understand better the modifications implemented by Oracle in our Databases.<\/p>\n
So what oracle internal objects were changed in 180116?<\/p>\n
VERSION PATCH OWNER TYPE TOTAL\r\n-------------------- ---------- ------------------------------ ------------------------------ ----------\r\n11.2.0.4 PSU & BP SYS PACKAGE 1\r\n11.2.0.4 PSU & BP SYS PACKAGE BODY 2\r\n12.1.0.2 BP SYS PACKAGE BODY 3\r\n12.1.0.2 PSU & BP SYS PACKAGE BODY 1\r\n12.2.0.1 JUL2017RUR SYS PACKAGE BODY 2\r\n12.2.0.1 OCT2017RUR SYS PACKAGE BODY 2\r\n12.2.0.1 RU CTXSYS PACKAGE BODY 1\r\n12.2.0.1 RU DVSYS TYPE 6\r\n12.2.0.1 RU DVSYS VIEW 2\r\n12.2.0.1 RU SYS PACKAGE 1\r\n12.2.0.1 RU SYS PACKAGE BODY 10\r\n12.2.0.1 RU SYS VIEW 10\r\n<\/pre>\nAnd created?<\/p>\n
VERSION PATCH OWNER TYPE TOTAL\r\n-------------------- ---------- ------------------------------ ------------------------------ ----------\r\n11.2.0.4 OJVM PUBLIC SYNONYM 21\r\n12.1.0.2 BP SYS PACKAGE BODY 1\r\n12.1.0.2 OJVM PUBLIC SYNONYM 21\r\n12.1.0.2 PSU SYS PACKAGE BODY 1<\/pre>\nSo which are exactly the objects modified by 180116?<\/p>\n
VERSION PATCH OWNER TYPE NAME\r\n-------------------- ---------- ------------------------------ ------------------------------ ------------------------------\r\n11.2.0.4 PSU & BP SYS PACKAGE BODY DBMS_BACKUP_RESTORE\r\n11.2.0.4 PSU & BP SYS PACKAGE DBMS_BACKUP_RESTORE\r\n11.2.0.4 PSU & BP SYS PACKAGE BODY DBMS_LOGREP_EXP\r\n12.1.0.2 BP SYS PACKAGE BODY DBMS_LOGREP_EXP\r\n12.1.0.2 BP SYS PACKAGE BODY DBMS_OPTIM_BUNDLE\r\n12.1.0.2 BP SYS PACKAGE BODY PRVT_ILM\r\n12.1.0.2 PSU & BP SYS PACKAGE BODY CDBVIEW\r\n12.2.0.1 JUL2017RUR SYS PACKAGE BODY CDBVIEW\r\n12.2.0.1 JUL2017RUR SYS PACKAGE BODY PRVTEMX_CELL\r\n12.2.0.1 OCT2017RUR SYS PACKAGE BODY CDBVIEW\r\n12.2.0.1 OCT2017RUR SYS PACKAGE BODY PRVTEMX_CELL\r\n12.2.0.1 RU CTXSYS PACKAGE BODY DRVDDL\r\n12.2.0.1 RU DVSYS TYPE KU$_DV_REALM_MEMBER_T\r\n12.2.0.1 RU DVSYS TYPE KU$_DV_RULE_SET_MEMBER_T\r\n12.2.0.1 RU DVSYS TYPE SYS_YOID0000072649$\r\n12.2.0.1 RU DVSYS TYPE SYS_YOID0000072661$\r\n12.2.0.1 RU DVSYS TYPE SYS_YOID0000072855$\r\n12.2.0.1 RU DVSYS TYPE SYS_YOID0000072867$\r\n12.2.0.1 RU DVSYS VIEW KU$_DV_REALM_MEMBER_VIEW\r\n12.2.0.1 RU DVSYS VIEW KU$_DV_RULE_SET_MEMBER_VIEW\r\n12.2.0.1 RU SYS PACKAGE PRVT_COMPRESSION\r\n12.2.0.1 RU SYS PACKAGE BODY CDBVIEW\r\n12.2.0.1 RU SYS PACKAGE BODY DBMS_APPLY_ADM_INTERNAL\r\n12.2.0.1 RU SYS PACKAGE BODY DBMS_AQADM_SYS\r\n12.2.0.1 RU SYS PACKAGE BODY DBMS_COMPRESSION\r\n12.2.0.1 RU SYS PACKAGE BODY DBMS_LOGREP_EXP\r\n12.2.0.1 RU SYS PACKAGE BODY DBMS_OPTIM_BUNDLE\r\n12.2.0.1 RU SYS PACKAGE BODY DBMS_PRVTAQIM\r\n12.2.0.1 RU SYS PACKAGE BODY DBMS_RCVMAN\r\n12.2.0.1 RU SYS PACKAGE BODY PRVTEMX_CELL\r\n12.2.0.1 RU SYS PACKAGE BODY PRVT_ILM\r\n12.2.0.1 RU SYS VIEW LOGSTDBY_RU_UNSUPPORT_TAB_12_1\r\n12.2.0.1 RU SYS VIEW LOGSTDBY_RU_UNSUPPORT_TAB_12_2\r\n12.2.0.1 RU SYS VIEW LOGSTDBY_SUPPORT_TAB_12_1\r\n12.2.0.1 RU SYS VIEW LOGSTDBY_SUPPORT_TAB_12_2\r\n12.2.0.1 RU SYS VIEW LOGSTDBY_UNSUPPORT_TAB_12_1\r\n12.2.0.1 RU SYS VIEW LOGSTDBY_UNSUPPORT_TAB_12_2\r\n12.2.0.1 RU SYS VIEW OGG_SUPPORT_TAB_11_2\r\n12.2.0.1 RU SYS VIEW OGG_SUPPORT_TAB_11_2B\r\n12.2.0.1 RU SYS VIEW OGG_SUPPORT_TAB_12_1\r\n12.2.0.1 RU SYS VIEW OGG_SUPPORT_TAB_12_2<\/pre>\nWhat changed for each?<\/strong><\/h2>\n
\n
- 11.2.0.4<\/a><\/li>\n
- 12.1.0.2<\/a><\/li>\n
- 12.2.0.1<\/a><\/li>\n<\/ul>\n
P.S:\u00a0<\/strong><\/span><\/p>\n
<\u00a0 = Added Lines<\/strong><\/span><\/p>\n
>\u00a0 = Removed Lines<\/strong><\/span><\/p>\n
11.2.0.4<\/strong><\/h2>\n
SYS.DBMS_BACKUP_RESTORE – PACKAGE BODY (PSU & BP):<\/p>\n
1542,1546c1542\r\n< ,PLTFRMFR IN BINARY_INTEGER\r\n< ,ENCRYPT IN NUMBER\r\n< ,ENC_ALGORITHM IN NUMBER\r\n< ,ALLOWTDE IN NUMBER\r\n< ,PASSWORD IN VARCHAR2);\r\n---\r\n> ,PLTFRMFR IN BINARY_INTEGER);\r\n1678,1708c1674\r\n< BEGIN\r\n< BACKUPBACKUPPIECE(BPNAME, FNAME, HANDLE, COMMENT, MEDIA, CONCUR,\r\n< RECID, STAMP, TAG, PARAMS, MEDIA_POOL, REUSE,\r\n< CHECK_LOGICAL, COPYNO, DEFFMT, COPY_RECID,\r\n< COPY_STAMP, NPIECES, DEST, PLTFRMFR, 0, 0, 0, NULL);\r\n< END;\r\n< \r\n< PROCEDURE BACKUPBACKUPPIECE( BPNAME IN VARCHAR2\r\n< ,FNAME IN VARCHAR2\r\n< ,HANDLE OUT VARCHAR2\r\n< ,COMMENT OUT VARCHAR2\r\n< ,MEDIA OUT VARCHAR2\r\n< ,CONCUR OUT BOOLEAN\r\n< ,RECID OUT NUMBER\r\n< ,STAMP OUT NUMBER\r\n< ,TAG IN VARCHAR2 DEFAULT NULL\r\n< ,PARAMS IN VARCHAR2 DEFAULT NULL\r\n< ,MEDIA_POOL IN BINARY_INTEGER DEFAULT 0\r\n< ,REUSE IN BOOLEAN DEFAULT FALSE\r\n< ,CHECK_LOGICAL IN BOOLEAN\r\n< ,COPYNO IN BINARY_INTEGER\r\n< ,DEFFMT IN BINARY_INTEGER\r\n< ,COPY_RECID IN NUMBER\r\n< ,COPY_STAMP IN NUMBER\r\n< ,NPIECES IN BINARY_INTEGER\r\n< ,DEST IN BINARY_INTEGER\r\n< ,PLTFRMFR IN BINARY_INTEGER\r\n< ,ENCRYPT IN NUMBER\r\n< ,ENC_ALGORITHM IN NUMBER\r\n< ,ALLOWTDE IN NUMBER\r\n< ,PASSWORD IN VARCHAR2) IS\r\n---\r\n> \r\n1718,1719c1684\r\n< NPIECES, FALSE, DEST, PLTFRMFR,\r\n< ENCRYPT, ENC_ALGORITHM, ALLOWTDE, PASSWORD);\r\n---\r\n> NPIECES, FALSE, DEST, PLTFRMFR);\r\n1764,1768c1729\r\n< ,PLTFRMFR => 0\r\n< ,ENCRYPT => 0\r\n< ,ENC_ALGORITHM => 0\r\n< ,ALLOWTDE => 0\r\n< ,PASSWORD => NULL);\r\n---\r\n> ,PLTFRMFR => 0);<\/pre>\nSYS.DBMS_BACKUP_RESTORE – PACKAGE (PSU & BP):<\/p>\n
7493,7523d7492\r\n< PROCEDURE backupBackupPiece( bpname IN varchar2\r\n< ,fname IN varchar2\r\n< ,handle OUT varchar2\r\n< ,comment OUT varchar2\r\n< ,media OUT varchar2\r\n< ,concur OUT boolean\r\n< ,recid OUT number\r\n< ,stamp OUT number\r\n< ,tag IN varchar2 default NULL\r\n< ,params IN varchar2 default NULL\r\n< ,media_pool IN binary_integer default 0\r\n< ,reuse IN boolean default FALSE\r\n< ,check_logical IN boolean\r\n< ,copyno IN binary_integer\r\n< ,deffmt IN binary_integer\r\n< ,copy_recid IN number\r\n< ,copy_stamp IN number\r\n< ,npieces IN binary_integer\r\n< ,dest IN binary_integer\r\n< ,pltfrmfr IN binary_integer\r\n< ,encrypt IN number\r\n< ,enc_algorithm IN number\r\n< ,allowTDE IN number\r\n< ,password IN varchar2);\r\n< --\r\n< -- Description and return values can be found with original declaration\r\n< -- above. The new arguments are:\r\n< -- encrypt flag\r\n< -- algorithm used for encryption\r\n< -- allow TDE\r\n< -- password<\/pre>\nSYS.DBMS_LOGREP_EXP – PACKAGE BODY (PSU & BP):<\/p>\n
2961c2961,2962\r\n< \r\n---\r\n> \r\n> \r\n2962a2964,2968\r\n> SELECT NVL(MAX(CO.SCN), 0) INTO IGNORE_SCN\r\n> FROM ALL_CAPTURE_PREPARED_TABLES CO\r\n> WHERE CO.TABLE_OWNER = INSTANCE_EXTENDED_INFO_EXP.SCHEMA\r\n> AND CO.TABLE_NAME = INSTANCE_EXTENDED_INFO_EXP.NAME;\r\n> \r\n2964,2965c2970,2974\r\n< \r\n< IGNORE_SCN := 0;\r\n---\r\n> IF (IGNORE_SCN = 0) THEN\r\n> DBMS_LOGREP_UTIL.DUMP_TRACE(\r\n> 'Warning: ignore_scn is 0 for object '||SCHEMA||'.'||NAME);\r\n> END IF;\r\n><\/pre>\n12.1.0.2<\/strong><\/h2>\n
SYS.DBMS_LOGREP_EXP – PACKAGE BODY (BP):<\/p>\n
2966a2967\r\n> \r\n2968a2970,2992\r\n> \r\n> \r\n> \r\n> \r\n> \r\n> \r\n> BEGIN\r\n> SELECT \/*+ USE_NL_WITH_INDEX(cd I_CDEF2) *\/ NVL(MAX(CO.SCN), 0) \r\n> INTO IGNORE_SCN\r\n> FROM SYS.DBA_CAPTURE_PREPARED_TABLES CO\r\n> WHERE CO.TABLE_OWNER = INSTANCE_EXTENDED_INFO_EXP.SCHEMA\r\n> AND CO.TABLE_NAME = INSTANCE_EXTENDED_INFO_EXP.NAME;\r\n> EXCEPTION\r\n> WHEN DBMS_STREAMS_DECL.TABLE_OR_VIEW_NOT_EXIST THEN\r\n> SELECT \/*+ USE_NL_WITH_INDEX(cd I_CDEF2) *\/ NVL(MAX(CO.SCN), 0) \r\n> INTO IGNORE_SCN\r\n> FROM SYS.ALL_CAPTURE_PREPARED_TABLES CO\r\n> WHERE CO.TABLE_OWNER = INSTANCE_EXTENDED_INFO_EXP.SCHEMA\r\n> AND CO.TABLE_NAME = INSTANCE_EXTENDED_INFO_EXP.NAME;\r\n> WHEN OTHERS THEN RAISE;\r\n> END;\r\n> \r\n> \r\n2970,2971c2994,2998\r\n< \r\n< IGNORE_SCN := 0;\r\n---\r\n> IF (IGNORE_SCN = 0) THEN\r\n> DBMS_LOGREP_UTIL.DUMP_TRACE(\r\n> 'Warning: ignore_scn is 0 for object '||SCHEMA||'.'||NAME);\r\n> END IF;\r\n><\/pre>\nSYS.DBMS_OPTIM_BUNDLE – PACKAGE BODY (BP):<\/p>\n
271a272\r\n> LOC_CON_ID NUMBER := CON_ID;\r\n280c281,283\r\n< \r\n---\r\n> IF CON_ID = 1 THEN\r\n> LOC_CON_ID := 0;\r\n> END IF;\r\n287c290\r\n< OPEN C1(INSTNAME, CON_ID); \r\n---\r\n> OPEN C1(INSTNAME, LOC_CON_ID); \r\n302c305\r\n< OPEN C1(INSTNAME_LOCAL, CON_ID); \r\n---\r\n> OPEN C1(INSTNAME_LOCAL, LOC_CON_ID); \r\n760a764\r\n> LOC_CON_ID NUMBER := CON_ID;\r\n765c769,771\r\n< \r\n---\r\n> IF CON_ID = 1 THEN\r\n> LOC_CON_ID := 0;\r\n> END IF;\r\n769c775\r\n< SQL_CMD := 'select count(*) from sys.gv$spparameter where NAME =''optimizer_features_enable'' and ISSPECIFIED = ''TRUE'' and con_id = ' || CON_ID;\r\n---\r\n> SQL_CMD := 'select count(*) from sys.gv$spparameter where NAME =''optimizer_features_enable'' and ISSPECIFIED = ''TRUE'' and con_id = ' || LOC_CON_ID;\r\n781c787\r\n< ' and SID != ''*'' and ISSPECIFIED = ''TRUE'' and con_id = ' || CON_ID;\r\n---\r\n> ' and SID != ''*'' and ISSPECIFIED = ''TRUE'' and con_id = ' || LOC_CON_ID;\r\n805c811\r\n< OPEN CUR_OFE(INSTNAME, CON_ID); \r\n---\r\n> OPEN CUR_OFE(INSTNAME, LOC_CON_ID); \r\n811c817\r\n< OPEN CUR_OFE('*', CON_ID); \r\n---\r\n> OPEN CUR_OFE('*', LOC_CON_ID); \r\n894,896c900,908\r\n< \r\n< \r\n< OPEN CUR_COUNT(CON_ID);\r\n---\r\n> IF CON_ID = 1 THEN\r\n> \r\n> \r\n> \r\n> OPEN CUR_COUNT(0);\r\n> ELSE\r\n> \r\n> OPEN CUR_COUNT(CON_ID);\r\n> END IF;<\/pre>\nSYS.PRVT_ILM – PACKAGE BODY (BP):<\/p>\n
214a215\r\n> V_TRACE_LEVEL NUMBER := ILM_DEBUG_NONE;\r\n216,219c217\r\n< \r\n< \r\n< \r\n< IF (ILM_DEBUG_LEVEL > ILM_DEBUG_NONE) THEN\r\n---\r\n> IF(ILM_DEBUG_LEVEL >= V_TRACE_LEVEL) THEN\r\n222c220\r\n< TRACE(ILM_DEBUG_LEVEL, 'Start rid End rid');\r\n---\r\n> TRACE(V_TRACE_LEVEL, 'Start rid End rid');\r\n224c222\r\n< TRACE(ILM_DEBUG_LEVEL, P_TAB_RID(I).START_RID\r\n---\r\n> TRACE(V_TRACE_LEVEL, P_TAB_RID(I).START_RID\r\n228,230c226,228\r\n< ELSE\r\n< TRACE(ILM_DEBUG_LEVEL, 'No rid ranges generated');\r\n< END IF;\r\n---\r\n> ELSE\r\n> TRACE(V_TRACE_LEVEL, 'No rid ranges generated');\r\n> END IF;\r\n234d231\r\n< \r\n3009,3010d3005\r\n< \r\n< || ' sys.prvt_ilm.setdebug();'<\/pre>\nSYS.CDBVIEW – PACKAGE BODY (PSU & BP):<\/p>\n
2,4d1\r\n< \r\n< function isLegalOwnerViewName(owner IN varchar2, oldview IN varchar2,\r\n< newview IN varchar2) return boolean;\r\n21,23d17\r\n< table_not_found EXCEPTION;\r\n< PRAGMA exception_init(table_not_found, -942);\r\n< \r\n40,43d33\r\n< if (not isLegalOwnerViewName(owner, oldview_name, newview_name)) then\r\n< RAISE table_not_found;\r\n< end if;\r\n< \r\n94,139d83\r\n< -- This function is created to prevent SQL injection. We couldn't use\r\n< -- dbms_assert because catcdbviews.sql is called before dbms_assert\r\n< -- is created\r\n< function isLegalOwnerViewName(owner IN varchar2, oldview IN varchar2,\r\n< newview IN varchar2) return boolean as\r\n< cCheck number;\r\n< cleanOldview varchar2(128);\r\n< cleanNewview varchar2(128);\r\n< begin\r\n< \r\n< -- Check if owner already exist\r\n< execute immediate 'SELECT COUNT(*) FROM USER$ WHERE NAME = :1'\r\n< into cCheck using upper(owner);\r\n< if (cCheck = 0) then\r\n< RETURN FALSE;\r\n< end if;\r\n< \r\n< -- Check if oldview already exist\r\n< execute immediate 'SELECT COUNT(*) FROM OBJ$ WHERE NAME = :1' ||\r\n< ' AND (TYPE# = 4 OR TYPE# = 2)'\r\n< into cCheck using upper(oldview);\r\n< if (cCheck = 0) then\r\n< RETURN FALSE;\r\n< end if;\r\n< \r\n< -- Check for appropriate newview name\r\n< -- The following is allowed for newview name\r\n< -- 1. Substitute 'DBA' with 'CDB'\r\n< -- 2. Substitute 'AWR_PDB' with 'CDB_HIST'\r\n< -- 3. Substitute 'ATTRIBUTES' with 'ATTRIB'\r\n< -- 4. Substitute 'DATABASE' with 'CDB'\r\n< -- 5. Remove 'REDUCED'\r\n< -- 6. Add 'AWRI$_CDB'\r\n< cleanOldview := REGEXP_REPLACE(upper(oldview),\r\n< 'DBA|DATABASE|_| |HIST|ATTRIB(UTE)?S?|CDB|AWR_PDB|REDUCED');\r\n< cleanNewview := REGEXP_REPLACE(upper(newview),\r\n< 'CDB|DATABASE|_| |HIST|ATTRIB(UTE)?S?|AWRI\\$');\r\n< \r\n< if (cleanOldview = cleanNewview) then\r\n< RETURN TRUE;\r\n< end if;\r\n< \r\n< RETURN FALSE;\r\n< \r\n< end isLegalOwnerViewName;\r\n<<\/pre>\n12.2.0.1<\/strong><\/h2>\n
SYS.PRVTEMX_CELL – PACKAGE BODY (JUL2017RUR):<\/p>\n
6915,6924c6915,6918\r\n< sum(\r\n< decode(\r\n< e.metric_id, \r\n< 361, e.metric_value - nvl(b.metric_value,0), \r\n< 0)) bytes,\r\n< sum(\r\n< decode(\r\n< e.metric_id, \r\n< 360, e.metric_value - nvl(b.metric_value,0),\r\n< 0)) rq,\r\n---\r\n> sum(decode(e.metric_id, \r\n> 361, e.metric_value, 0)) bytes,\r\n> sum(decode(e.metric_id, \r\n> 360, e.metric_value, 0)) rq,\r\n6926,6935c6920,6923\r\n< sum(\r\n< decode(\r\n< e.metric_id, \r\n< 361, e.metric_value - nvl(b.metric_value,0),\r\n< 0)) scrub_by,\r\n< sum(\r\n< decode(\r\n< e.metric_id, \r\n< 360, e.metric_value - nvl(b.metric_value,0), \r\n< 0)) scrub_rq\r\n---\r\n> sum(decode(e.metric_id, \r\n> 361, e.metric_value, 0)) scrub_by,\r\n> sum(decode(e.metric_id, \r\n> 360, e.metric_value, 0)) scrub_rq\r\n6945c6933\r\n< and e.metric_id between 360 and 361\r\n---\r\n> and e.metric_id between 360 and 362\r\n<\/pre>\nCTXSYS.DRVDDL – PACKAGE BODY (RU):<\/p>\n
3607d3606\r\n< STARTDOCID NUMBER := NULL;\r\n3709,3716d3707\r\n< \r\n< \r\n< IF (IDX.IDX_TYPE = DRIXMD.IDX_TYPE_CONTEXT2 AND\r\n< IXP.IXP_ID != 0) THEN\r\n< STARTDOCID := DRIXMD.GETNEXTID(IDX.IDX_ID, IXP.IXP_ID);\r\n< END IF;\r\n< \r\n< \r\n3736c3727\r\n< DRVDML.MAINTAINKTAB(IDX, IXP, STARTDOCID);\r\n---\r\n> DRVDML.MAINTAINKTAB(IDX, IXP);\r\n<\/pre>\nDVSYS.KU$_DV_REALM_MEMBER_T – TYPE (RU):<\/p>\n
5d4\r\n< oidval raw(16), \/* unique id *\/\r\n<\/pre>\nDVSYS.KU$_DV_RULE_SET_MEMBER_T – TYPE (RU):<\/p>\n
5d4\r\n< oidval raw(16), \/* unique id *\/\r\n<\/pre>\nDVSYS.SYS_YOID0000072649$ – TYPE (RU):<\/p>\n
1,2c1,3\r\n< type \"SYS_YOID0000072649$\" as object( \"SYS_NC00001$\" RAW(16\r\n< ))\r\n---\r\n> type \"SYS_YOID0000072649$\" as object( \"SYS_NC00001$\" VARCHA\r\n> R2(128 BYTE), \"SYS_NC00002$\" VARCHAR2(128 BYTE), \"SYS_NC00003$\" VARCHAR2(128 BYT\r\n> E))\r\n<\/pre>\nDVSYS.SYS_YOID0000072661$ – TYPE (RU):<\/p>\n
1,2c1,2\r\n< type \"SYS_YOID0000072661$\" as object( \"SYS_NC00001$\" RAW(16\r\n< ))\r\n---\r\n> type \"SYS_YOID0000072661$\" as object( \"SYS_NC00001$\" VARCHA\r\n> R2(128 BYTE), \"SYS_NC00002$\" VARCHAR2(128 BYTE))\r\n<\/pre>\nDVSYS.SYS_YOID0000072855$ – TYPE (RU):<\/p>\n
1,2c1,3\r\n< type \"SYS_YOID0000072855$\" as object( \"SYS_NC00001$\" RAW(16\r\n< ))\r\n---\r\n> type \"SYS_YOID0000072855$\" as object( \"SYS_NC00001$\" VARCHA\r\n> R2(128 BYTE), \"SYS_NC00002$\" VARCHAR2(128 BYTE), \"SYS_NC00003$\" VARCHAR2(128 BYT\r\n> E))\r\n<\/pre>\nDVSYS.SYS_YOID0000072867$ – TYPE (RU):<\/p>\n
1,2c1,2\r\n< type \"SYS_YOID0000072867$\" as object( \"SYS_NC00001$\" RAW(16\r\n< ))\r\n---\r\n> type \"SYS_YOID0000072867$\" as object( \"SYS_NC00001$\" VARCHA\r\n> R2(128 BYTE), \"SYS_NC00002$\" VARCHAR2(128 BYTE))\r\n<\/pre>\nDVSYS.KU$_DV_REALM_MEMBER_VIEW – VIEW (RU):<\/p>\n
1c1\r\n< select '0','0',sys_guid(),\r\n---\r\n> select '0','0',\r\n<\/pre>\nDVSYS.KU$_DV_RULE_SET_MEMBER_VIEW – VIEW (RU):<\/p>\n
1c1\r\n< select '0','0', sys_guid(),\r\n---\r\n> select '0','0',\r\n<\/pre>\nSYS.PRVT_COMPRESSION – PACKAGE (RU):<\/p>\n
3,4d2\r\n< \r\n< \r\n<\/pre>\nSYS.CDBVIEW – PACKAGE BODY (RU & JUL2017RUR & OCT2017RUR):<\/p>\n
2,4d1\r\n< \r\n< function isLegalOwnerViewName(owner IN varchar2, oldview IN varchar2,\r\n< newview IN varchar2) return boolean;\r\n25,27d21\r\n< table_not_found EXCEPTION;\r\n< PRAGMA exception_init(table_not_found, -942);\r\n< \r\n38,41d31\r\n< if (not isLegalOwnerViewName(owner, oldview_name, newview_name)) then\r\n< RAISE table_not_found;\r\n< end if;\r\n< \r\n158,203d147\r\n< -- This function is created to prevent SQL injection. We couldn't use\r\n< -- dbms_assert because catcdbviews.sql is called before dbms_assert\r\n< -- is created\r\n< function isLegalOwnerViewName(owner IN varchar2, oldview IN varchar2,\r\n< newview IN varchar2) return boolean as\r\n< cCheck number;\r\n< cleanOldview varchar2(128);\r\n< cleanNewview varchar2(128);\r\n< begin\r\n< \r\n< -- Check if owner already exist\r\n< execute immediate 'SELECT COUNT(*) FROM USER$ WHERE NAME = :1'\r\n< into cCheck using upper(owner);\r\n< if (cCheck = 0) then\r\n< RETURN FALSE;\r\n< end if;\r\n< \r\n< -- Check if oldview already exist\r\n< execute immediate 'SELECT COUNT(*) FROM OBJ$ WHERE NAME = :1' ||\r\n< ' AND (TYPE# = 4 OR TYPE# = 2)'\r\n< into cCheck using upper(oldview);\r\n< if (cCheck = 0) then\r\n< RETURN FALSE;\r\n< end if;\r\n< \r\n< -- Check for appropriate newview name\r\n< -- The following is allowed for newview name\r\n< -- 1. Substitute 'DBA' with 'CDB'\r\n< -- 2. Substitute 'AWR_PDB' with 'CDB_HIST'\r\n< -- 3. Substitute 'ATTRIBUTES' with 'ATTRIB'\r\n< -- 4. Substitute 'DATABASE' with 'CDB'\r\n< -- 5. Remove 'REDUCED'\r\n< -- 6. Add 'AWRI$_CDB'\r\n< cleanOldview := REGEXP_REPLACE(upper(oldview),\r\n< 'DBA|DATABASE|_| |HIST|ATTRIB(UTE)?S?|CDB|AWR_PDB|REDUCED');\r\n< cleanNewview := REGEXP_REPLACE(upper(newview),\r\n< 'CDB|DATABASE|_| |HIST|ATTRIB(UTE)?S?|AWRI\\$');\r\n< \r\n< if (cleanOldview = cleanNewview) then\r\n< RETURN TRUE;\r\n< end if;\r\n< \r\n< RETURN FALSE;\r\n< \r\n< end isLegalOwnerViewName;\r\n< \r\n<\/pre>\nSYS.DBMS_APPLY_ADM_INTERNAL – PACKAGE BODY (RU):<\/p>\n
2165c2165,2166\r\n< IF ( METHOD_NUM IN (XSDCH_METHOD_MAXIMUM, XSDCH_METHOD_MINIMUM,\r\n---\r\n> \r\n> IF ((METHOD_NUM IN (XSDCH_METHOD_MAXIMUM, XSDCH_METHOD_MINIMUM,\r\n2167,2168c2168,2171\r\n< XSDCH_METHOD_MIN_AND_EQUALS, XSDCH_METHOD_DELTA) AND\r\n< OPERATION_NUM NOT IN (XSDCH_OP_NUM_INSERT, XSDCH_OP_NUM_UPDATE)) THEN\r\n---\r\n> XSDCH_METHOD_MIN_AND_EQUALS) AND\r\n> OPERATION_NUM NOT IN (XSDCH_OP_NUM_INSERT, XSDCH_OP_NUM_UPDATE)) OR\r\n> (METHOD_NUM = XSDCH_METHOD_DELTA AND\r\n> OPERATION_NUM != XSDCH_OP_NUM_UPDATE)) THEN\r\n<\/pre>\nSYS.DBMS_AQADM_SYS – PACKAGE BODY (RU):<\/p>\n
2922,2933c2922\r\n< \r\n< \r\n< \r\n< \r\n< \r\n< \r\n< \r\n< \r\n< \r\n< \r\n< \r\n< TMP_STR := NLS_UPPER(LTRIM(RTRIM(SORT_TAB(I))), 'nls_sort=binary');\r\n---\r\n> TMP_STR := NLS_UPPER(LTRIM(RTRIM(SORT_TAB(I))));\r\n<\/pre>\nSYS.DBMS_COMPRESSION – PACKAGE BODY (RU):<\/p>\n
3,14d2\r\n< \r\n< \r\n< \r\n< KDZACMPLVL_MIN CONSTANT NUMBER := 0;\r\n< KDZACMPLVL_BASIC CONSTANT NUMBER := 0;\r\n< KDZACMPLVL_UNCMP CONSTANT NUMBER := 1;\r\n< KDZACMPLVL_ADVANCED CONSTANT NUMBER := 2;\r\n< KDZACMPLVL_HCCQL CONSTANT NUMBER := 3;\r\n< KDZACMPLVL_HCCQH CONSTANT NUMBER := 4;\r\n< KDZACMPLVL_HCCAL CONSTANT NUMBER := 5;\r\n< KDZACMPLVL_HCCAH CONSTANT NUMBER := 6;\r\n< \r\n362,363c350,351\r\n< \r\n< IF COMP_LEVEL = KDZACMPLVL_UNCMP THEN \r\n---\r\n> \r\n> IF COMP_LEVEL = 1 THEN \r\n365c353\r\n< ELSIF (COMP_LEVEL IN (KDZACMPLVL_BASIC, KDZACMPLVL_ADVANCED)) THEN\r\n---\r\n> ELSIF COMP_LEVEL = 2 THEN \r\n422,426c410\r\n< IF (COMP_LEVEL = KDZACMPLVL_BASIC) THEN \r\n< FOR_COMPRESSION :=COMP_BASIC; \r\n< ELSIF COMP_LEVEL = KDZACMPLVL_ADVANCED THEN\r\n< FOR_COMPRESSION := COMP_ADVANCED;\r\n< END IF; \r\n---\r\n> FOR_COMPRESSION :=COMP_BASIC; \r\n438c422\r\n< ELSIF COMP_LEVEL = KDZACMPLVL_HCCQL THEN\r\n---\r\n> ELSIF COMP_LEVEL = 3 THEN\r\n440c424\r\n< ELSIF COMP_LEVEL = KDZACMPLVL_HCCQH THEN\r\n---\r\n> ELSIF COMP_LEVEL = 4 THEN\r\n442c426\r\n< ELSIF COMP_LEVEL = KDZACMPLVL_HCCAL THEN\r\n---\r\n> ELSIF COMP_LEVEL = 5 THEN\r\n444c428\r\n< ELSIF COMP_LEVEL = KDZACMPLVL_HCCAH THEN\r\n---\r\n> ELSIF COMP_LEVEL = 6 THEN\r\n<\/pre>\nSYS.DBMS_LOGREP_EXP – PACKAGE BODY (RU):<\/p>\n
2993a2994,3018\r\n> \r\n> \r\n> \r\n> \r\n> \r\n> \r\n> \r\n> \r\n> \r\n> BEGIN\r\n> SELECT \/*+ USE_NL_WITH_INDEX(cd I_CDEF2) *\/ NVL(MAX(CO.SCN), 0) \r\n> INTO IGNORE_SCN\r\n> FROM SYS.DBA_CAPTURE_PREPARED_TABLES CO\r\n> WHERE CO.TABLE_OWNER = INSTANCE_EXTENDED_INFO_EXP.SCHEMA\r\n> AND CO.TABLE_NAME = INSTANCE_EXTENDED_INFO_EXP.NAME;\r\n> EXCEPTION\r\n> WHEN DBMS_STREAMS_DECL.TABLE_OR_VIEW_NOT_EXIST THEN\r\n> SELECT \/*+ USE_NL_WITH_INDEX(cd I_CDEF2) *\/ NVL(MAX(CO.SCN), 0) \r\n> INTO IGNORE_SCN\r\n> FROM SYS.ALL_CAPTURE_PREPARED_TABLES CO\r\n> WHERE CO.TABLE_OWNER = INSTANCE_EXTENDED_INFO_EXP.SCHEMA\r\n> AND CO.TABLE_NAME = INSTANCE_EXTENDED_INFO_EXP.NAME;\r\n> WHEN OTHERS THEN RAISE;\r\n> END;\r\n> \r\n2996,2997c3021,3025\r\n< \r\n< IGNORE_SCN := 0;\r\n---\r\n> IF (IGNORE_SCN = 0) THEN\r\n> DBMS_LOGREP_UTIL.DUMP_TRACE(\r\n> 'Warning: ignore_scn is 0 for object '||SCHEMA||'.'||NAME);\r\n> END IF;\r\n> \r\n<\/pre>\nSYS.DBMS_OPTIM_BUNDLE – PACKAGE BODY (RU):<\/p>\n
279a280\r\n> LOC_CON_ID NUMBER := CON_ID;\r\n288c289,291\r\n< \r\n---\r\n> IF CON_ID = 1 THEN\r\n> LOC_CON_ID := 0;\r\n> END IF;\r\n295c298\r\n< OPEN C1(INSTNAME, CON_ID); \r\n---\r\n> OPEN C1(INSTNAME, LOC_CON_ID); \r\n310c313\r\n< OPEN C1(INSTNAME_LOCAL, CON_ID); \r\n---\r\n> OPEN C1(INSTNAME_LOCAL, LOC_CON_ID); \r\n769a773\r\n> LOC_CON_ID NUMBER := CON_ID;\r\n774c778,780\r\n< \r\n---\r\n> IF CON_ID = 1 THEN\r\n> LOC_CON_ID := 0;\r\n> END IF;\r\n778c784\r\n< SQL_CMD := 'select count(*) from sys.gv$spparameter where NAME =''optimizer_features_enable'' and ISSPECIFIED = ''TRUE'' and con_id = ' || CON_ID;\r\n---\r\n> SQL_CMD := 'select count(*) from sys.gv$spparameter where NAME =''optimizer_features_enable'' and ISSPECIFIED = ''TRUE'' and con_id = ' || LOC_CON_ID;\r\n790c796\r\n< ' and SID != ''*'' and ISSPECIFIED = ''TRUE'' and con_id = ' || CON_ID;\r\n---\r\n> ' and SID != ''*'' and ISSPECIFIED = ''TRUE'' and con_id = ' || LOC_CON_ID;\r\n814c820\r\n< OPEN CUR_OFE(INSTNAME, CON_ID); \r\n---\r\n> OPEN CUR_OFE(INSTNAME, LOC_CON_ID); \r\n820c826\r\n< OPEN CUR_OFE('*', CON_ID); \r\n---\r\n> OPEN CUR_OFE('*', LOC_CON_ID); \r\n903,905c909,917\r\n< \r\n< \r\n< OPEN CUR_COUNT(CON_ID);\r\n---\r\n> IF CON_ID = 1 THEN\r\n> \r\n> \r\n> \r\n> OPEN CUR_COUNT(0);\r\n> ELSE\r\n> \r\n> OPEN CUR_COUNT(CON_ID);\r\n> END IF;\r\n<\/pre>\nSYS.DBMS_PRVTAQIM – PACKAGE BODY (RU):<\/p>\n
1714,1725c1714\r\n< \r\n< \r\n< \r\n< \r\n< \r\n< \r\n< \r\n< \r\n< \r\n< \r\n< \r\n< TMP_STR := NLS_UPPER(LTRIM(RTRIM(SORT_TAB(I))), 'nls_sort=binary');\r\n---\r\n> TMP_STR := NLS_UPPER(LTRIM(RTRIM(SORT_TAB(I))));\r\n<\/pre>\nSYS.DBMS_RCVMAN – PACKAGE BODY (RU):<\/p>\n
17221,17229c17221,17237\r\n< SELECT COUNT(*) INTO LOGEXISTS FROM DUAL\r\n< WHERE EXISTS\r\n< (SELECT 1 FROM V$ARCHIVED_LOG\r\n< WHERE RESETLOGS_TIME = LAST_RESETTIM\r\n< AND RESETLOGS_CHANGE# = LAST_RESETNUM\r\n< AND ARCHIVED = 'YES' \r\n< AND THREAD# = LAST_TRD\r\n< AND SEQUENCE# = LAST_SEQ+1);\r\n< IF LOGEXISTS > 0 THEN\r\n---\r\n> IF LOG.SEQ = 1 THEN\r\n> LOGEXISTS := 0;\r\n> \r\n> SELECT COUNT(*) INTO LOGEXISTS FROM DUAL\r\n> WHERE EXISTS\r\n> (SELECT 1 FROM V$ARCHIVED_LOG \r\n> WHERE RESETLOGS_TIME = LAST_RESETTIM\r\n> AND RESETLOGS_CHANGE# = LAST_RESETNUM\r\n> AND THREAD# = LAST_TRD\r\n> AND SEQUENCE# = LAST_SEQ+1);\r\n> IF LOGEXISTS > 0\r\n> THEN\r\n> \r\n> POSSIBLE_GAP := LAST_SCN;\r\n> POSSIBLE_GAP_RLGSCN := LAST_RESETNUM;\r\n> END IF;\r\n> ELSE\r\n<\/pre>\nSYS.PRVTEMX_CELL – PACKAGE BODY (RU & OCT2017RUR):<\/p>\n
7102,7111c7102,7105\r\n< sum(\r\n< decode(\r\n< e.metric_id, \r\n< 361, e.metric_value - nvl(b.metric_value,0), \r\n< 0)) bytes,\r\n< sum(\r\n< decode(\r\n< e.metric_id, \r\n< 360, e.metric_value - nvl(b.metric_value,0),\r\n< 0)) rq,\r\n---\r\n> sum(decode(e.metric_id, \r\n> 361, e.metric_value, 0)) bytes,\r\n> sum(decode(e.metric_id, \r\n> 360, e.metric_value, 0)) rq,\r\n7113,7122c7107,7110\r\n< sum(\r\n< decode(\r\n< e.metric_id, \r\n< 361, e.metric_value - nvl(b.metric_value,0),\r\n< 0)) scrub_by,\r\n< sum(\r\n< decode(\r\n< e.metric_id, \r\n< 360, e.metric_value - nvl(b.metric_value,0), \r\n< 0)) scrub_rq\r\n---\r\n> sum(decode(e.metric_id, \r\n> 361, e.metric_value, 0)) scrub_by,\r\n> sum(decode(e.metric_id, \r\n> 360, e.metric_value, 0)) scrub_rq\r\n7132c7120\r\n< and e.metric_id between 360 and 361\r\n---\r\n> and e.metric_id between 360 and 362\r\n<\/pre>\nSYS.PRVT_ILM – PACKAGE BODY (RU):<\/p>\n
229a230\r\n> V_TRACE_LEVEL NUMBER := ILM_DEBUG_NONE;\r\n231,233c232\r\n< \r\n< \r\n< IF(ILM_DEBUG_LEVEL > ILM_DEBUG_NONE) THEN\r\n---\r\n> IF(ILM_DEBUG_LEVEL >= V_TRACE_LEVEL) THEN\r\n236c235\r\n< TRACE(ILM_DEBUG_LEVEL, 'Start rid End rid');\r\n---\r\n> TRACE(V_TRACE_LEVEL, 'Start rid End rid');\r\n239c238\r\n< TRACE(ILM_DEBUG_LEVEL, P_TAB_RID(I).START_RID\r\n---\r\n> TRACE(V_TRACE_LEVEL, P_TAB_RID(I).START_RID\r\n241a241\r\n> \r\n243c243\r\n< TRACE(ILM_DEBUG_LEVEL, 'No rid ranges generated');\r\n---\r\n> TRACE(V_TRACE_LEVEL, 'No rid ranges generated');\r\n244a245\r\n> \r\n3703,3704d3703\r\n< \r\n< || ' sys.prvt_ilm.setdebug();'\r\n<\/pre>\nSYS.LOGSTDBY_RU_UNSUPPORT_TAB_12_1 – VIEW (RU):<\/p>\n
92c92\r\n< where sk.action in (-5, -11)\r\n---\r\n> where sk.action=-5\r\n184c184,185\r\n< where t.obj# = c2.obj#\r\n---\r\n> where bitand(c2.property, 32) = 32 \/* Hidden *\/\r\n> and t.obj# = c2.obj#\r\n212c213\r\n< where sk.action in (-5, -11)\r\n---\r\n> where sk.action=-5\r\n269c270\r\n< where sk.action in (-5, -11)\r\n---\r\n> where sk.action=-5\r\n<\/pre>\nSYS.LOGSTDBY_RU_UNSUPPORT_TAB_12_2 – VIEW (RU):<\/p>\n
80,92c80,81\r\n< , 4) = 4) or (c1.type# = 111 and bitand(c1.property, 8) = 8) or (c1.type# in (58\r\n< , 121, 123) and\r\n< (exists\r\n< (select 1 from obj$ o3, coltype$ ct3, user$ u3\r\n< where u3.user# = o3.owner#\r\n< and c1.obj# = ct3.obj#\r\n< and c1.intcol# = ct3.intcol#\r\n< and ct3.toid = o3.oid$\r\n< and exists (select 1 from system.logstdby$skip_support sk\r\n< where sk.action=-11\r\n< and sk.name = u3.name \/* type owner *\/\r\n< and sk.name2 = o3.name \/* type name *\/)))))))))) \/* T\r\n< able has a Temporal Validity column *\/\r\n---\r\n> , 4) = 4) or (c1.type# = 111 and bitand(c1.property, 8) = 8))))))) \/* Table has\r\n> a Temporal Validity column *\/\r\n170c159,160\r\n< where t.obj# = c2.obj#\r\n---\r\n> where bitand(c2.property, 32) = 32 \/* Hidden *\/\r\n> and t.obj# = c2.obj#\r\n184,195c174,176\r\n< (c2.type# = 111 and bitand(c2.property, 8) = 8) or (c2.type# in\r\n< (58, 121, 123) and\r\n< (exists\r\n< (select 1 from obj$ o3, coltype$ ct3, user$ u3\r\n< where u3.user# = o3.owner#\r\n< and c2.obj# = ct3.obj#\r\n< and c2.intcol# = ct3.intcol#\r\n< and ct3.toid = o3.oid$\r\n< and exists (select 1 from system.logstdby$skip_support sk\r\n< where sk.action=-11\r\n< and sk.name = u3.name \/* type owner *\/\r\n< and sk.name2 = o3.name \/* type name *\/)))))))) or\r\n---\r\n> (c2.type# = 111 and bitand(c2.property, 8) = 8)\r\n> \/* REF *\/\r\n> )))) or\r\n<\/pre>\nSYS.LOGSTDBY_SUPPORT_TAB_12_1 – VIEW (RU):<\/p>\n
85c85\r\n< where sk.action in (-5, -11)\r\n---\r\n> where sk.action=-5\r\n195c195,196\r\n< where t.obj# = c2.obj#\r\n---\r\n> where bitand(c2.property, 32) = 32 \/* Hidden *\/\r\n> and t.obj# = c2.obj#\r\n223c224\r\n< where sk.action in (-5, -11)\r\n---\r\n> where sk.action=-5\r\n285c286\r\n< where sk.action in (-5, -11)\r\n---\r\n> where sk.action=-5\r\n<\/pre>\nSYS.LOGSTDBY_SUPPORT_TAB_12_2 – VIEW (RU):<\/p>\n
87,97c87\r\n< = 'FALSE')) or (c1.type# in (58, 121, 123) and\r\n< (exists\r\n< (select 1 from obj$ o3, coltype$ ct3, user$ u3\r\n< where u3.user# = o3.owner#\r\n< and c1.obj# = ct3.obj#\r\n< and c1.intcol# = ct3.intcol#\r\n< and ct3.toid = o3.oid$\r\n< and exists (select 1 from system.logstdby$skip_support sk\r\n< where sk.action=-11\r\n< and sk.name = u3.name \/* type owner *\/\r\n< and sk.name2 = o3.name \/* type name *\/))))))))))\r\n---\r\n> = 'FALSE'))))))))\r\n201c191,192\r\n< where t.obj# = c2.obj#\r\n---\r\n> where bitand(c2.property, 32) = 32 \/* Hidden *\/\r\n> and t.obj# = c2.obj#\r\n227,237c218,219\r\n< = 'FALSE')) or (c2.type# in (58, 121, 123) and\r\n< (exists\r\n< (select 1 from obj$ o3, coltype$ ct3, user$ u3\r\n< where u3.user# = o3.owner#\r\n< and c2.obj# = ct3.obj#\r\n< and c2.intcol# = ct3.intcol#\r\n< and ct3.toid = o3.oid$\r\n< and exists (select 1 from system.logstdby$skip_support sk\r\n< where sk.action=-11\r\n< and sk.name = u3.name \/* type owner *\/\r\n< and sk.name2 = o3.name \/* type name *\/)))))))) or\r\n---\r\n> = 'FALSE')) \/* REF *\/\r\n> )))) or\r\n<\/pre>\nSYS.LOGSTDBY_UNSUPPORT_TAB_12_1 – VIEW (RU):<\/p>\n
92c92\r\n< where sk.action in (-5, -11)\r\n---\r\n> where sk.action=-5\r\n187c187,188\r\n< where t.obj# = c2.obj#\r\n---\r\n> where bitand(c2.property, 32) = 32 \/* Hidden *\/\r\n> and t.obj# = c2.obj#\r\n215c216\r\n< where sk.action in (-5, -11)\r\n---\r\n> where sk.action=-5\r\n272c273\r\n< where sk.action in (-5, -11)\r\n---\r\n> where sk.action=-5\r\n<\/pre>\nSYS.LOGSTDBY_UNSUPPORT_TAB_12_2 – VIEW (RU):<\/p>\n
96,107c96,97\r\n< = 'FALSE')) or (c1.type# in (58, 121, 123) and\r\n< (exists\r\n< (select 1 from obj$ o3, coltype$ ct3, user$ u3\r\n< where u3.user# = o3.owner#\r\n< and c1.obj# = ct3.obj#\r\n< and c1.intcol# = ct3.intcol#\r\n< and ct3.toid = o3.oid$\r\n< and exists (select 1 from system.logstdby$skip_support sk\r\n< where sk.action=-11\r\n< and sk.name = u3.name \/* type owner *\/\r\n< and sk.name2 = o3.name \/* type name *\/)))))))))) \/* 0\r\n< x00020000 table is used as an AQ queue table *\/\r\n---\r\n> = 'FALSE')))))))) \/* 0x00020000 table is used as an AQ queue table\r\n> *\/\r\n197c187,188\r\n< where t.obj# = c2.obj#\r\n---\r\n> where bitand(c2.property, 32) = 32 \/* Hidden *\/\r\n> and t.obj# = c2.obj#\r\n223,233c214,215\r\n< = 'FALSE')) or (c2.type# in (58, 121, 123) and\r\n< (exists\r\n< (select 1 from obj$ o3, coltype$ ct3, user$ u3\r\n< where u3.user# = o3.owner#\r\n< and c2.obj# = ct3.obj#\r\n< and c2.intcol# = ct3.intcol#\r\n< and ct3.toid = o3.oid$\r\n< and exists (select 1 from system.logstdby$skip_support sk\r\n< where sk.action=-11\r\n< and sk.name = u3.name \/* type owner *\/\r\n< and sk.name2 = o3.name \/* type name *\/)))))))) or\r\n---\r\n> = 'FALSE')) \/* REF *\/\r\n> )))) or\r\n<\/pre>\nSYS.OGG_SUPPORT_TAB_11_2 – VIEW (RU):<\/p>\n
40,57d39\r\n< \/* ADT typed table with BFILE attribute *\/\r\n< and ((bitand(t.property, 1) = 1 and\r\n< c.type# = 114 \/* BFILE *\/ and\r\n< exists(select 1\r\n< from sys.col$ c1\r\n< where c1.obj#=t.obj# and\r\n< c1.name = 'SYS_NC_ROWINFO$' and\r\n< c1.type# = 121))\r\n< \/* Relational table with ADT column having BFILE attribute *\/\r\n< or (bitand(t.property, 1) = 0 and\r\n< c.type# = 114 \/* BFILE *\/ and\r\n< bitand(c.property, 32) = 32 \/* hidden *\/ and\r\n< exists (select 1\r\n< from sys.col$ c1\r\n< where c1.obj#=t.obj# and\r\n< c1.col# = c.col# and\r\n< bitand(c1.property, 32) = 0 \/* not hidden *\/ and\r\n< c1.type# = 121))\r\n59c41\r\n< or ((c.type# in (8,24,58,112,113,114,115,121,123)\r\n---\r\n> and ((c.type# in (8,24,58,112,113,114,115,121,123)\r\n61,80c43,61\r\n< and (bitand(t.property, 1) = 0 \/* not a typed table or *\/\r\n< and 0 = (select count(*) from sys.col$ c2\r\n< where t.obj# = c2.obj#\r\n< and bitand(c2.property, 32) != 32 \/* Not hidden *\/\r\n< and bitand(c2.property, 8) != 8 \/* Not virtual *\/\r\n< and bitand(c2.property, 128) != 128 \/* not stored in lob *\/\r\n< and (c2.type# in ( 1, \/* VARCHAR2 *\/\r\n< 2, \/* NUMBER *\/\r\n< 12, \/* DATE *\/\r\n< 23, \/* RAW *\/\r\n< 96, \/* CHAR *\/\r\n< 100, \/* BINARY FLOAT *\/\r\n< 101, \/* BINARY DOUBLE *\/\r\n< 180, \/* TIMESTAMP (..) *\/\r\n< 181, \/* TIMESTAMP(..) WITH TIME ZONE *\/\r\n< 182, \/* INTERVAL YEAR(..) TO MONTH *\/\r\n< 183, \/* INTERVAL DAY(..) TO SECOND(..) *\/\r\n< 208, \/* UROWID *\/\r\n< 231) \/* TIMESTAMP(..) WITH LOCAL TZ *\/\r\n< ))))))\r\n---\r\n> and (bitand(t.property, 1) = 0 \/* not a typed table or *\/\r\n> and 0 = (select count(*) from sys.col$ c2\r\n> where t.obj# = c2.obj#\r\n> and bitand(c2.property, 32) != 32 \/* Not hidden *\/\r\n> and bitand(c2.property, 8) != 8 \/* Not virtual *\/\r\n> and bitand(c2.property, 128) != 128 \/* not stored in lob *\/\r\n> and (c2.type# in ( 1, \/* VARCHAR2 *\/\r\n> 2, \/* NUMBER *\/\r\n> 12, \/* DATE *\/\r\n> 23, \/* RAW *\/\r\n> 96, \/* CHAR *\/\r\n> 100, \/* BINARY FLOAT *\/\r\n> 101, \/* BINARY DOUBLE *\/\r\n> 180, \/* TIMESTAMP (..) *\/\r\n> 181, \/* TIMESTAMP(..) WITH TIME ZONE *\/\r\n> 182, \/* INTERVAL YEAR(..) TO MONTH *\/\r\n> 183, \/* INTERVAL DAY(..) TO SECOND(..) *\/\r\n> 231) \/* TIMESTAMP(..) WITH LOCAL TIME ZONE *\/\r\n> )))))\r\n128d108\r\n< 208, \/* UROWID *\/\r\n<\/pre>\nSYS.OGG_SUPPORT_TAB_11_2B – VIEW (RU):<\/p>\n
41,58d40\r\n< \/* ADT typed table with BFILE attribute *\/\r\n< and ((bitand(t.property, 1) = 1 and\r\n< c.type# = 114 \/* BFILE *\/ and\r\n< exists(select 1\r\n< from sys.col$ c1\r\n< where c1.obj#=t.obj# and\r\n< c1.name = 'SYS_NC_ROWINFO$' and\r\n< c1.type# = 121))\r\n< \/* Relational table with ADT column having BFILE attribute *\/\r\n< or (bitand(t.property, 1) = 0 and\r\n< c.type# = 114 \/* BFILE *\/ and\r\n< bitand(c.property, 32) = 32 \/* hidden *\/ and\r\n< exists (select 1\r\n< from sys.col$ c1\r\n< where c1.obj#=t.obj# and\r\n< c1.col# = c.col# and\r\n< bitand(c1.property, 32) = 0 \/* not hidden *\/ and\r\n< c1.type# = 121))\r\n60c42\r\n< or ((c.type# in (8,24,58,112,113,114,115,121,123)\r\n---\r\n> and ((c.type# in (8,24,58,112,113,114,115,121,123)\r\n62,81c44,62\r\n< and (bitand(t.property, 1) = 0 \/* not a typed table or *\/\r\n< and 0 = (select count(*) from sys.col$ c2\r\n< where t.obj# = c2.obj#\r\n< and bitand(c2.property, 32) != 32 \/* Not hidden *\/\r\n< and bitand(c2.property, 8) != 8 \/* Not virtual *\/\r\n< and bitand(c2.property, 128) != 128 \/* not stored in lob *\/\r\n< and (c2.type# in ( 1, \/* VARCHAR2 *\/\r\n< 2, \/* NUMBER *\/\r\n< 12, \/* DATE *\/\r\n< 23, \/* RAW *\/\r\n< 96, \/* CHAR *\/\r\n< 100, \/* BINARY FLOAT *\/\r\n< 101, \/* BINARY DOUBLE *\/\r\n< 180, \/* TIMESTAMP (..) *\/\r\n< 181, \/* TIMESTAMP(..) WITH TIME ZONE *\/\r\n< 182, \/* INTERVAL YEAR(..) TO MONTH *\/\r\n< 183, \/* INTERVAL DAY(..) TO SECOND(..) *\/\r\n< 208, \/* UROWID *\/\r\n< 231) \/* TIMESTAMP(..) WITH LOCAL TZ *\/\r\n< ))))))\r\n---\r\n> and (bitand(t.property, 1) = 0 \/* not a typed table or *\/\r\n> and 0 = (select count(*) from sys.col$ c2\r\n> where t.obj# = c2.obj#\r\n> and bitand(c2.property, 32) != 32 \/* Not hidden *\/\r\n> and bitand(c2.property, 8) != 8 \/* Not virtual *\/\r\n> and bitand(c2.property, 128) != 128 \/* not stored in lob *\/\r\n> and (c2.type# in ( 1, \/* VARCHAR2 *\/\r\n> 2, \/* NUMBER *\/\r\n> 12, \/* DATE *\/\r\n> 23, \/* RAW *\/\r\n> 96, \/* CHAR *\/\r\n> 100, \/* BINARY FLOAT *\/\r\n> 101, \/* BINARY DOUBLE *\/\r\n> 180, \/* TIMESTAMP (..) *\/\r\n> 181, \/* TIMESTAMP(..) WITH TIME ZONE *\/\r\n> 182, \/* INTERVAL YEAR(..) TO MONTH *\/\r\n> 183, \/* INTERVAL DAY(..) TO SECOND(..) *\/\r\n> 231) \/* TIMESTAMP(..) WITH LOCAL TIME ZONE *\/\r\n> )))))\r\n124d104\r\n< 208, \/* UROWID *\/\r\n<\/pre>\nSYS.OGG_SUPPORT_TAB_12_1 – VIEW (RU):<\/p>\n
66,96d65\r\n< \/* ADT typed table with BFILE attribute *\/\r\n< or (bitand(t.property, 1) = 1 and\r\n< c.type# = 114 \/* BFILE *\/ and\r\n< exists(select 1\r\n< from sys.col$ c1\r\n< where c1.obj# = t.obj# and\r\n< c1.name = 'SYS_NC_ROWINFO$' and\r\n< c1.type# = 121))\r\n< \/* Relational table with ADT column having BFILE attribute *\/\r\n< or (bitand(t.property, 1) = 0 and\r\n< c.type# = 114 \/* BFILE *\/ and\r\n< bitand(c.property, 32)=32 \/* hidden *\/ and\r\n< exists (select 1\r\n< from sys.col$ c1\r\n< where c1.obj# = t.obj# and\r\n< c1.col# = c.col# and\r\n< bitand(c1.property, 32) = 0 \/* not hidden *\/ and\r\n< c1.type# = 121))\r\n< \/* Any table (relational or typed) that has an unsupported *\/\r\n< \/* built-in ADT *\/\r\n< or (c.type# in (58, 121, 123) and\r\n< (exists\r\n< (select 1 from obj$ o3, coltype$ ct3, user$ u3\r\n< where u3.user# = o3.owner#\r\n< and c.obj# = ct3.obj#\r\n< and c.intcol# = ct3.intcol#\r\n< and ct3.toid = o3.oid$\r\n< and exists (select 1 from system.logstdby$skip_support sk\r\n< where sk.action in (-11)\r\n< and sk.name = u3.name \/* type owner *\/\r\n< and sk.name2 = o3.name \/* type name *\/))))\r\n117d85\r\n< 208, \/* UROWID *\/\r\n162c130\r\n< where sk.action in (-5, -11)\r\n---\r\n> where sk.action=-5\r\n201d168\r\n< 208, \/* UROWID *\/\r\n223c190,191\r\n< where t.obj# = c2.obj#\r\n---\r\n> where bitand(c2.property, 32) = 32 \/* Hidden *\/\r\n> and t.obj# = c2.obj#\r\n251c219\r\n< where sk.action in (-5, -11)\r\n---\r\n> where sk.action=-5\r\n289c257\r\n< where sk.action in (-5, -11)\r\n---\r\n> where sk.action=-5\r\n<\/pre>\nSYS.OGG_SUPPORT_TAB_12_2 – VIEW (RU):<\/p>\n
67,97d66\r\n< \/* ADT typed table with BFILE attribute *\/\r\n< or (bitand(t.property, 1) = 1 and\r\n< c.type# = 114 \/* BFILE *\/ and\r\n< exists(select 1\r\n< from sys.col$ c1\r\n< where c1.obj#=t.obj# and\r\n< c1.name = 'SYS_NC_ROWINFO$' and\r\n< c1.type# = 121))\r\n< \/* Relational table with ADT column having BFILE attribute *\/\r\n< or (bitand(t.property, 1) = 0 and\r\n< c.type# = 114 \/* BFILE *\/ and\r\n< bitand(c.property, 32) = 32 \/* hidden *\/ and\r\n< exists (select 1\r\n< from sys.col$ c1\r\n< where c1.obj#=t.obj# and\r\n< c1.col# = c.col# and\r\n< bitand(c1.property, 32) = 0 \/* not hidden *\/ and\r\n< c1.type# = 121))\r\n< \/* Any table (relational or typed) that has an unsupported *\/\r\n< \/* built-in ADT *\/\r\n< or (c.type# in (58, 121, 123) and\r\n< (exists\r\n< (select 1 from obj$ o3, coltype$ ct3, user$ u3\r\n< where u3.user# = o3.owner#\r\n< and c.obj# = ct3.obj#\r\n< and c.intcol# = ct3.intcol#\r\n< and ct3.toid = o3.oid$\r\n< and exists (select 1 from system.logstdby$skip_support sk\r\n< where sk.action=-11\r\n< and sk.name = u3.name \/* type owner *\/\r\n< and sk.name2 = o3.name \/* type name *\/))))\r\n118d86\r\n< 208, \/* UROWID *\/\r\n177d144\r\n< 208, \/* UROWID *\/\r\n195c162,163\r\n< where t.obj# = c2.obj#\r\n---\r\n> where bitand(c2.property, 32) = 32 \/* Hidden *\/\r\n> and t.obj# = c2.obj#\r\n209c177,179\r\n< (c2.type# = 111 and bitand(c2.property, 8) = 8))))) or\r\n---\r\n> (c2.type# = 111 and bitand(c2.property, 8) = 8)\r\n> \/* REF *\/\r\n> )))) or<\/pre>\n
\nUseful Links:<\/p>\n