[Database] Package Differences between Oracle 11.2.0.4 and 12.1.0.2?

原文はこちら。
https://blogs.oracle.com/UPGRADE/entry/package_differences_between_oracle_11

この質問はかなり簡単そうに思えます。
Which packages did exist in Oracle 11.2.0.4 but don't exist in Oracle 12.1.0.2 anymore?
(どのパッケージがOracle Database 11.2.0.4にあって、Oracle Database 12.1.0.2からはなくなっているの?)
もうちょっとこの質問を深掘りしてみましょう。
Which procedures and functions calls of SYS packages have been changed since then?
(どのSYSパッケージのプロシージャやファンクションが変更されたの?)
ある同僚が(ACS SupportのThomas Kempkensがすてきなプロシージャを書いてくれました。すべては彼のおかげです。)顧客からこんな質問を受けて、情報を探し出す必要がありました。

その結果をみてみましょう。

以下のパッケージはOracle Database 12.1.0.2には含まれませんが、Oracle Database 11.2.0.4には含まれています。17個のパッケージがなくなっていることがわかります。
CWM2_OLAP_INSTALLER
DBMS_AMD
DBMS_APPCTX
DBMS_DBLINK
DBMS_DM_IMP_INTERNAL
DBMS_DM_UTIL_INTERNAL
DBMS_DUMA_INTERNAL
DBMS_JDM_INTERNAL
DBMS_RULE_COMPATIBLE_90
DBMS_SQL2
DBMS_XDSUTL
DBMS_XS_SECCLASS_INT
DBMS_XS_SECCLASS_INT_FFI
EXF$DBMS_EXPFIL_SYSPACK
HTMLDB_SYSTEM
ODM_ABN_MODEL
SQLJUTL2
続いて、Oracle SYSパッケージの中のプロシージャやファンクションコールのうち、Oracle Database 12.1.0.2で変更があったものです。204個のプロシージャやファンクションが変わっていました。
PACKAGE_NAMESUBTYPESUBTYPE NAME
CWM2_OLAP_INSTALLER PROCEDUREVALIDATE_CWM2_INSTALL
DBMS_AMD PROCEDUREMOVE_OLAP_CATALOG
DBMS_APPCTX PROCEDURECLEAR_CONTEXT
DBMS_APPCTX PROCEDURESET_CONTEXT
DBMS_AQADM_SYS PROCEDUREGET_CORR_MSG
DBMS_AQADM_SYS PROCEDURERESET_CORR_MSG
DBMS_AQADM_SYSCALLS PROCEDUREKWQA_3GL_UPDPERSTATS
DBMS_DATA_MINING FUNCTIONGET_MODEL_DETAILS_ABN RETURNS DM_ABN_DETAILS
DBMS_DATA_MINING_INTERNALPROCEDURECREATE_TEMP_META_TABLE
DBMS_DBLINK PROCEDUREUPGRADE
DBMS_DDL_INTERNAL FUNCTIONGEN_NEW_OBJECT_ID RETURNS BINARY_INTEGER
DBMS_DM_EXP_INTERNAL FUNCTIONGET_TRACE RETURNS BOOLEAN
DBMS_DM_EXP_INTERNAL PROCEDUREDELETE_FROM_TEMP
DBMS_DM_EXP_INTERNAL PROCEDUREDO_TEMP_TABLE
DBMS_DM_EXP_INTERNAL PROCEDUREDUMP_STATUS
DBMS_DM_EXP_INTERNAL PROCEDUREGET_LIST_MODELS
DBMS_DM_EXP_INTERNAL PROCEDUREINSERT_LIST_MODELS
DBMS_DM_EXP_INTERNAL PROCEDURESET_TRACE
DBMS_DM_IMP_INTERNAL PROCEDUREREGISTER_TEMP_TABLE
DBMS_DM_IMP_INTERNAL PROCEDUREUNREGIST_TEMP_TABLE
DBMS_DM_MODEL_EXP FUNCTIONINSTANCE_INFO_EXP RETURNS VARCHAR2
DBMS_DM_MODEL_EXP FUNCTIONSCHEMA_INFO_EXP RETURNS VARCHAR2
DBMS_DM_MODEL_EXP PROCEDURESCHEMA_CALLOUT
DBMS_DM_UTIL PROCEDUREDISPLAY_MSG
DBMS_DM_UTIL PROCEDUREDUMP_MSG
DBMS_DM_UTIL_INTERNAL PROCEDUREDUMP_DM_TRACE
DBMS_DUMA_INTERNAL FUNCTIONGET_PROPERTY RETURNS NUMBER
DBMS_DUMA_INTERNAL FUNCTIONREAD_LONG_TO_BLOB RETURNS BLOB
DBMS_DUMA_INTERNAL PROCEDURECONVERT_LONG
DBMS_DUMA_INTERNAL PROCEDURESCAN_TABLE
DBMS_DUMA_INTERNAL PROCEDUREWRITE_BLOB_TO_LONG
DBMS_INTERNAL_LOGSTDBY PROCEDUREEDS_EVOLVE_TABLE_1_FINISH
DBMS_INTERNAL_LOGSTDBY PROCEDUREEND_INSTANTIATION
DBMS_INTERNAL_LOGSTDBY PROCEDUREINSTANTIATE_FEATURE
DBMS_INTERNAL_LOGSTDBY PROCEDURELOCK_TABLES
DBMS_INTERNAL_LOGSTDBY PROCEDUREPREPARE_INSTANTIATION
DBMS_INTERNAL_LOGSTDBY PROCEDUREREGISTER_SCHEMA
DBMS_INTERNAL_LOGSTDBY PROCEDUREUNSUPPORTED_DML
DBMS_JAVA FUNCTIONDEPLOY_INVOKE RETURNS VARCHAR2
DBMS_JAVA FUNCTIONDROP_JAR RETURNS NUMBER
DBMS_JAVA FUNCTIONFINISH_LOADING_JAR RETURNS NUMBER
DBMS_JAVA FUNCTIONGETSOURCECHUNK RETURNS VARCHAR2
DBMS_JAVA FUNCTIONHANDLEMD5 RETURNS RAW
DBMS_JAVA FUNCTIONINITGETSOURCECHUNKS RETURNS NUMBER
DBMS_JAVA FUNCTIONJAR_STATUS RETURNS NUMBER
DBMS_JAVA FUNCTIONRJBC_INIT RETURNS VARCHAR2
DBMS_JAVA FUNCTIONRJBC_NORMALIZE RETURNS NUMBER
DBMS_JAVA FUNCTIONRJBC_REQUEST RETURNS NUMBER
DBMS_JAVA FUNCTIONRJBC_RESPOND RETURNS NUMBER
DBMS_JAVA FUNCTIONSTART_LOADING_JAR RETURNS NUMBER
DBMS_JAVA PROCEDUREDEPLOY_COPY
DBMS_JAVA PROCEDUREDEPLOY_OPEN
DBMS_JAVA PROCEDURERJBC_DONE
DBMS_JAVA PROCEDURERJBC_OUTPUT
DBMS_JDM_INTERNAL FUNCTIONGET_JDM_ATTR_NAMES RETURNS JDM_ATTR_NAMES
DBMS_JDM_INTERNAL FUNCTIONGET_JDM_NUM_VALS RETURNS JDM_NUM_VALS
DBMS_JDM_INTERNAL FUNCTIONGET_JDM_STR_VALS RETURNS JDM_STR_VALS
DBMS_JDM_INTERNAL FUNCTIONTO_CHAR_VARRAY RETURNS VARCHAR2
DBMS_JDM_INTERNAL FUNCTIONUNIQUE_OBJECT_NAME RETURNS VARCHAR2
DBMS_JDM_INTERNAL PROCEDUREAPPLY_TASK
DBMS_JDM_INTERNAL PROCEDUREBUILD_TASK
DBMS_JDM_INTERNAL PROCEDUREEXPLAIN_TASK
DBMS_JDM_INTERNAL PROCEDUREEXPORT_TASK
DBMS_JDM_INTERNAL PROCEDUREIMPORT_TASK
DBMS_JDM_INTERNAL PROCEDUREPREDICT_TASK
DBMS_JDM_INTERNAL PROCEDUREPROFILE_TASK
DBMS_JDM_INTERNAL PROCEDURESQL_APPLY_TASK
DBMS_JDM_INTERNAL PROCEDURETEST_TASK
DBMS_JDM_INTERNAL PROCEDUREXFORM_SEQ_TASK
DBMS_JDM_INTERNAL PROCEDUREXFORM_TASK
DBMS_LOGMNR_INTERNAL PROCEDUREADDXTENDEDPKLOGGROUP
DBMS_LOGMNR_INTERNAL PROCEDUREDROPXTENDEDPKLOGGROUP
DBMS_LOGMNR_INTERNAL PROCEDUREKRVGDRM2
DBMS_LOGMNR_INTERNAL PROCEDURELOGMNR_KRVILD
DBMS_LOGMNR_INTERNAL PROCEDURELOGMNR_KRVIULD
DBMS_LOGMNR_INTERNAL PROCEDURESET_PARAMETER
DBMS_LOGMNR_INTERNAL PROCEDUREUNSET_PARAMETER
DBMS_LOGSTDBY FUNCTIONVALIDATE_AUTH RETURNS BOOLEAN
DBMS_LOGSTDBY PROCEDUREEDS_EVOLVE_TABLE
DBMS_METADATA_INT PROCEDURECLEAR_CACHE
DBMS_METADATA_INT PROCEDURECLEAR_XSL_CACHE
DBMS_OBJECTS_UTILS FUNCTIONSPLIT_SOURCE RETURNS NUMBER
DBMS_OBJECTS_UTILS PROCEDURERECOMPILE_TYPES
DBMS_OBJECTS_UTILS PROCEDUREUPDATE_TYPES
DBMS_REPORT FUNCTIONSTORE_FILE RETURNS NUMBER
DBMS_REPORT PROCEDURECREATE_SHARED_DIRECTORY
DBMS_REPORT PROCEDUREDROP_SHARED_DIRECTORY
DBMS_RMIN PROCEDUREINSTALL
DBMS_RMIN PROCEDURERM$_CALIBRATE_IO
DBMS_RMIN PROCEDURERM$_CLRPAREA
DBMS_RMIN PROCEDURERM$_CONSUMER_GROUP_MAPPING_PRI
DBMS_RMIN PROCEDURERM$_CRTPAREA
DBMS_RMIN PROCEDURERM$_CUP_CATEGORY
DBMS_RMIN PROCEDURERM$_CUP_GROUP
DBMS_RMIN PROCEDURERM$_CUP_PLAN
DBMS_RMIN PROCEDURERM$_CUP_PLAN_DIRECTIVE
DBMS_RMIN PROCEDURERM$_CUP_STORAGE_POOL_MAPPING
DBMS_RMIN PROCEDURERM$_DRP_CATEGORY
DBMS_RMIN PROCEDURERM$_DRP_GROUP
DBMS_RMIN PROCEDURERM$_DRP_PLAN
DBMS_RMIN PROCEDURERM$_DRP_PLAN_CSD
DBMS_RMIN PROCEDURERM$_DRP_PLAN_DIRECTIVE
DBMS_RMIN PROCEDURERM$_SET_CAPABILITY
DBMS_RMIN PROCEDURERM$_SET_CONSUMER_GROUP_MAPPING
DBMS_RMIN PROCEDURERM$_SET_INSTANCE_CAPABILITY
DBMS_RMIN PROCEDURERM$_SUBPAREA
DBMS_RMIN PROCEDURERM$_SWTCH_SESSION_GROUP
DBMS_RMIN PROCEDURERM$_SWTCH_USR_GROUP
DBMS_RMIN PROCEDURERM$_VLDPAREA
DBMS_RMIN PROCEDUREUNINSTALL
DBMS_RULE_COMPATIBLE_90 FUNCTIONINCOMPATIBLE_RULES_ENGINE_OBJ RETURNS NUMBER
DBMS_RULE_COMPATIBLE_90 PROCEDUREDOWNGRADE_RULE_OBJECTS
DBMS_RULE_COMPATIBLE_90 PROCEDUREINCOMPATIBLE_EVCTXS
DBMS_RULE_COMPATIBLE_90 PROCEDUREINCOMPATIBLE_RULES
DBMS_RULE_COMPATIBLE_90 PROCEDUREINCOMPATIBLE_RULESETS
DBMS_RULE_COMPATIBLE_90 PROCEDUREUPGRADE_RULE_OBJECTS
DBMS_SPM_INTERNAL FUNCTIONFETCH_PLAN_INFO RETURNS REF CURSOR
DBMS_SPM_INTERNAL PROCEDUREGET_SPM_HINTSET
DBMS_SQL2 PROCEDUREEXPAND_SQL_TEXT
DBMS_SQL2 PROCEDUREPARSE
DBMS_STATS FUNCTIONTO_CASCADE_TYPE RETURNS BOOLEAN
DBMS_STATS FUNCTIONTO_DEGREE_TYPE RETURNS NUMBER
DBMS_STATS FUNCTIONTO_ESTIMATE_PERCENT_TYPE RETURNS NUMBER
DBMS_STATS FUNCTIONTO_PUBLISH_TYPE RETURNS BOOLEAN
DBMS_STATS_INTERNAL FUNCTIONCOMPOSE_HASHVAL_CLOB RETURNS CLOBTAB
DBMS_STATS_INTERNAL FUNCTIONGET_CHTAB RETURNS CHTAB
DBMS_STATS_INTERNAL FUNCTIONGET_SYNOPSIS_BLKCNT RETURNS NUMBER(38)
DBMS_STATS_INTERNAL PROCEDUREDELETE_TABLE_SYNOPSIS
DBMS_STATS_INTERNAL PROCEDUREEXPORT_SYNOPSIS_HEAD
DBMS_SWRF_REPORT_INTERNALFUNCTIONTO_1000S RETURNS VARCHAR2
DBMS_SWRF_REPORT_INTERNALFUNCTIONTO_1024S RETURNS VARCHAR2
DBMS_WORKLOAD_REPLAY FUNCTIONSYNCPOINT_WAIT_TO_POST RETURNS NUMBER
DBMS_WRR_INTERNAL FUNCTIONDATE_TO_EPOCH_SECS RETURNS BINARY_INTEGER
DBMS_WRR_INTERNAL FUNCTIONIS_CONSOLIDATED_DIR RETURNS BOOLEAN
DBMS_XDS PROCEDUREREFRESH_DSD
DBMS_XDSUTL PROCEDUREINVALIDATE_DSD_CACHE
DBMS_XDSUTL PROCEDUREINVALIDATE_DSD_CACHE_BY_ACLID
DBMS_XS_SECCLASS_INT PROCEDUREDELETE_SEC_CLASS
DBMS_XS_SECCLASS_INT PROCEDUREGET_LEAF_PRIVILEGES
DBMS_XS_SECCLASS_INT_FFI PROCEDUREDELETE_SEC_CLASS
DBMS_XS_SECCLASS_INT_FFI PROCEDUREGET_LEAF_PRIVILEGES
DBMS_XS_SESSIONS FUNCTIONCHECK_ROLE RETURNS BOOLEAN
DBMS_XS_SESSIONS FUNCTIONCHECK_SESSION RETURNS BOOLEAN
DBMS_XS_SESSIONS FUNCTIONGET_SESSIONID_FROM_COOKIE RETURNS RAW
DBMS_XS_SESSIONS PROCEDUREABORTATTACH_SESSION
DBMS_XS_SESSIONS PROCEDUREGET_SESSION_COOKIE
DBMS_XS_SESSIONS PROCEDURESET_NAMESPACE_ACL
DBMS_XS_SESSIONS PROCEDURESET_NAMESPACE_HANDLER
DBMS_XS_SESSIONS_FFI PROCEDUREABORTATTACH_SESSION
DBMS_XS_SESSIONS_FFI PROCEDURECHECK_ROLE
DBMS_XS_SESSIONS_FFI PROCEDURECHECK_SESSION
DBMS_XS_SESSIONS_FFI PROCEDUREGET_SESSION_COOKIE
DBMS_XS_SESSIONS_FFI PROCEDURESET_NAMESPACE_ACL
DBMS_XS_SESSIONS_FFI PROCEDURESET_NAMESPACE_HANDLER
DMP_SEC FUNCTIONGET_MODEL_DETAILS_ABN RETURNS VARCHAR2(32767)
DMP_SYS PROCEDUREDUMP_MODEL_REC
DMP_SYS PROCEDUREDUMP_TRACE
DMP_SYS PROCEDUREDUMP_VARCHAR2A
DMP_SYS PROCEDUREDUMP_VARCHAR2S
DM_QGEN PROCEDURELS_DUMP
EXF$DBMS_EXPFIL_SYSPACK FUNCTIONGET_CMTSCN_FOR_XID RETURNS NUMBER
EXF$DBMS_EXPFIL_SYSPACK FUNCTIONGET_EXPRID_4M_TEXTID RETURNS VARCHAR2
EXF$DBMS_EXPFIL_SYSPACK FUNCTIONGET_SPATIAL_MDATAREP RETURNS VARCHAR2
EXF$DBMS_EXPFIL_SYSPACK FUNCTIONGET_TAB_NAME RETURNS VARCHAR2
EXF$DBMS_EXPFIL_SYSPACK FUNCTIONGET_TAB_OWNER RETURNS VARCHAR2
EXF$DBMS_EXPFIL_SYSPACK FUNCTIONGET_TYPELV_STATUS RETURNS VARCHAR2
EXF$DBMS_EXPFIL_SYSPACK FUNCTIONGET_TYPE_OID RETURNS RAW
EXF$DBMS_EXPFIL_SYSPACK FUNCTIONPROC_IS_DEFINERS RETURNS NUMBER
EXF$DBMS_EXPFIL_SYSPACK FUNCTIONTAB_COLUMN_EXISTS RETURNS NUMBER
EXF$DBMS_EXPFIL_SYSPACK PROCEDURECLR_EXP_DEPACTION
EXF$DBMS_EXPFIL_SYSPACK PROCEDURECLR_OBJECT_NOEXP
EXF$DBMS_EXPFIL_SYSPACK PROCEDURECLR_USER_NOEXP
EXF$DBMS_EXPFIL_SYSPACK PROCEDUREDOWNGRADE_COMPILED_SPARSE
EXF$DBMS_EXPFIL_SYSPACK PROCEDUREPARSE_PROC_AS_OWNER
EXF$DBMS_EXPFIL_SYSPACK PROCEDUREPARSE_PROC_AS_OWNER2
EXF$DBMS_EXPFIL_SYSPACK PROCEDURESET_EXP_DEPACTION
EXF$DBMS_EXPFIL_SYSPACK PROCEDURESET_OBJECT_NOEXP
HTMLDB_SYSTEM FUNCTIONVERIFY_USER RETURNS BINARY_INTEGER
INITJVMAUX FUNCTIONDO_JIS_DROP RETURNS BOOLEAN
KUPD$DATA FUNCTIONCONVENTIONAL_LOAD_CALLOUT RETURNS BINARY_INTEGER
KUPF$FILE_INT FUNCTIONGET_ENCPWD RETURNS RAW
KUPF$FILE_INT FUNCTIONGET_OBFPWD RETURNS RAW
KUPF$FILE_INT PROCEDUREENCRYPT_PWD
KUPP$PROC PROCEDUREINTALGCONV
LOGMNR_DICT_CACHE PROCEDUREPURGE_SCN
LOGSTDBY_INTERNAL PROCEDUREEDS_EVOLVE_TABLE_1_I
ODM_ABN_MODEL PROCEDUREBUILD
ODM_ABN_MODEL PROCEDUREESTIMATE_FEATUREBLD_TIME
ODM_ABN_MODEL PROCEDUREGET_MODEL_STATE
ODM_CLUSTERING_UTIL FUNCTIONIS_DEBUG_ENABLED RETURNS BOOLEAN
ODM_MODEL_UTIL FUNCTIONUNIQUE_SEQUENCE_NAME RETURNS VARCHAR2(30)
ODM_MODEL_UTIL PROCEDURECREATE_SEQUENCE
ODM_MODEL_UTIL PROCEDUREDEBUG_DUMP
ODM_MODEL_UTIL PROCEDUREDROP_SEQUENCE
ODM_MODEL_UTIL PROCEDUREGET_TIME_MILLISECONDS
ODM_UTIL FUNCTIONCOMPUTE_LOG_COMBINATIONS RETURNS NUMBER
PRVT_RTADDM FUNCTIONEXTRACTOSSTAT RETURNS NUMBER
PRVT_RTADDM FUNCTIONGETDATA RETURNS CLOB_T
PRVT_RTADDM FUNCTIONGETVERSION RETURNS VARCHAR2
SQLJUTL2 FUNCTIONEVALUATE RETURNS LONG RAW
SQLJUTL2 FUNCTIONINVOKE RETURNS LONG RAW
SQLJUTL2 FUNCTIONREFLECT RETURNS LONG
SQLJUTL2 FUNCTIONREFLECT2 RETURNS CLOB
STANDARD FUNCTIONASCII RETURNS BINARY_INTEGER

0 件のコメント:

コメントを投稿