New In Oracle Database Version 12cR2
Version 12.2.0.1

Description Link Last Modified
Architecture
Analytic Views Analytic Views 02-Oct-2016
New dhcs.bsq and dmisc.bsq files in $ORACLE_HOME/rdbms/admin files BSQ Files 13-Mar-2017
 
General
New Roles
  • APEX_ADMINISTRATOR_READ_ROLE
  • APPLICATION_TRACE_VIEWER
  • DATAPATCH_ROLE
  • DBJAVASCRIPT
  • DBMS_MDX_INTERNAL
  • DV_POLICY_OWNER
  • GGSYS_ROLE
  • RDFCTX_ADMIN
  • RECOVERY_CATALOG_OWNER_VPD
  • SODA_APP
  • SYSUMF_ROLE
  • XFILES_ADMINISTRATOR
  • XFILES_USER
  • XS_CONNECT
Deprecated/Dropped Roles
  • DBAHADOOP
  • DELETE_CATALOG_ROLE
  • SPATIAL_WFS_ADMIN
  • WFS_USR_ROLE
  • XS_RESOURCE
ROLE 24-Mar-2017
New System Privileges
  • ALTER ANY ANALYTIC VIEW
  • ALTER ANY ATTRIBUTE DIMENSION
  • ALTER ANY HIERARCHY
  • CREATE ANALYTIC VIEW
  • CREATE ANY ANALYTIC VIEW
  • CREATE ANY ATTRIBUTE DIMENSION
  • CREATE ANY HIERARCHY
  • CREATE ATTRIBUTE DIMENSION
  • CREATE HIERARCHY
  • DROP ANY ANALYTIC VIEW
  • DROP ANY ATTRIBUTE DIMENSION
  • DROP ANY HIERARCHY
SYSTEM PRIVILEGES 21-Nov-2016
New System Users
  • APEX_050100
  • APEX_INSTANCE_ADMIN_USER
  • APEX_LISTENER
  • APEX_REST_PUBLIC_USER
  • DBJSON
  • DBSFWUSER
  • GGSYS
  • HRREST
  • OBE
  • ORDS_METADATA
  • ORDS_PUBLIC_USER
  • PDBADMIN
  • REMOTE_SCHEDULER_AGENT
  • RESTFUL
  • SYS$UMF
  • SYSRAC
  • XDBEXT
  • XDBPM
  • XFILES
USERS TBD
Transparent Data Encryption supports ARIA, GOST, and SEED encryption algorithms Transparent Data Encryption 23-Feb-2017
 
