| 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
|
ROLE | 24-Mar-2017 |
New Sysem Privileges
|
SYSTEM PRIVILEGES | 21-Nov-2016 |
New System Users
|
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 |
| 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-2023 Daniel A. Morgan All Rights Reserved | |||||||||
|
||||||||||
