New In Oracle Database
Version 12.2

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 Sysem 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
Default Job Queue Processes Parameter set to 4000 Startup Parameters 03-Aug-2017
 
Deprecated or Dropped
DBMSOBJG - 18-Mar-2017
DBMSOBJG2 - 18-Mar-2017
DBMSOBJGWRAPPER - 18-Mar-2017
DBMSOBJG_DP - 18-Mar-2017
DBMS_ASYNCRPC_PUSH - 08-Apr-2017
DBMS_BA - 26-Jun-2017
DBMS_BA_DUMP (shipped with in 12.1.0.2 only) - 26-Jun-2017
DBMS_BA_INT (shipped with 12.1.0.2 only) - 26-Jun-2017
DBMS_BA_POOL (shipped with 12.1.0.2 only ... will be dropped from the library as of version 18.1) - 26-Jun-2017
DBMS_BA_SCHEDULER (shipped with 12.1.0.2 only) - 26-Jun-2017
DBMS_BA_STORAGE (shipped with 12.1.0.2 only) - 26-Jun-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_LIBCACHE (cannot be compiled in 12cR2  ... dropped from the library as of version 18.0) - 26-Jun-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 - 08-Apr-2017
DBMS_OFFLINE_SNAPSHOT_INTERNAL - 24-May-2017
DBMS_OFFLINE_SNA_INTERNAL - 24-May-2017
DBMS_OFFLINE_UTL - 08-Apr-2017
DBMS_RECTIFIER_DIFF - 08-Apr-2017
DBMS_RECTIFIER_DIFF_INTERNAL - 08-Apr-2017
DBMS_RECTIFIER_FRIENDS - 08-Apr-2017
DBMS_REFRESH_EXP_LWM - 24-May-2017
DBMS_REFRESH_EXP_SITES - 24-May-2017
DBMS_REPCAT_ADD_MASTER - 18-Apr-2017
DBMS_REPCAT_ADMIN - 18-Apr-2017
DBMS_REPCAT_AUTH - 18-Apr-2017
DBMS_REPCAT_CACHE - 18-Apr-2017
DBMS_REPCAT_COMMON_UTL - 18-Apr-2017
DBMS_REPCAT_CONF - 18-Apr-2017
DBMS_REPCAT_DECL - 18-Apr-2017
DBMS_REPCAT_DEFINER - 18-Apr-2017
DBMS_REPCAT_EXP - 18-Apr-2017
DBMS_REPCAT_FLA - 18-Apr-2017
DBMS_REPCAT_FLA_MAS - 18-Apr-2017
DBMS_REPCAT_FLA_UTL - 18-Apr-2017
DBMS_REPCAT_INSTANTIATE - 18-Apr-2017
DBMS_REPCAT_INTERNAL - 18-Apr-2017
DBMS_REPCAT_INTERNAL_PACKAGE - 18-Apr-2017
DBMS_REPCAT_MAS - 18-Apr-2017
DBMS_REPCAT_MIGRATION - 18-Apr-2017
DBMS_REPCAT_MIG_INTERNAL - 18-Apr-2017
DBMS_REPCAT_OBJ_UTL - 18-Apr-2017
DBMS_REPCAT_OUTPUT - 18-Apr-2017
DBMS_REPCAT_RGT - 18-Apr-2017
DBMS_REPCAT_RGT_ALT - 18-Apr-2017
DBMS_REPCAT_RGT_CHK - 18-Apr-2017
DBMS_REPCAT_RGT_CUST - 18-Apr-2017
DBMS_REPCAT_RGT_CUST2 - 18-Apr-2017
DBMS_REPCAT_RGT_EXP - 18-Apr-2017
DBMS_REPCAT_RGT_UTL - 18-Apr-2017
DBMS_REPCAT_RPC - 18-Apr-2017
DBMS_REPCAT_RPC_UTL - 18-Apr-2017
DBMS_REPCAT_RQ - 18-Apr-2017
DBMS_REPCAT_SNA - 18-Apr-2017
DBMS_REPCAT_SNA_INTERNAL - 18-Apr-2017
DBMS_REPCAT_SNA_UTL - 18-Apr-2017
DBMS_REPCAT_SQL_UTL - 18-Apr-2017
DBMS_REPCAT_UNTRUSTED - 18-Apr-2017
DBMS_REPCAT_UTL - 18-Apr-2017
DBMS_REPCAT_UTL2 - 18-Apr-2017
DBMS_REPCAT_UTL3 - 18-Apr-2017
DBMS_REPCAT_UTL4 - 18-Apr-2017
DBMS_REPCAT_VALIDATE - 18-Apr-2017
DBMS_REPUTIL2 - 18-Apr-2017
DBMS_SQLPLUS_SCRIPT - 06-May-2017
GV$REPLPROP - 12-Jun-2017
GV$REPLQUEUE - 12-Jun-2017
WWV_DBMS_SQL - 25-May-2017
WWV_FLOW_KEY - 19-Aug-2017
WWV_FLOW_VAL - 19-Aug-2017
XMLROOT Function - 01-Feb-2017
 