Deprecated or Dropped
DBMSOBJG DBMSOBJG 18-Mar-2017
DBMSOBJG2 DBMSOBJG2 18-Mar-2017
DBMSOBJGWRAPPER DBMSOBJGWRAPPER 18-Mar-2017
DBMSOBJG_DP DBMSOBJG_DP 18-Mar-2017
DBMS_ASYNCRPC_PUSH DBMS_ASYNCRPC_PUSH 08-Apr-2017
DBMS_DEFER - 24-May-2017
DBMS_DEFERGEN - 24-May-2017
DBMS_DEFERGEN_AUDIT - 24-May-2017
DBMS_DEFERGEN_UTIL - 24-May-2017
DBMS_DEFER_DEFINER - 24-May-2017
DBMS_DEFER_ENQ_UTL - 24-May-2017
DBMS_DEFER_IMPORT_INTERNAL - 24-May-2017
DBMS_DEFER_INTERNAL - 24-May-2017
DBMS_DEFER_INTERNAL_QUERY - 24-May-2017
DBMS_DEFER_INTERNAL_SYS - 24-May-2017
DBMS_DEFER_LOB - 24-May-2017
DBMS_DEFER_PRIORITY - 24-May-2017
DBMS_DEFER_QUERY - 24-May-2017
DBMS_DEFER_QUERY_DEFINER - 24-May-2017
DBMS_DEFER_QUERY_UTL - 24-May-2017
DBMS_DEFER_REPCAT - 24-May-2017
DBMS_DEFER_RESOLUTION - 24-May-2017
DBMS_DEFER_SYS - 24-May-2017
DBMS_DEFER_SYS_DEFINER - 24-May-2017
DBMS_DEFER_SYS_PART1 - 24-May-2017
DBMS_DEFER_WRAP - 24-May-2017
DBMS_INTERNAL_REPCAT - 24-May-2017
DBMS_MACSEC_ROLE_ADMIN - 24-May-2017
DBMS_MAINT_GEN - 24-May-2017
DBMS_OFFLINE_INTERNAL - 24-May-2017
DBMS_OFFLINE_OG - 24-May-2017
DBMS_OFFLINE_OG_INTERNAL - 24-May-2017
DBMS_OFFLINE_RGT - 24-May-2017
DBMS_OFFLINE_RGT_INTERNAL - 24-May-2017
DBMS_OFFLINE_SNAPSHOT DBMS_OFFLINE_SNAPSHOT 08-Apr-2017
DBMS_OFFLINE_SNAPSHOT_INTERNAL - 24-May-2017
DBMS_OFFLINE_SNA_INTERNAL - 24-May-2017
DBMS_OFFLINE_UTL DBMS_OFFLINE_UTL 08-Apr-2017
DBMS_PREUP DBMS_PREUP 16-Apr-2017
DBMS_RECTIFIER_DIFF DBMS_RECTIFIER_DIFF 08-Apr-2017
DBMS_RECTIFIER_DIFF_INTERNAL DBMS_RECTIFIER_DIFF_INTERNAL 08-Apr-2017
DBMS_RECTIFIER_FRIENDS DBMS_RECTIFIER_FRIENDS 08-Apr-2017
DBMS_REFRESH_EXP_LWM - 24-May-2017
DBMS_REFRESH_EXP_SITES - 24-May-2017
DBMS_REPCAT_ADD_MASTER DBMS_REPCAT_ADD_MASTER 18-Apr-2017
DBMS_REPCAT_ADMIN DBMS_REPCAT_ADMIN 18-Apr-2017
DBMS_REPCAT_AUTH DBMS_REPCAT_AUTH 18-Apr-2017
DBMS_REPCAT_CACHE DBMS_REPCAT_CACHE 18-Apr-2017
DBMS_REPCAT_COMMON_UTL DBMS_REPCAT_COMMON_UTL 18-Apr-2017
DBMS_REPCAT_CONF DBMS_REPCAT_CONF 18-Apr-2017
DBMS_REPCAT_DECL DBMS_REPCAT_DECL 18-Apr-2017
DBMS_REPCAT_DEFINER DBMS_REPCAT_DEFINER 18-Apr-2017
DBMS_REPCAT_EXP DBMS_REPCAT_EXP 18-Apr-2017
DBMS_REPCAT_FLA DBMS_REPCAT_FLA 18-Apr-2017
DBMS_REPCAT_FLA_MAS DBMS_REPCAT_FLA_MAS 18-Apr-2017
DBMS_REPCAT_FLA_UTL DBMS_REPCAT_FLA_UTL 18-Apr-2017
DBMS_REPCAT_INSTANTIATE DBMS_REPCAT_INSTANTIATE 18-Apr-2017
DBMS_REPCAT_INTERNAL DBMS_REPCAT_INTERNAL 18-Apr-2017
DBMS_REPCAT_INTERNAL_PACKAGE DBMS_REPCAT_INTERNAL_PACKAGE 18-Apr-2017
DBMS_REPCAT_MAS DBMS_REPCAT_MAS 18-Apr-2017
DBMS_REPCAT_MIGRATION DBMS_REPCAT_MIGRATION 18-Apr-2017
DBMS_REPCAT_MIG_INTERNAL DBMS_REPCAT_MIG_INTERNAL 18-Apr-2017
DBMS_REPCAT_OBJ_UTL DBMS_REPCAT_OBJ_UTL 18-Apr-2017
DBMS_REPCAT_OUTPUT DBMS_REPCAT_OUTPUT 18-Apr-2017
DBMS_REPCAT_RGT DBMS_REPCAT_RGT 18-Apr-2017
DBMS_REPCAT_RGT_ALT DBMS_REPCAT_RGT_ALT 18-Apr-2017
DBMS_REPCAT_RGT_CHK DBMS_REPCAT_RGT_CHK 18-Apr-2017
DBMS_REPCAT_RGT_CUST DBMS_REPCAT_RGT_CUST 18-Apr-2017
DBMS_REPCAT_RGT_CUST2 DBMS_REPCAT_RGT_CUST2 18-Apr-2017
DBMS_REPCAT_RGT_EXP DBMS_REPCAT_RGT_EXP 18-Apr-2017
DBMS_REPCAT_RGT_UTL DBMS_REPCAT_RGT_UTL 18-Apr-2017
DBMS_REPCAT_RPC DBMS_REPCAT_RPC 18-Apr-2017
DBMS_REPCAT_RPC_UTL DBMS_REPCAT_RPC_UTL 18-Apr-2017
DBMS_REPCAT_RQ DBMS_REPCAT_RQ 18-Apr-2017
DBMS_REPCAT_SNA DBMS_REPCAT_SNA 18-Apr-2017
DBMS_REPCAT_SNA_INTERNAL DBMS_REPCAT_SNA_INTERNAL 18-Apr-2017
DBMS_REPCAT_SNA_UTL DBMS_REPCAT_SNA_UTL 18-Apr-2017
DBMS_REPCAT_SQL_UTL DBMS_REPCAT_SQL_UTL 18-Apr-2017
DBMS_REPCAT_UNTRUSTED DBMS_REPCAT_UNTRUSTED 18-Apr-2017
DBMS_REPCAT_UTL DBMS_REPCAT_UTL 18-Apr-2017
DBMS_REPCAT_UTL2 DBMS_REPCAT_UTL2 18-Apr-2017
DBMS_REPCAT_UTL3 DBMS_REPCAT_UTL3 18-Apr-2017
DBMS_REPCAT_UTL4 DBMS_REPCAT_UTL4 18-Apr-2017
DBMS_REPCAT_VALIDATE DBMS_REPCAT_VALIDATE 18-Apr-2017
DBMS_REPUTIL2 DBMS_REPUTIL2 18-Apr-2017
DBMS_SQLPLUS_SCRIPT DBMS_SQLPLUS_SCRIPT 06-May-2017
GV$REPLPROP Dynamic Performance Views 12-Jun-2017
GV$REPLQUEUE Dynamic Performance Views 12-Jun-2017
WWV_DBMS_SQL WWV_DBMS_SQL 25-May-2017
XMLROOT Function XMLROOT 01-Feb-2017
 
