New In Oracle Database Version 12cR2
Version 12.2.0.1

Description Link Last Modified
Architecture
Analytic Views Analytic Views 02-Oct-2016
 
General
New Roles
  • ???
Deprecated Roles
  • ???
ROLE ???
 
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
 
Deprecated or Dropped
??? ??? ???
 
New SQL
??? ??? ???
 
New PL/SQL
??? ??? ???
 
New or Modified Functions, Operators, Procedures, and Types
SYS_CONTEXT has a new SESSION_DEFAULT_COLLATION predefined parameter SYS_CONTEXT 18-Jan-2017
 
XML and XML
JSON Data Guides JSON Data Guides ???
 
New Built-in Packages (23 documented, ## undocumented)
SYS.CDBVIEW_INTERNAL with 1 procedure CDBVIEW_INTERNAL ???
SYS.DBMS_AQADM_VAR with 3 functions DBMS_AQADM_VAR ???
SYS.DBMS_AUDIT_UTIL with 4 functions DBMS_AUDIT_UTIL 12-Jan-2017
SYS.DBMS_CRYPTO_INTERNAL with 4 functions DBMS_CRYPTO_INTERNAL ???
SYS.DBMS_DATAPUMP_INT with 5 functions and 2 procedures DBMS_DATAPUMP_INT ???
SYS.DBMS_DBCOMP with 1 procedure DBMS_DBCOMP 28-Nov-2016
SYS.DBMS_DISRUPT with 7 procedures DBMS_DISRUPT ???
SYS.DBMS_GOLDENGATE_ADM with 12 objects DBMS_GOLDENGATE_ADM ???
SYS.DBMS_GOLDENGATE_ADM_INTERNAL with 2 procedures DBMS_GOLDENGATE_ADM_INTERNAL ???
SYS.DBMS_GOLDENGATE_ADM_INT_INVOK with 5 procedures DBMS_GOLDENGATE_ADM_INT_INVOK ???
SYS.DBMS_GOLDENGATE_ADM_EXP with 1 procedure DBMS_GOLDENGATE_EXP ???
SYS.DBMS_GOLDENGATE_ADM_IMP with 5 procedures DBMS_GOLDENGATE_IMP ???
SYS.DBMS_GSM_FIX with 2 procedures DBMS_GSM_FIX ???
SYS.DBMS_GSM_FIXED with 3 procedures and 1 function DBMS_GSM_FIXED ???
SYS.DBMS_HADOOP with 2 procedures DBMS_HADOOP 29-Dec-2016
SYS.DBMS_HADOOP_INTERNAL with 1 procedure and 22 functions DBMS_HADOOP_INTERNAL ???
SYS.DBMS_HANG_MANAGER with 1 procedure DBMS_HANG_MANAGER 29-Dec-2016
SYS.DBMS_HANG_MANAGER with 5 procedures and 4 functions DBMS_HEAT_MAP_INTERNAL ???
SYS.DBMS_HIERARCHY with 2 procedures and 2 functions DBMS_HIERARCHY ???
SYS.DBMS_HS_PASSTHROUGH (14) DBMS_HS_PASSTHROUGH ???
SYS.DBMS_INMEMORY_ADMIN with 6 objects DBMS_INMEMORY_ADMIN ???
SYS.DBMS_IREFSTATS with 6 procedures DBMS_IREFSTATS ???
SYS.DBMS_ISCHED_REMOTE_ACCESS with 5 procedures and 2 functions DBMS_ISCHED_REMOTE_ACCESS ???
SYS.DBMS_JAVASCRIPT with 1 procedure DBMS_JAVASCRIPT 02-Jan-2017
SYS.DBMS_JSON with 6 objects DBMS_JSON 30-Oct-2016
SYS.DBMS_JSON0 with 2 procedures and 2 functions DBMS_JSON0 ???
SYS.DBMS_MANAGEMENT_BOOTSTRAP with 1 procedure DBMS_MANAGEMENT_BOOTSTRAP ???
SYS.DBMS_MASTER_TABLE with 8 procedures and 1 function DBMS_MASTER_TABLE ???
SYS.DBMS_MDX_ODBO (33 functions + many procs) DBMS_MDX_ODBO ???
SYS.DBMS_MGWADM (31+) DBMS_MGWADM ???
SYS.DBMS_MGWMSG (16+) DBMS_MGWMSG ???
SYS.DBMS_MVIEW_STATS with 3 stored procedures DBMS_MVIEW_STATS ???
SYS.DBMS_MVIEW_STATS_INTERNAL with 3 stored procedures DBMS_MVIEW_STATS_INTERNAL ???
SYS.DBMS_PDB_ALTER_SHARING with 7 procedures DBMS_PDB_ALTER_SHARING ???
SYS.DBMS_PLSQL_CODE_COVERAGE (5) DBMS_PLSQL_CODE_COVERAGE ???
SYS.DBMS_PROCESS (3) DBMS_PROCESS ???
SYS.DBMS_STATS (17 new objects) DBMS_STATS ???
SYS.DBMS_TNS (1) DBMS_TNS ???
SYS.DBMS_UMF (15) DBMS_UMF ???
SYS.DEBUG_EXTPROC (1) DEBUG_EXTPROC ???
SEM_APIS () SEM_APIS ???
SEM_OLS () SEM_OLS ???
SEM_PERF () SEM_PERF ???
SEM_RDFCTX () SEM_RDFCTX ???
SEM_RDFSA () SEM_RDFSA ???
 
Built-in Packages with New or Removed Functions and Procedures
AS_REPLAY has dropped the END_AS_REPLAY and START_REPLAY procedures AS_REPLAY ???
CDBVIEW has a new GETLONG function CDBVIEW 21-Nov-2016
DBMS_ADR has dropped the CLEANOUT_SCHEMA, DOWNGRADE_SCHEMA, MIGRATE_SCHEMA, RECOVER_SCHEMA  procedures 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 ???
DBMS_INMEMORY has new IME_DROP_EXPRESSIONS and SEGMENT_DEALLOCATE_VERSION procedures DBMS_INMEMORY ???
DBMS_INMEMORY has new SET_DEBUG procedure DBMS_METADATA_DPBUILD ???
DBMS_PDB has 8 new procedures and 2 new functions DBMS_PDB 07-Dec-2016
DBMS_SERVICE_PRVT has new GET_TOPOLOGY and IS_JAVA_SERVICE functions DBMS_SERVICE_PRVT ???
 
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
??? ??? ???
 
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 21-Nov-2016
DBMS_ADVISOR.EXECUTE_TASK overload 2 has 2 new parameters DBMS_ADVISOR 09-Nov-2016
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 ???
DBMS_SERVICE_PRVT.STOP_SERVICE 3 new parameters: STOP_OPTION, DRAIN_TIMEOUT, and REPLAY DBMS_SERVICE_PRVT ???
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
??? ??? ???
 
Related Topics
New in 11.2.0.3
New in 12.1.0.1
  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-2016 Daniel A. Morgan All Rights Reserved