New SQL
- - -
 
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 APPROX_COUNT_DISTINCT_AGG 17-Mar-2018
APPROX_COUNT_DISTINCT_DETAIL Function APPROX_COUNT_DISTINCT_DETAIL 17-Mar-2018
APPROX_MEDIAN Function APPROX_MEDIAN 17-Mar-2018
APPROX_PERCENTILE Function APPROX_PERCENTILE 17-Mar-2018
APPROX_PERCENTILE_AGG Function APPROX_PERCENTILE_AGG 17-Mar-2018
APPROX_PERCENTILE_DETAIL Function APPROX_PERCENTILE_DETAIL 17-Mar-2018
COLLATION Function COLLATION 17-Mar-2018
CROSS APPLY Join Clause Join Clause 10-Oct-2017
CROSS OUTER APPLY Join Clause Join Clause 10-Oct-2017
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 17-Mar-2018
JSON_DATAGUIDE Function JSON_DATAGUIDE 20-Oct-2017
NLS_COLLATION_ID Function NLS_COLLATION_ID 17-Mar-2018
NLS_COLLATION_NAME Function NLS_COLLATION_NAME 17-Mar-2018
ORA_DM_PARTITION_NAME Function ORA_DM_PARTITION_NAME TBD
ORA_NAME_LIST_T has been redefined using new 12cR2 syntax DBMS_STANDARD 26-Jun-2017
PERMIT_92_WRAP_FORMAT Compiler Directive Compilation Parameters 03-Mar-2017
ROW_LIMITING Clause SELECT Statement 10-Oct-2017
ROW_PATTERN Clause SELECT Statement 10-Oct-2017
SYS_CONTEXT has a new SESSION_DEFAULT_COLLATION predefined parameter SYS_CONTEXT 18-Jan-2017
TO_APPROX_COUNT_DISTINCT Function TO_APPROX_COUNT_DISTINCT 18-Mar-2018
TO_APPROX_PERCENTILE Function TO_APPROX_PERCENTILE 18-Mar-2018
VALIDATE_CONVERSION Function VALIDATE_CONVERSION 18-Mar-2018
 
Object Rename
DBMS_LOGMNR_SESSION (in 12.1) renamed to DBMS_LOGMNR_SESSION_INT DBMS_LOGMNR_SESSION_INT 24-May-2017
 
XML and JSON
JSON Data Guides JSON Data Guides TBD
 
New or Modified Functions, Operators, Procedures, and Types
TBD ??? TBD
 