New SQL
APPROX_COUNT_DISTINCT_AGG Function APPROX_COUNT_DISTINCT_AGG TBD
APPROX_COUNT_DISTINCT_DETAIL Function APPROX_COUNT_DISTINCT_DETAIL TBD
APPROX_MEDIAN Function APPROX_MEDIAN TBD
APPROX_PERCENTILE Function APPROX_PERCENTILE TBD
APPROX_PERCENTILE_AGG Function APPROX_PERCENTILE_AGG TBD
APPROX_PERCENTILE_DETAIL Function APPROX_PERCENTILE_DETAIL TBD
COLLATION Function COLLATION TBD
DBMS_FEATURE_ACFS Feature Usage Procedures 24-May-2017
DBMS_FEATURE_ACFS_ENCR Feature Usage Procedures 24-May-2017
DBMS_FEATURE_ACFS_SNAPSHOT Feature Usage Procedures 24-May-2017
DBMS_FEATURE_AFD Feature Usage Procedures 24-May-2017
DBMS_FEATURE_CLOUD_EHCC Feature Usage Procedures 24-May-2017
DBMS_FEATURE_FLEX_ASM Feature Usage Procedures 24-May-2017
DBMS_FEATURE_HCCCONV Feature Usage Procedures 24-May-2017
DBMS_FEATURE_IMFS Feature Usage Procedures 24-May-2017
DBMS_FEATURE_IM_ADO Feature Usage Procedures 24-May-2017
DBMS_FEATURE_IM_EXPRESSIONS Feature Usage Procedures 24-May-2017
DBMS_FEATURE_IM_FORSERVICE Feature Usage Procedures 24-May-2017
DBMS_FEATURE_IM_JOINGROUPS Feature Usage Procedures 24-May-2017
DBMS_FEATURE_SHARD Feature Usage Procedures 24-May-2017
DBMS_FEATURE_THP Feature Usage Procedures 24-May-2017
DBMS_FEATURE_UTILITIES5 Feature Usage Procedures 24-May-2017
DBMS_FEATURE_UTILITIES6 Feature Usage Procedures 24-May-2017
FEATURE_COMPARE Function FEATURE_COMPARE TBD
JSON_DATAGUIDE Function JSON_DATAGUIDE TBD
NLS_COLLATION_ID Function NLS_COLLATION_ID TBD
NLS_COLLATION_NAME Function NLS_COLLATION_NAME TBD
ORA_DM_PARTITION_NAME Function ORA_DM_PARTITION_NAME TBD
TO_APPROX_COUNT_DISTINCT Function TO_APPROX_COUNT_DISTINCT TBD
TO_APPROX_PERCENTILE Function TO_APPROX_PERCENTILE TBD
VALIDATE_CONVERSION Function VALIDATE_CONVERSION TBD
 
