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
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_OFFLINE_SNAPSHOT DBMS_OFFLINE_SNAPSHOT 08-Apr-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_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_PACKAGE DBMS_REPCAT_INTERNAL_PACKAGE 18-Apr-2017
DBMS_REPCAT_INTERNAL DBMS_REPCAT_INTERNAL 18-Apr-2017
DBMS_REPCAT_MAS DBMS_REPCAT_MAS 18-Apr-2017
DBMS_REPCAT_MIG DBMS_REPCAT_MIG 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
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 TBD
DBMS_FEATURE_ACFS_ENCR Feature Usage Procedures TBD
DBMS_FEATURE_ACFS_SNAPSHOT Feature Usage Procedures TBD
DBMS_FEATURE_AFD Feature Usage Procedures TBD
DBMS_FEATURE_CLOUD_EHCC Feature Usage Procedures TBD
DBMS_FEATURE_FLEX_ASM Feature Usage Procedures TBD
DBMS_FEATURE_HCCCONV Feature Usage Procedures TBD
DBMS_FEATURE_IMFS Feature Usage Procedures TBD
DBMS_FEATURE_IM_ADO Feature Usage Procedures TBD
DBMS_FEATURE_IM_EXPRESSIONS Feature Usage Procedures TBD
DBMS_FEATURE_IM_FORSERVICE Feature Usage Procedures TBD
DBMS_FEATURE_IM_JOINGROUPS Feature Usage Procedures TBD
DBMS_FEATURE_SHARD Feature Usage Procedures TBD
DBMS_FEATURE_THP Feature Usage Procedures TBD
DBMS_FEATURE_UTILITIES5 Feature Usage Procedures TBD
DBMS_FEATURE_UTILITIES6 Feature Usage Procedures TBD
DBMS_LOGMNR_FFVTOLOGMNRT Feature Usage Procedures TBD
DBMS_PDB_EXEC_SQL Feature Usage Procedures TBD
DBMS_PDB_NUM Feature Usage Procedures TBD
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 27-Apr-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
 
XML and XML
JSON Data Guides JSON Data Guides TBD
 
New Built-in Packages (38)
CDBVIEW_INTERNAL with 1 procedure CDBVIEW_INTERNAL 29-Jan-2017
DBMS_AQADM_VAR with 3 functions DBMS_AQADM_VAR 19-Mar-2017
DBMS_AUDIT_UTIL with 4 functions DBMS_AUDIT_UTIL 18-Mar-2017
DBMS_CRYPTO_INTERNAL with 4 functions DBMS_CRYPTO_INTERNAL 18-Mar-2017
DBMS_DATAPUMP_INT with 5 functions and 2 procedures DBMS_DATAPUMP_INT TBD
DBMS_DBCOMP with 1 procedure DBMS_DBCOMP 18-Mar-2017
DBMS_DISRUPT with 7 procedures DBMS_DISRUPT 18-Mar-2017
DBMS_GOLDENGATE_ADM with 12 objects DBMS_GOLDENGATE_ADM 18-Mar-2017
DBMS_GOLDENGATE_ADM_INTERNAL with 2 procedures DBMS_GOLDENGATE_ADM_INTERNAL TBD
DBMS_GOLDENGATE_ADM_INT_INVOK with 5 procedures DBMS_GOLDENGATE_ADM_INT_INVOK TBD
DBMS_GSM_FIX with 2 procedures DBMS_GSM_FIX TBD
DBMS_GSM_FIXED with 3 procedures and 1 function DBMS_GSM_FIXED TBD
DBMS_HADOOP with 2 procedures DBMS_HADOOP 18-Mar-2017
DBMS_HADOOP_INTERNAL with 1 procedure and 22 functions DBMS_HADOOP_INTERNAL TBD
DBMS_HANG_MANAGER with 1 procedure DBMS_HANG_MANAGER 10-Apr-2017
DBMS_HEAT_MAP_INTERNAL with 6 objects DBMS_HEAT_MAP_INTERNAL TBD
DBMS_HIERARCHY with 2 procedures and 2 functions DBMS_HIERARCHY 11-Apr-2017
DBMS_INMEMORY_ADMIN with 9 objects including 2 moved from DBMS_INMEMORY DBMS_INMEMORY_ADMIN 17-Apr-2017
DBMS_IREFSTATS with 6 procedures DBMS_IREFSTATS TBD
DBMS_ISCHED_REMOTE_ACCESS with 8 objects DBMS_ISCHED_REMOTE_ACCESS TBD
DBMS_JAVASCRIPT with 1 procedure DBMS_JAVASCRIPT 11-Apr-2017
DBMS_JSON with 6 objects DBMS_JSON 30-Oct-2016
DBMS_JSON0 with 2 procedures and 2 functions DBMS_JSON0 11-Apr-2017
DBMS_MANAGEMENT_BOOTSTRAP with 1 procedure DBMS_MANAGEMENT_BOOTSTRAP 13-Apr-2017
DBMS_MASTER_TABLE with 9 procedures and 1 function DBMS_MASTER_TABLE 16-Apr-2017
DBMS_MDX_ODBO (33 functions + many procs) DBMS_MDX_ODBO TBD
DBMS_MVIEW_STATS with 3 procedures one with 2 overloads DBMS_MVIEW_STATS 16-Apr-2017
DBMS_MVIEW_STATS_INTERNAL with 3 procedures one with 2 overloads DBMS_MVIEW_STATS_INTERNAL 16-Apr-2017
DBMS_PDB_ALTER_SHARING with 7 procedures DBMS_PDB_ALTER_SHARING 26-Mar-2017
DBMS_PLSQL_CODE_COVERAGE with 6 procedures DBMS_PLSQL_CODE_COVERAGE 03-Apr-2017
DBMS_PREPLUGIN_BACKUP with 7 new objects DBMS_PREPLUGIN_BACKUP 16-Apr-2017
DBMS_PROCESS with 3 new procedures DBMS_PROCESS 16-Apr-2017
DBMS_TF with 8 objects, 3 with 2 overloads and 1 with 7 DBMS_TF 17-Apr-2017
DBMS_TG_DBG with 1 procedure DBMS_TG_DBG 22-Mar-2017
DBMS_TNS with one procedure DBMS_TNS 07-Feb-2017
DBMS_UMF with 16 objects some overloaded DBMS_UMF 19-Apr-2017
DBMS_UMF_INTERNAL with 21 objects DBMS_UMF_INTERNAL TBD
DBMS_UMF_PROTECTED with 9 objects DBMS_UMF_PROTECTED 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 28-Mar-2017
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 28-Mar-2017
DBMS_ADR has added the new RUN_PURGE and SET_TRACEFILE_IDENTIFIER procedures DBMS_ADR 28-Mar-2017
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_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 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_SERVICE_PRVT has new GET_TOPOLOGY and IS_JAVA_SERVICE functions DBMS_SERVICE_PRVT TBD
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
??? ??? 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