New Built-in Packages
CDBVIEW_INTERNAL with 1 procedure CDBVIEW_INTERNAL 24-May-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 and 1 procedure DBMS_CRYPTO_INTERNAL 16-Jul-2017
DBMS_CSX_INT2 with 2 objects DBMS_CSX_INT2 27-May-2017
DBMS_DATAPUMP_INT with 5 functions and 2 procedures DBMS_DATAPUMP_INT 13-May-2017
DBMS_DBCOMP with 1 procedure DBMS_DBCOMP 18-Mar-2017
DBMS_DISRUPT with 7 procedures DBMS_DISRUPT 18-Mar-2017
DBMS_FIX_CONTROL_PERSISTENCE with 4 objects DBMS_FIX_CONTROL_PERSISTENCE 05-Jun-2017
DBMS_GOLDENGATE_ADM with 12 objects DBMS_GOLDENGATE_ADM 12-Jun-2017
DBMS_GOLDENGATE_ADM_INTERNAL with 2 procedures DBMS_GOLDENGATE_ADM_INTERNAL 05-Jun-2017
DBMS_GOLDENGATE_ADM_INT_INVOK with 5 procedures DBMS_GOLDENGATE_ADM_INT_INVOK 25-Dec-2017
DBMS_GOLDENGATE_EXP with 1 object DBMS_GOLDENGATE_EXP 27-Jun-2017
DBMS_GOLDENGATE_IMP with 5 objects DBMS_GOLDENGATE_IMP 27-Jun-2017
DBMS_GSM_FIX with 3 objects DBMS_GSM_FIX 28-Dec-2017
DBMS_GSM_FIXED with 3 procedures and 1 function DBMS_GSM_FIXED 02-Jan-2018
DBMS_GSM_XDB with 1 objects DBMS_GSM_XDB 05-Jan-2018
DBMS_HADOOP with 2 procedures DBMS_HADOOP 18-Mar-2017
DBMS_HADOOP_INTERNAL with 1 procedure and 22 functions DBMS_HADOOP_INTERNAL 23-Jan-2018
DBMS_HANG_MANAGER with 1 procedure DBMS_HANG_MANAGER 10-Apr-2017
DBMS_HEAT_MAP_INTERNAL with 6 objects DBMS_HEAT_MAP_INTERNAL 13-Jun-2017
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 28-Jan-2018
DBMS_ISCHED_REMOTE_ACCESS with 8 objects DBMS_ISCHED_REMOTE_ACCESS -
DBMS_JAVASCRIPT with 1 procedure DBMS_JAVASCRIPT 11-Apr-2017
DBMS_JSON with 12 objects DBMS_JSON 28-Aug-2017
DBMS_JSON0 with 3 procedures and 2 functions DBMS_JSON0 28-Aug-2017
DBMS_JSON_INT with 7 objects DBMS_JSON_INT 17-Oct-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 29-May-2017
DBMS_MDX_ODBO (33 functions + many procs) DBMS_MDX_ODBO -
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_PCLXUTIL_INTERNAL with one procedure DBMS_PCLXUTIL_INTERNAL 22-May-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_PQ_INTERNAL with 1 object DBMS_PQ_INTERNAL 25-May-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_REGISTRY_EXTENDED DBMS_REGISTRY_EXTENDED 01-Mar-2018
DBMS_RLS_INT with 15 objects (prvtrlsa.plb) DBMS_RLS_INT 01-Feb-2018
DBMS_SCHED_CONSTRAINT_EXPORT with 6 objects DBMS_SCHED_CONSTRAINT_EXPORT -
DBSFWUSER.DBMS_SFW_ACL_ADMIN with 30 objects DBMS_SFW_ACL_ADMIN 13-Feb-2018
DBMS_SNAPSHOT_COMMON with 3 objects DBMS_SNAPSHOT_COMMON -
DBMS_SNAPSHOT_KKXRCA with 28 objects many of them with overloads DBMS_SNAPSHOT_KKXRCA -
DBMS_SODA_ADMIN_ with 10 objects DBMS_SODA_ADMIN -
DBMS_SODA_DML with 7 objects DBMS_SODA_DML -
DBMS_SODA_DOM with 16 objects DBMS_SODA_DOM -
DBMS_SODA_UTIL with 11 objects DBMS_SODA_UTIL -
DBMS_SPACE_ALERT with 5 objects DBMS_SPACE_ALERT 25-May-2017
DBMS_STATS_ADVISOR with 73 objects DBMS_STATS_ADVISOR 18-Aug-2017
DBSFWUSER.DBMS_SFW_ACL_ADMIN with 30 objects DBMS_SFW_ACL_ADMIN 07-Jun-2017
DBMS_SYNC_REFRESH_INTERNAL with 18 objects DBMS_SYNC_REFRESH_INTERNAL -
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 19-Aug-2017
DBMS_UMF_PROTECTED with 9 objects DBMS_UMF_PROTECTED 14-May-2017
DBMS_WRR_PROTECTED with 2 functions DBMS_WRR_PROTECTED 02-Feb-2018
DBMS_WRR_STATE an orphan package header DBMS_WRR_STATE 25-May-2017
DBMS_XDB_UTIL with 1 object and 5 overloads DBMS_XDB_UTIL 03-Feb-2018
DRIACCHELP with 6 objects DRIACCHELP 04-Feb-2018
LBAC_EXP with 3 objects LBAC_EXP 29-Apr-2018
LBAC_LGSTNDBY_UTIL with 21 objects LBAC_LGSTNDBY_UTIL -
LTSYS with 114 objects LTSYS -
ORA_DM_REFCUR_PKG an orphan package header ORA_DM_REFCUR_PKG 27-May-2017
ORDERRORINT with 1 object ORDERRORINT 05-Feb-2018
ORD_AUDIO with 3 objects 2 with overloads ORD_AUDIO 12-Feb-2018
ORD_DOC with 3 objects 2 with overloads ORD_DOC -
ORD_IMAGE with 17 objects many with overloads ORD_IMAGE -
OWM_CPKG_PKG with 1 procedure OWM_CPKG_PKG 10-Oct-2017
PRIVATE_JDBC_DR with 1 function PRIVATE_JDBC_DR 08-Nov-2017
PRVTEMX_RSRCMGR PRVTEMX_RSRCMGR -
PRVTEMX_SQL PRVTEMX_SQL 07-May-2018
XDB_METADATA_CONSTANTS XDB_METADATA_CONSTANTS 28-Aug-2017
 
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
CTX_DDL has new ADD_FILTER_SECTION and REMOVE_OVERLAP_DOLLARS objects CTX_DDL 17-May-2017
DBMS_ADR dropped CLEANOUT_SCHEMA, DOWNGRADE_SCHEMA,
MIGRATE_SCHEMA & 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 new RUN_PURGE and SET_TRACEFILE_IDENTIFIER procs DBMS_ADR_APP 28-Mar-2017
DBMS_ADR_INTERNAL has new RUN_PURGE and SET_TRACEFILE_IDENTIFIER procedures DBMS_ADR_INTERNAL 28-Mar-2017
DBMS_AQ has 3 new ..._PAS procedures DBMS_AQ 15-Jul-2017
DBMS_AQADM has 7 new objects DBMS_AQADM 17-Aug-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 15-Jul-2017
DBMS_AWR_REPORT_LAYOUT has 2 new DIFF_EXA_ procedures DBMS_AWR_REPORT_LAYOUT 20-May-2017
DBMS_BACKUP_RESTORE has 25 new functions and procedures DBMS_BACKUP_RESTORE 16-Jul-2017
DBMS_CDC_UTILITY has PURGEMVLOGLOGICAL, PURGEMVLOGPHYSICAL, QCCGSCN removed DBMS_CDC_UTILITY 19-Aug-2017
DBMS_COMPRESSION has new CLEAR_ANALYSIS DBMS_COMPRESSION 19-Aug-2017
DBMS_CSX_ADMIN has 6 new objects DBMS_CSX_ADMIN 01-May-2017
DBMS_DATAPUMP has new GET_OBJECT_INFO, STOP_WORKER, TEST_FUNCTIONALITY objects DBMS_DATAPUMP 22-Aug-2017
DBMS_DBFS_CONTENT has 4 new objects DBMS_DBFS_CONTENT 24-Aug-2017
DBMS_DBFS_CONTENT_ADMIN has 5 new objects DBMS_DBFS_CONTENT_ADMIN 18-Jul-2017
DBMS_DBFS_SFS has 4 new procedures DBMS_DBFS_SFS 27-Aug-2017
DBMS_DNFS has new UNMOUNTVOLUME procedure DBMS_DNFS 12-Dec-2016
DBMS_DRS has 27 new objects several with overloads DBMS_DRS 01-Mar-2018
DBMS_DST has new GET_LATEST_TIMEZONE_VERSION function DBMS_DST 28-Aug-2017
DBMS_GSM_CLOUDADMIN with 7 new objects DBMS_GSM_CLOUDADMIN 05-Jan-2018
DBMS_GSM_DBADMIN with 21 new objects DBMS_GSM_DBADMIN 29-Dec-2017
DBMS_GSM_POOLADMIN with 43 new objects two with overloads DBMS_GSM_POOLADMIN 16-Jan-2018
DBMS_GSM_UTILITY with 31 new objects DBMS_GSM_UTILITY 11-Jan-2018
DBMS_HPROF has new CREATE_TABLES procedure DBMS_HPROF 14-Mar-2018
DBMS_ILM has new FLUSH_COL_STATS procedure DBMS_ILM 26-Sep-2017
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_INTERNAL_CLKM has 1 new objects DBMS_INTERNAL_CLKM 28-Jan-2018
DBMS_INTERNAL_LOGSTDBY has 4 new objects DBMS_INTERNAL_LOGSTDBY 31-Aug-2017
DBMS_INTERNAL_LOGSTDBY has removed CREATE_FUTURE_SESSION
and DESTROY_FUTURE_SESSION objects
DBMS_INTERNAL_LOGSTDBY 31-Aug-2017
DBMS_IREFRESH has new REFGROUP, USER_EXPORT, and USER_EXPORT_CHILD objects DBMS_IREFRESH 28-Jan-2018
DBMS_ISCHED has AGENT_INSTALL_POST_STEPS,  AGENT_INSTALL_PRE_STEPS,
RESET_JOBSUFFIX_SEQ
DBMS_ISCHED 22-Jul-2017
DBMS_LOB has new CLOB2FILE and ISREMOTE objects DBMS_LOB 11-Sep-2017
DBMS_METADATA has new GET_PLSQL_OPTIMIZ_LEVEL and
IS_ACTIVE_REGISTRATION functions
DBMS_METADATA 11-Sep-2017
DBMS_METADATA_DPBUILD has new SET_DEBUG procedure DBMS_METADATA_DPBUILD 24-Jan-2017
DBMS_METADATA_INT has new SET_TRANSFORM_ENGINE procedure DBMS_METADATA_INT 14-Sep-2017
DBMS_PDB has removed REMOVE_LINK and UPDATE_OBJLINK_STATS DBMS_PDB 29-Jun-2018
DBMS_PDB has 8 new procedures and 2 new functions DBMS_PDB 29-Jun-2018
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 25-Jul-2017
DBMS_PRIV_CAPTURE has new SES_HAS_OBJ_PRIV function DBMS_PRIV_CAPTURE 20-Sep-2017
DBMS_PRIV_CAPTURE has dropped 4 HAS_OBJ_PRIV, 3 HAS_ROLE_PRIV,  4 HAS_SYS_PRIV functions DBMS_PRIV_CAPTURE 20-Sep-2017
DBMS_QOPATCH has CONFIG_OINV_JOBS, OPATCH_RUN_JOB, REFRESH_OPATCH_DATA removed DBMS_QOPATCH 25-Jul-2017
DBMS_QOPATCH has 6 new objects DBMS_QOPATCH 25-Jul-2017
DBMS_RCVMAN has 15 new objects DBMS_RCVMAN 24-Jul-2017
DBMS_REDACT has new 4 new objects DBMS_REDACT 21-Sep-2017
DBMS_REDEFINITION_INTERNAL has IS_INDEX_ON_NESTED_TAB function removed DBMS_REDEFINITION_INTERNAL 29-Sep-2017
DBMS_REDEFINITION_INTERNAL has 46 new objects DBMS_REDEFINITION_INTERNAL 29-Sep-2017
DBMS_REPORT has new GET_AWR_DIFF_CONTEXT procedure DBMS_REPORT 03-Oct-2017
DBMS_REPUTIL: All objects removed except REPLICATION_IS_ON, _OFF and _ON DBMS_REPUTIL 08-Apr-2017
DBMS_RESOURCE_MANAGER has new 2 new objects DBMS_RESOURCE_MANAGER 06-Oct-2017
DBMS_RESULT_CACHE has new 4 new objects DBMS_RESULT_CACHE 16-Oct-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 17-Jul-2017
DBMS_SESSION has 5 new objects DBMS_SESSION 30-May-2018
DBMS_SPACE_ADMIN has 2 new procs DBMS_SPACE_ADMIN 26-Oct-2017
DBMS_SPM_INTERNAL has dropped the FETCH_PLAN_INFO and GET_SPM_HINTSET functions DBMS_SPM_INTERNAL 15-Nov-2017
DBMS_SPM_INTERNAL has 18 new objects DBMS_SPM_INTERNAL 15-Nov-2017
DBMS_SQLDIAG has one new procedure with 2 overloads DBMS_SQLDIAG 19-Feb-2018
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_SQLPA has new SET_QUICK_CHECK_TASK function DBMS_SQLPA 27-Oct-2017
DBMS_SQLPATCH has 5 new objects DBMS_SQLPATCH 26-Jul-2017
DBMS_SQLTUNE has 6 new objects DBMS_SQLTUNE 09-Jul-2018
DBMS_SQLTUNE_UTIL0 has 4 new objects DBMS_SQLTUNE_UTIL0 30-Oct-2017
DBMS_SQLTUNE_UTIL1 has 16 new objects DBMS_SQLTUNE_UTIL1 30-Oct-2017
DBMS_SQLTUNE_UTIL2 has 6 new objects DBMS_SQLTUNE_UTIL2 30-Oct-2017
DBMS_SQL_TRANSLATOR has CLEAR_SQL_TRANSLATION_ERROR and SET_DICTIONARY_SQL_ID procedures DBMS_SQL_TRANSLATOR 19-Nov-2017
DBMS_STANDARD has new ORA_MAX_NAME_LEN_SUPPORTED function DBMS_STANDARD 26-Jun-2017
DBMS_STATS has 20 new objects DBMS_STATS 06-Aug-2017
DBMS_STATS_INTERNAL dropped ALTER_COL_TRACKING_LEVEL, EST_SYNOPSIS_SIZE,
GENERATE_GROUP_LEVEL_SYNOPSIS, IS_PARTGRP_ONE_TO_ONE, POPULATE_SYNOPSIS_PARTGRP
DBMS_STATS_INTERNAL 06-Aug-2017
DBMS_STATS_INTERNAL has 96 new objects DBMS_STATS_INTERNAL 06-Aug-2017
DBMS_STREAMS has new COMPATIBLE_12_2 function DBMS_STREAMS 04-Jun-2017
DBMS_STREAMS_ADM has new DELETE_REPLICATION_EVENTS procedure DBMS_STREAM_ADM 03-Nov-2017
DBMS_SWRF_INTERNAL dropped the CREATE_SYSAWR_USER and GRANT_PRIV_STAGING_SCHEMA procedures DBMS_SWRF_INTERNAL 10-Nov-2017
DBMS_SWRF_INTERNAL has new DEFAULT_REPORT_DBID, REMOVE_ADDM_TASKS, RESET_AWR, and VALIDATE_AWR_LOCATION objects DBMS_SWRF_INTERNAL 10-Nov-2017
DBMS_SYSTEM has new GET_OBH function DBMS_SYSTEM 14-Nov-2017
DBMS_SYS_SQL has BIND_VARIABLE_PKG and VARIABLE_VALUE_PKG procedures DBMS_SYS_SQL 15-Nov-2017
DBMS_TF contains 11 new objects DBMS_TF 12-Apr-2018
DBMS_TTS has new CONVERTENCRYPTEDDATAFILECOPY and GET_AFN_IDBXENDIAN procedures DBMS_TTS 12-Aug-2017
DBMS_UTILITY has new INIT_NUMBER_ARRAY function DBMS_UTILITY 03-Sep-2017
DBMS_WLM has new 5 new objects DBMS_WLM 08-Aug-2017
DBMS_WORKLOAD_CAPTURE has 5 new objects DBMS_WORKLOAD_CAPTURE 19-May-2018
DBMS_WORKLOAD_REPLAY has 6 new objects DBMS_WORKLOAD_REPLAY 19-May-2018
DBMS_WRR_INTERNAL drops the INVOKE_GET_PATH function and gains 15 new objects DBMS_WRR_INTERNAL 12-Nov-2017
DBMS_XDB_ADMIN drops 6 objects DBMS_XDB_ADMIN 20-Nov-2017
DBMS_XDB_CONFIG contains 8 new objects DBMS_XDB_CONFIG 17-Aug-2017
DBMS_XPLAN has 2 new objects DBMS_XPLAN 23-May-2018
DBMS_XSTREAM_AUTH_IVK contains 3 new objects DBMS_XSTREAM_AUTH_IVK 12-Dec-2017
DBMS_XSTREAM_GG contains 3 new objects DBMS_XSTREAM_GG 13-Dec-2017
DM_QGEN drops the GI_GEN, CI_GEN, LS_APPEND, and LS_PREPEND objects DM_QGEN 13-Dec-2017
DM_QGEN  adds EXT_QUOTE, SQLN2BND, SQLN2LIT, SQLN2QSQL, and SQLN2SQL objects DM_QGEN 13-Dec-2017
KUBSAFT has new DESCRIBE_VERSION function KUBSAGT 06-Jul-2018
KUPP$PROC has new 5 new objects and SET_DEBUG is dropped KUPP$PROC 13-Aug-2017
PRVTEMX_ADMIN has new REPORT_ALTER_TBS_INMEMORY_XML and REPORT_DBSEARCH_XML functions PRVTEMX_ADMIN 14-Aug-2017
PRVTEMX_CELL has new REPORT_CELL_DIFF and REPORT_CELL_DIFF_XML functions PRVTEMX_CELL 14-Aug-2017
UTL_CALL_STACK has 2 new functions UTL_CALL_STACK 03-Aug-2018
UTL_HTTP has new UTL_RAW_PTR function UTL_HTTP 03-Aug-2018
UTL_I18N has new VALIDATE_CARACTER_ENCODING function UTL_I18N 27-Jul-2018
WM_ERROR has new GETERRORSTR function WM_ERROR 27-Jun-2017
XS_ADMIN_UTIL has new VALIDATE_DB_USER procedure XS_ADMIN_UTIL 26-Jul-2018
XS_PRINCIPAL has new SET_ACL procedure XS_PRINCIPAL 23-Jul-2018
 