New PL/SQL
Before/After Set Container System Event Trigger System Event Trigger 13-May-2017
Pragma Coverage Pragma Coverage 04-Apr-2017
Pragma Deprecate Pragma Deprecate 04-Apr-2017
 
New or Modified Functions, Operators, Procedures, and Types
APPROX_COUNT_DISTINCT_AGG Function Numeric Function TBD
APPROX_COUNT_DISTINCT_DETAIL Function Numeric Function TBD
APPROX_MEDIAN Function Numeric Function TBD
APPROX_PERCENTILE Function Numeric Function TBD
APPROX_PERCENTILE_AGG Function Numeric Function TBD
APPROX_PERCENTILE_DETAIL Function Numeric Function TBD
COLLATION Function Miscellaneous Function TBD
FEATURE_COMPARE Function Miscellaneous Function TBD
JSON_DATAGUIDE Function Miscellaneous Function TBD
NLS_COLLATION_ID Function Miscellaneous Function TBD
NLS_COLLATION_NAME Function Miscellaneous Function TBD
ORA_DM_PARTITION_NAME Function Miscellaneous Function TBD
PERMIT_92_WRAP_FORMAT Compiler Directive Compilation Parameters 03-Mar-2017
SYS_CONTEXT has a new SESSION_DEFAULT_COLLATION predefined parameter SYS_CONTEXT 18-Jan-2017
TO_APPROX_COUNT_DISTINCT_AGG Function Numeric Function TBD
TO_APPROX_PERCENTILE Function Numeric Function TBD
VALIDATE_CONVERSION Function Miscellaneous Functions 03-Mar-2017
 
Object Rename
DBMS_LOGMNR_SESSION (in 12.1) renamed to DBMS_LOGMNR_SESSION_INT - 24-May-2017
 
XML and XML
JSON Data Guides JSON Data Guides TBD
 
