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 07-Nov-2016
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_CLR DBMS_CLR 01-Feb-2017
XMLROOT Function XMLROOT 01-Feb-2017
 
New SQL
??? ??? TBD
 
New PL/SQL
??? ??? TBD
 
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
 
XML and XML
JSON Data Guides JSON Data Guides TBD
 
New Built-in Packages (23 documented, ## undocumented)
SYS.CDBVIEW_INTERNAL with 1 procedure CDBVIEW_INTERNAL 29-Jan-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_DATAPUMP_INT with 5 functions and 2 procedures DBMS_DATAPUMP_INT TBD
SYS.DBMS_DBCOMP with 1 procedure DBMS_DBCOMP 18-Mar-2017
SYS.DBMS_DISRUPT with 7 procedures DBMS_DISRUPT 18-Mar-2017
SYS.DBMS_GOLDENGATE_ADM with 12 objects DBMS_GOLDENGATE_ADM 18-Mar-2017
SYS.DBMS_GOLDENGATE_ADM_INTERNAL with 2 procedures DBMS_GOLDENGATE_ADM_INTERNAL TBD
SYS.DBMS_GOLDENGATE_ADM_INT_INVOK with 5 procedures DBMS_GOLDENGATE_ADM_INT_INVOK TBD
SYS.DBMS_GOLDENGATE_ADM_EXP with 1 procedure DBMS_GOLDENGATE_EXP TBD
SYS.DBMS_GOLDENGATE_ADM_IMP with 5 procedures DBMS_GOLDENGATE_IMP TBD
SYS.DBMS_GSM_FIX with 2 procedures DBMS_GSM_FIX TBD
SYS.DBMS_GSM_FIXED with 3 procedures and 1 function DBMS_GSM_FIXED TBD
SYS.DBMS_HADOOP with 2 procedures DBMS_HADOOP 18-Mar-2017
SYS.DBMS_HADOOP_INTERNAL with 1 procedure and 22 functions DBMS_HADOOP_INTERNAL TBD
SYS.DBMS_HANG_MANAGER with 1 procedure DBMS_HANG_MANAGER 18-Mar-2017
SYS.DBMS_HANG_HEAT_MAP_INTERNAL with 5 procedures and 4 functions DBMS_HEAT_MAP_INTERNAL TBD
SYS.DBMS_HIERARCHY with 2 procedures and 2 functions DBMS_HIERARCHY TBD
SYS.DBMS_HS_PASSTHROUGH (14) DBMS_HS_PASSTHROUGH TBD
SYS.DBMS_INMEMORY_ADMIN with 6 objects DBMS_INMEMORY_ADMIN 26-Dec-2016
SYS.DBMS_IREFSTATS with 6 procedures DBMS_IREFSTATS TBD
SYS.DBMS_ISCHED_REMOTE_ACCESS with 5 procedures and 2 functions DBMS_ISCHED_REMOTE_ACCESS TBD
SYS.DBMS_JAVASCRIPT with 1 procedure DBMS_JAVASCRIPT 16-Mar-2017
SYS.DBMS_JSON with 6 objects DBMS_JSON 30-Oct-2016
SYS.DBMS_JSON0 with 2 procedures and 2 functions DBMS_JSON0 23-Jan-2017
SYS.DBMS_MANAGEMENT_BOOTSTRAP with 1 procedure DBMS_MANAGEMENT_BOOTSTRAP 23-Jan-2017
SYS.DBMS_MASTER_TABLE with 9 procedures and 1 function DBMS_MASTER_TABLE 24-Jan-2017
SYS.DBMS_MDX_ODBO (33 functions + many procs) DBMS_MDX_ODBO TBD
SYS.DBMS_MGWADM (31+) DBMS_MGWADM TBD
SYS.DBMS_MGWMSG (16+) DBMS_MGWMSG TBD
SYS.DBMS_MVIEW_STATS with 3 procedures one with 2 overloads DBMS_MVIEW_STATS 26-Jan-2017
SYS.DBMS_MVIEW_STATS_INTERNAL with 3 procedures one with 2 overloads DBMS_MVIEW_STATS_INTERNAL 06-Feb-2017
SYS.DBMS_PDB_ALTER_SHARING with 7 procedures DBMS_PDB_ALTER_SHARING 24-Feb-2017
SYS.DBMS_PLSQL_CODE_COVERAGE with 6 procedures DBMS_PLSQL_CODE_COVERAGE 03-Feb-2017
SYS.DBMS_PREPLUGIN_BACKUP with 7 new objects DBMS_PREPLUGIN_BACKUP 14-Mar-2017
SYS.DBMS_PROCESS with 3 new procedures DBMS_PROCESS 14-Mar-2017
SYS.DBMS_REGISTRY_EXTENDED with 4 functions, one overloaded DBMS_REGISTRY_EXTENDED 01-Feb-2017
SYS.DBMS_TF with 8 objects, 3 with 2 overloads and 1 with 7 DBMS_TF 20-Mar-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 DBMS_UMF TBD
SYS.DBMS_UMF_INTERNAL with 21 objects DBMS_UMF_INTERNAL TBD
SYS.DBMS_UMF_PROTECTED with 9 objects DBMS_UMF_PROTECTED TBD
SYS.DEBUG_EXTPROC (1) DEBUG_EXTPROC TBD
SEM_APIS () SEM_APIS TBD
SEM_OLS () SEM_OLS TBD
SEM_PERF () SEM_PERF TBD
SEM_RDFCTX () SEM_RDFCTX TBD
SEM_RDFSA () SEM_RDFSA TBD
 
Built-in Packages with New or Removed Functions and Procedures
AS_REPLAY has dropped the END_AS_REPLAY and START_REPLAY procedures AS_REPLAY 21-Nov-2016
CDBVIEW has a new GETLONG function CDBVIEW 29-Jan-2017
DBMS_ADR has dropped CLEANOUT_SCHEMA, DOWNGRADE_SCHEMA, MIGRATE_SCHEMA, and RECOVER_SCHEMA DBMS_ADR 21-Nov-2016
DBMS_ADR has added the new RUN_PURGE and SET_TRACEFILE_IDENTIFIER procedures DBMS_ADR 21-Nov-2016
DBMS_ADR_APP has added the new RUN_PURGE and SET_TRACEFILE_IDENTIFIER procedures DBMS_ADR_APP 21-Nov-2016
DBMS_ADR_INTERNAL has added the new RUN_PURGE and SET_TRACEFILE_IDENTIFIER procedures DBMS_ADR_INTERNAL 21-Nov-2016
DBMS_AUDIT_MGMT has new TRANSFER_UNIFIED_AUIT_RECORDS procedure DBMS_AUDIT_MGMT 27-Oct-2016
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 26-Dec-2016
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_SERVICE_PRVT has new GET_TOPOLOGY and IS_JAVA_SERVICE functions DBMS_SERVICE_PRVT TBD
SYS.DBMS_STATS (17 new objects) DBMS_STATS TBD
 
Built-in Packages with New or Removed Overloads
SYS.DBMS_HPROF.ANALYZE has 2 new overloads, STOP_PROFILING has 1 new overload DBMS_HPROF 22-Dec-2016
??? ??? TBD
 
Built-in Packages with Parameters Changes
DBMS_ADR.SET_LOG_MSG_TEMPLATE and WRITE_LOG have 3 new container database related parameters DBMS_ADR 21-Nov-2016
DBMS_ADR_APP.SET_LOG_MSG_TEMPLATE and WRITE_LOG have 3 new container database related parameters DBMS_ADR_APP 21-Nov-2016
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 TBD
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
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
??? ??? TBD
 
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