Built-in Packages with New or Removed Overloads
DBMS_DATAPUMP.GET_STATUS has 1 new overload DBMS_DATAPUMP 22-Aug-2017
DBMS_GSM_DBADMIN.ADDDATABASE has 1 new overload DBMS_GSM_DBADMIN 29-Dec-2017
DBMS_GSM_UTILITY.GENERATECHANGELOGENTRY has a new overload DBMS_GSM_UTILITY 11-Jan-2018
DBMS_HPROF ANALYZE has 2 new overloads, START_PROFILING has 1 DBMS_HPROF 14-Mar-2018
DBMS_RCVMAN has new overloads in GETRESTOREPOINT, LISTGETRESTOREPOINT, LISTGETTABLESPACE DBMS_RCVMAN 24-Jul-2017
DBMS_SQLTUNE.CREATE and SCHEDULE _TUNING TASK have 1 new overload each DBMS_SQLTUNE 09-Jul-2018
DBMS_TF.GET_ROW_SET has a new overload DBMS_TF 12-Apr-2018
DBMS_XPLAN.DISPLAY_CURSOR has 2 new overoads DBMS_XPLAN 23-May-2018
XS_PRINCIPAL.GRANT_ROLES has a new overload XS_PRINCIPAL 23-Jul-2018
 
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_COMPRESSION has new GET_COMPRESSION_TYPE parameter DBMS_COMPRESSION 16-Dec-2017
DBMS_CONNECTION_POOL.CONFIGURE_POOL has 1 new parameters DBMS_CONNECTION_POOL 17-Nov-2016
DBMS_DISRUPT has new parameter defaults and USER_NAMES added to disrupt_sessions DBMS_DISTRUPT 04-Jun-2018
DBMS_DST.FIND_AFFECTED_TABLES has new PARALLEL parameter DBMS_DST 04-Jun-2018
DBMS_GSM_CLOUDADMIN.ADDVNCR has one new overload DBMS_GSM_CLOUDADMIN 05-Jan-2018
DBMS_METADATA.SET_TRANSFORM_PARAM, all overloads, has new FLAGS parameter and many new constants DBMS_METADATA 11-Sep-2017
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 17-Jul-2017
DBMS_SNAPSHOT has new parameters in a number of objects DBMS_SNAPSHOT 26-May-2017
DBMS_SYS_SQL has 29 new overloads as part of a number of package objects DBMS_SYS_SQL 15-Nov-2017
DBMS_XPLAN.PREPARE_RECORDS has 4 new parameters DBMS_XPLAN 23-May-2018
UTL_TCP.SECURE_CONNECTION has new SECURE_HOST parameter UTL_TCP 12-Jan-2017
XS_ADMIN_UTIL.GRANT_SYSTEM_PRIVILEGE has new parameter XS_ADMIN_UTIL 26-Jul-2018
XS_ADMIN_UTIL.REVOKE_SYSTEM_PRIVILEGE has new parameter XS_ADMIN_UTIL 26-Jul-2018
XS_PRINCIPAL has new ACL parameter in 2 objects XS_PRINCIPAL 23-Jul-2018
 