New Built-in Packages (72)
XDBPM.AS_ZIP with 6 objects and an initialization section AS_ZIP 05-Jun-2017
SYS.CDBVIEW_INTERNAL with 1 procedure CDBVIEW_INTERNAL 24-May-2017
SYS.DBMS_AQADM_VAR with 3 functions DBMS_AQADM_VAR 19-Mar-2017
SYS.DBMS_AUDIT_UTIL with 4 functions DBMS_AUDIT_UTIL 18-Mar-2017
SYS.DBMS_CRYPTO_INTERNAL with 4 functions DBMS_CRYPTO_INTERNAL 18-Mar-2017
SYS.DBMS_CSX_INT2 with 2 objects DBMS_CSX_INT2 27-May-2017
SYS.DBMS_DATAPUMP_INT with 5 functions and 2 procedures DBMS_DATAPUMP_INT 13-May-2017
SYS.DBMS_DBCOMP with 1 procedure DBMS_DBCOMP 18-Mar-2017
SYS.DBMS_DISRUPT with 7 procedures DBMS_DISRUPT 18-Mar-2017
SYS.DBMS_FIX_CONTROL_PERSISTENCE with 4 objects DBMS_FIX_CONTROL_PERSISTENCE 05-Jun-2017
SYS.DBMS_GOLDENGATE_ADM with 12 objects DBMS_GOLDENGATE_ADM 12-Jun-2017
SYS.DBMS_GOLDENGATE_ADM_INTERNAL with 2 procedures DBMS_GOLDENGATE_ADM_INTERNAL 05-Jun-2017
SYS.DBMS_GOLDENGATE_ADM_INT_INVOK with 5 procedures DBMS_GOLDENGATE_ADM_INT_INVOK -
SYS.DBMS_GOLDENGATE_EXP with 1 object DBMS_GOLDENGATE_EXP -
SYS.DBMS_GOLDENGATE_IMP with 5 objects DBMS_GOLDENGATE_IMP -
SYS.DBMS_GSM_FIX with 3 objects DBMS_GSM_FIX -
SYS.DBMS_GSM_FIXED with 3 procedures and 1 function DBMS_GSM_FIXED -
SYS.DBMS_GSM_XDB with 1 objects DBMS_GSM_XDB -
SYS.DBMS_HADOOP with 2 procedures DBMS_HADOOP 18-Mar-2017
SYS.DBMS_HADOOP_INTERNAL with 1 procedure and 22 functions DBMS_HADOOP_INTERNAL -
SYS.DBMS_HANG_MANAGER with 1 procedure DBMS_HANG_MANAGER 10-Apr-2017
SYS.DBMS_HEAT_MAP_INTERNAL with 6 objects DBMS_HEAT_MAP_INTERNAL 13-Jun-2017
SYS.DBMS_HIERARCHY with 2 procedures and 2 functions DBMS_HIERARCHY 11-Apr-2017
SYS.DBMS_INMEMORY_ADMIN with 9 objects including 2 moved from DBMS_INMEMORY DBMS_INMEMORY_ADMIN 17-Apr-2017
SYS.DBMS_IREFSTATS with 6 procedures DBMS_IREFSTATS -
SYS.DBMS_ISCHED_REMOTE_ACCESS with 8 objects DBMS_ISCHED_REMOTE_ACCESS -
SYS.DBMS_JAVASCRIPT with 1 procedure DBMS_JAVASCRIPT 11-Apr-2017
XDB.DBMS_JSON with 6 objects DBMS_JSON 30-Oct-2016
SYS.DBMS_JSON0 with 2 procedures and 2 functions DBMS_JSON0 11-Apr-2017
XDB.DBMS_JSON_INT with 7 objects DBMS_JSON_INT -
SYS.DBMS_MANAGEMENT_BOOTSTRAP with 1 procedure DBMS_MANAGEMENT_BOOTSTRAP 13-Apr-2017
SYS.DBMS_MASTER_TABLE with 9 procedures and 1 function DBMS_MASTER_TABLE 29-May-2017
SYS.DBMS_MDX_ODBO (33 functions + many procs) DBMS_MDX_ODBO -
SYS.DBMS_MVIEW_STATS with 3 procedures one with 2 overloads DBMS_MVIEW_STATS 16-Apr-2017
SYS.DBMS_MVIEW_STATS_INTERNAL with 3 procedures one with 2 overloads DBMS_MVIEW_STATS_INTERNAL 16-Apr-2017
SYS.DBMS_PCLXUTIL_INTERNAL with one procedure DBMS_PCLXUTIL_INTERNAL 22-May-2017
SYS.DBMS_PDB_ALTER_SHARING with 7 procedures DBMS_PDB_ALTER_SHARING 26-Mar-2017
SYS.DBMS_PLSQL_CODE_COVERAGE with 6 procedures DBMS_PLSQL_CODE_COVERAGE 03-Apr-2017
SYS.DBMS_PQ_INTERNAL with 1 object DBMS_PQ_INTERNAL 25-May-2017
SYS.DBMS_PREPLUGIN_BACKUP with 7 new objects DBMS_PREPLUGIN_BACKUP 16-Apr-2017
SYS.DBMS_PROCESS with 3 new procedures DBMS_PROCESS 16-Apr-2017
SYS.DBMS_RLS_INT with 15 objects (prvtrlsa.plb) DBMS_RLS_INT -
SYS.DBMS_SCHED_CONSTRAINT_EXPORT with 6 objects DBMS_SCHED_CONSTRAINT_EXPORT -
DBSFWUSER.DBMS_SFW_ACL_ADMIN with 30 objects DBMS_SFW_ACL_ADMIN 08-Jun-2017
SYS.DBMS_SNAPSHOT_COMMON with 3 objects DBMS_SNAPSHOT_COMMON -
SYS.DBMS_SNAPSHOT_KKXRCA with 28 objects many of them with overloads DBMS_SNAPSHOT_KKXRCA -
SYS.DBMS_SODA_ADMIN_ with 10 objects DBMS_SODA_ADMIN -
SYS.DBMS_SODA_DML with 7 objects DBMS_SODA_DML -
SYS.DBMS_SODA_DOM with 16 objects DBMS_SODA_DOM -
SYS.DBMS_SODA_UTIL with 11 objects DBMS_SODA_UTIL -
SYS.DBMS_SPACE_ALERT with 5 objects DBMS_SPACE_ALERT 25-May-2017
SYS.DBMS_STATS_ADVISOR with 73 objects DBMS_STATS_ADVISOR -
SYS.DBMS_STATS_INTERNAL with 302 objects DBMS_STATS_INTERNAL -
DBSFWUSER.DBMS_SFW_ACL_ADMIN with 30 objects DBMS_SFW_ACL_ADMIN 07-Jun-2017
SYS.DBMS_SYNC_REFRESH_INTERNAL with 18 objects DBMS_SYNC_REFRESH_INTERNAL -
SYS.DBMS_TF with 8 objects, 3 with 2 overloads and 1 with 7 DBMS_TF 17-Apr-2017
SYS.DBMS_TG_DBG with 1 procedure DBMS_TG_DBG 22-Mar-2017
SYS.DBMS_TNS with one procedure DBMS_TNS 07-Feb-2017
SYS.DBMS_UMF with 16 objects some overloaded DBMS_UMF 19-Apr-2017
SYS.DBMS_UMF_INTERNAL with 21 objects DBMS_UMF_INTERNAL -
SYS.DBMS_UMF_PROTECTED with 9 objects DBMS_UMF_PROTECTED 14-May-2017
SYS.DBMS_WRR_PROTECTED with 2 objects DBMS_WRR_PROTECTED -
SYS.DBMS_WRR_STATE an orphan package header DBMS_WRR_STATE 25-May-2017
SYS.DBMS_XDB_UTIL with 1 object and 5 overloads DBMS_XDB_UTIL -
CTXSYS.DRIACCHELP with 6 objects DRIACCHELP -
SYS.LBAC_EXP with 3 objects LBAC_EXP -
LBACSYS.LBAC_LGSTNDBY_UTIL with 21 objects LBAC_LGSTNDBY_UTIL -
WMSYS.LTSYS with 114 objects LTSYS -
SYS.ORA_DM_REFCUR_PKG an orphan package header ORA_DM_REFCUR_PKG 27-May-2017
ORDSYS.ORDERRORINT with 1 object ORDERRORINT -
ORDSYS.ORD_AUDIO with 3 objects 2 with overloads ORD_AUDIO  
ORDSYS.ORD_DOC with 3 objects 2 with overloads ORD_DOC -
ORDSYS.ORD_IMAGE with 17 objects many with overloads ORD_IMAGE -
WMSYS.OWM_CPKG_PKG with 1 object OWM_CPKG_PKG -
 
Built-in Packages with New or Removed Functions and Procedures
SYS.AS_REPLAY has dropped the END_AS_REPLAY and START_REPLAY procedures AS_REPLAY 28-Mar-2017
SYS.CDBVIEW has a new GETLONG function CDBVIEW 29-Jan-2017
CTXSYS.CTX_DDL has new ADD_FILTER_SECTION and REMOVE_OVERLAP_DOLLARS objects CTX_DDL 17-May-2017
SYS.DBMS_ADR has dropped CLEANOUT_SCHEMA, DOWNGRADE_SCHEMA, MIGRATE_SCHEMA & RECOVER_SCHEMA DBMS_ADR 28-Mar-2017
SYS.DBMS_ADR has added the new RUN_PURGE and SET_TRACEFILE_IDENTIFIER procedures DBMS_ADR 28-Mar-2017
SYS.DBMS_ADR_APP has added the new RUN_PURGE and SET_TRACEFILE_IDENTIFIER procedures DBMS_ADR_APP 28-Mar-2017
DBMS_ADR_INTERNAL has added the new RUN_PURGE and SET_TRACEFILE_IDENTIFIER procedures DBMS_ADR_INTERNAL 28-Mar-2017
DBMS_ASH_INTERNAL has new GET_CPUINFO_XML procedure DBMS_ASH_INTERNAL 18-May-2017
DBMS_AUDIT_MGMT has new TRANSFER_UNIFIED_AUIT_RECORDS procedure DBMS_AUDIT_MGMT 27-Oct-2016
DBMS_AW has new VALIDATE_AW_NAME procedure DBMS_AW 19-May-2017
DBMS_AWR_REPORT_LAYOUT has 2 new DIFF_EXA_ procedures DBMS_AWR_REPORT_LAYOUT 20-May-2017
DBMS_CSX_ADMIN has new 6 new objects DBMS_CSX_ADMIN 01-May-2017
DBMS_DNFS has new UNMOUNTVOLUME procedure DBMS_DNFS 12-Dec-2016
DBMS_INMEMORY has new IME_DROP_EXPRESSIONS and SEGMENT_DEALLOCATE_VERSION procedures DBMS_INMEMORY 17-Apr-2017
DBMS_INMEMORY moved DISABLEFASTSTART and ENABLEFASTSTART to DBMS_INMEMORY_ADMIN package DBMS_INMEMORY 17-Apr-2017
DBMS_METADATA_DPBUILD has new SET_DEBUG procedure DBMS_METADATA_DPBUILD 24-Jan-2017
DBMS_PDB has 8 new procedures and 2 new functions DBMS_PDB 07-Dec-2016
DBMS_PLUGTSP has the KCP_PD and KCP_PTMD procedures removed DBMS_PLUGTSP 05-Mar-2017
DBMS_PRIVILEGE_CAPTURE has new CAPTURE_DEPENDENCY_PRIVS and DELETE_RUN procedures DBMS_PRIVILEGE_CAPTURE 14-Mar-2017
DBMS_REPUTIL: All objects removed except REPLICATION_IS_ON, _OFF and _ON DBMS_REPUTIL 08-Apr-2017
DBMS_SCHEDULER has 8 new objects DBMS_SCHEDULER 29-May-2017
DBMS_SERVICE_PRVT has new GET_TOPOLOGY and IS_JAVA_SERVICE functions DBMS_SERVICE_PRVT TBD
DBMS_SQLDIAG has one new procedure with 2 overloads DBMS_SQLDIAG 29-May-2017
DBMS_SQLDIAG_INTERNAL drop the I_CREATE_PATCH function and replaces it with an overloaded proc of the same name DBMS_SQLDIAG_INTERNAL 29-May-2017
DBMS_STREAMS has new COMPATIBLE_12_2 function DBMS_STREAMS 04-Jun-2017
DBMS_STATS (17 new objects) DBMS_STATS TBD
 