Built-in Packages with new Constants, Exceptions, Types, and other significant changes
DBMS_DATAPUMP has new KU$_STATUS_VERSION_5 and 5 new KU$_DATAOPT constants DBMS_DATAPUMP 22-Aug-2017
DBMS_DB_VERSION has new VER_LE_18 constant DBMS_DB_VERSION 04-Jun-2018
DBMS_DISRUPT has new all_users, cur_instance, and cur_user constants DBMS_DISTRUPT 04-Jun-2018
DBMS_FBT uses a redefined FLASHBACKTBLIST type DBMS_FBT 06-Jun-2018
DBMS_HEAT_MAP has new data types DBMS_HEAT_MAP 13-Jun-2017
DBMS_ILM has new ILM_ALL_EXECUTIONS constant DBMS_ILM 17-Dec-2017
DBMS_REDACT has new 17 new constants DBMS_REDACT 21-Sep-2017
DBMS_SQLTUNE_UTIL0 has new constants and data type DBMS_SQLTUNE_UTIL0 30-Oct-2017
DBMS_STANDARD has new ORA_MAX_NAME_LEN constant DBMS_STANDARD 26-Jun-2017
DBMS_TF has multiple new constants and types DBMS_TF 12-Apr-2018
DBMS_XPLAN.DISPLAY_CURSOR has new num_tab_type type DBMS_XPLAN 23-May-2018
MGMT_DB_LL_METRICS has new VERSION_12gR2 constant MGMT_DB_LL_METRICS 23-Jul-2018
ODCICONST has 3 new IndexInfoFlag constants ODCICONST 13-Jul-2018
XS_ADMIN_UTIL has 6 new constants and 4 new exceptions XS_ADMIN_UTIL 26-Jul-2018
 
Related Topics
New in 11.2
New in 12.1
New in 18c
New in 19c
New in 20c
New in 21c
  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-2021 Daniel A. Morgan All Rights Reserved
  DBSecWorx