Built-in Packages with New or Removed Overloads
DBMS_HPROF.ANALYZE has 2 new overloads, STOP_PROFILING has 1 new overload DBMS_HPROF 22-Dec-2016
 
Built-in Packages with Parameters Changes
DBMS_ADR.SET_LOG_MSG_TEMPLATE and WRITE_LOG have 3 new container database related parameters DBMS_ADR 28-Mar-2017
DBMS_ADR_APP.SET_LOG_MSG_TEMPLATE and WRITE_LOG have 3 new container database related parameters DBMS_ADR_APP 28-Mar-2017
DBMS_ADR_INTERNAL.WRITE_LOG_HANDLER has 3 new container database related parameters DBMS_ADR_INTERNAL 18-Mar-2017
DBMS_ADVISOR.EXECUTE_TASK overload 2 has 2 new parameters DBMS_ADVISOR 18-Mar-2017
DBMS_CONNECTION_POOL.CONFIGURE_POOL has 1 new parameters DBMS_CONNECTION_POOL 17-Nov-2016
DBMS_PART.CLEANUP_GIDX_INTERNAL has new NOOP_OKAY_IN parameter DBMS_PART 18-Feb-2017
DBMS_PRIVILEGE_CAPTURE has new RUN_NAME and DEPENDENCY parameters DBMS_PRIVILEGE_CAPTURE 14-Mar-2017
DBMS_SERVICE_PRVT.STOP_SERVICE 3 new parameters: STOP_OPTION, DRAIN_TIMEOUT, and REPLAY DBMS_SERVICE_PRVT TBD
DBMS_SNAPSHOT has new parameters in a number of objects DBMS_SNAPSHOT 26-May-2017
UTL_TCP.SECURE_CONNECTION has new SECURE_HOST parameter UTL_TCP 12-Jan-2017
 
Built-in Packages with new Constants, Exceptions, Types, and other significant changes
DBMS_DB_VERSION DBMS_DB_VERSION 26-May-2017
DBMS_HEAT_MAP has new data types DBMS_HEAT_MAP 13-Jun-2017
 
Related Topics
New in 11.2.0.3
New in 12.1.0.2
  Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2017 Daniel A. Morgan All Rights Reserved