New In Oracle Database Versions 20c and 21c |
---|
Description | Link | Last Modified |
General | ||
Version 20c was only released in the Oracle Cloud Version 21.1 was only released in the Oracle Cloud - it was, in everything except name, the final beta Version 21.2 was released as the first version of the Oracle 21c Autonomous Database Version 21.3 was the first Generally Available (GA) release |
||
Architecture | ||
Legacy, non-container architecture fully desupported | - | 29-Feb-2020 |
Attention Log | Attention Log | 19-Jan-2021 |
Persistent Memory Database and FileStore | Persistent Memory DB | 17-Apr-2020 |
SecureFile Defragmentation | SecureFiles | 28-Mar-2020 |
DRnn Background Process Dropped | Background Processes | 12-Nov-2020 |
New MZnn Background Process Added | Background Processes | 12-Nov-2020 |
New
|
- | 20-Dec-2020 12-Dec-2020 |
Security | ||
Force upgraded password files to be case sensitive | - | 07-Mar-2020 |
DBMS_CRYPTO support for asymmetric key operations | - | - |
Database clients can be configured to maintain multiple SSL sessions using different certificates | - | 07-Mar-2020 |
PASSWORD_ROLLOVER_TIME added to PROFILE | Profiles | 26-Dec-2020 |
STIG compliant Unified Audit Policies are predefined | - | 07-Mar-2020 |
Support for centrally managed wallets | - | 07-Mar-2020 |
USER_APPLICATION_ROLES view enhanced to show roles granted | - | 07-Mar-2020 |
General | ||
New Users
|
USERS | 26-Dec-2020 |
New Roles
|
ROLES | 31-Dec-2020 |
New System Privileges
|
SYSTEM PRIVILEGES | 10-Jan-2021 |
New Data Dictionary Objects
|
- | - |
New Dynamic Performance Views
|
Dynamic Performance Views | 28-Dec-2020 |
New Object Privileges
|
- | 02-Jan-2021 |
New Hints
|
- | - |
New Initialization Parameters
|
Startup Parameters | 30-Dec-2020 |
New Built-In Packages
|
Built-In Packages | 12-Jun-2021 |
Other Deprecated or Dropped Objects | ||
TBD | - | |
Object Types and Features | ||
New
|
BlockChain Tables Immutable Tables Data Types DBMS_AQADM |
24-Aug-2021 24-Aug-2021 30-Jun-2021 06-Feb-2021 06-Feb-2021 06-Feb-2021 |
New SQL | ||
EXCEPT Set Operator | Oracle Operators | 25-Mar-2020 |
INTERSECT ALL Set Operator | Oracle Operators | 25-Mar-2020 |
MINUS ALL Set Operator | Oracle Operators | 25-Mar-2020 |
ORA_SHARDSPACE_NAME Pseudocolumn | Pseudocolumns | 19-Jun-2021 |
Process Identifier (PID) userenv Constant | SYS_CONTEXT | 27-Mar-2020 |
SQL Macros | SQL Macros | 04-Jan-2021 |
PL/SQL Changes | ||
SQL Macros | SQL Macros | 04-Jan-2021 |
FOR LOOP Enhancement | Control Structures | 08-Jan-2021 |
New PL/SQL Informational Warning Messages (06027, 06028, 06029) | PL/SQL Warnings | 01-Jan-2021 |
New PL/SQL Severe Warning Messages (05026, 05027, 05028, 05029) | PL/SQL Warnings | 01-Jan-2021 |
Dropping PLW-07202 was announced in version 12.2 but was not done until 20c | PL/SQL Warnings | 01-Jan-2021 |
New Pragma SUPPRESS_WARNING_6009 | PRAGMAS | 01-Jan-2021 |
New or Modified Functions, Operators, Procedures, and Types | ||
AVTUNE_LOG_LISTAGGCLOB$ | SYS Owned Functions | 02-Jan-2021 |
DBMS_FEATURE_APPROX_QP | DBMS_FEATURE Procedures | 08-Dec-2020 |
DBMS_FEATURE_HCS | DBMS_FEATURE Procedures | 26-Dec-2020 |
DBMS_FEATURE_IM_BASE_LEVEL | DBMS_FEATURE Procedures | 08-Dec-2020 |
DBMS_FEATURE_SEHA | DBMS_FEATURE Procedures | 26-Dec-2020 |
DG$GETFLATDG Dropped | SYS Owned Functions | 02-Jan-2021 |
GET_SUPPORT_MODE | SYS Owned Functions | 02-Jan-2021 |
GET_SUPPORT_REASON | SYS Owned Functions | 02-Jan-2021 |
JSON$CHECK_EXPR | SYS Owned Functions | 02-Jan-2021 |
IS NOT NULL | JSON Functions | 30-Jun-2021 |
IS NULL | JSON Functions | 30-Jun-2021 |
JSON_EQUAL | JSON Functions | 30-Jun-2021 |
JSON_SCALAR | JSON Functions | 30-Jun-2021 |
JSON_SERIALIZE | JSON Functions | 30-Jun-2021 |
KCISYS_BITMAPAGG | SYS Owned Functions | 02-Jan-2021 |
KCISYS_CATRSIAGG | SYS Owned Functions | 02-Jan-2021 |
KCISYS_RSIAGG | SYS Owned Functions | 02-Jan-2021 |
ONAME | SYS Owned Functions | 02-Jan-2021 |
PNAME | SYS Owned Functions | 02-Jan-2021 |
SPATIALACTIVE | SYS Owned Functions | 02-Jan-2021 |
SYS_CONTEXT TLS_VERSION | SYS_CONTEXT | 01-Apr-2022 |
TKHCS_LOG_LISTAGGCLOB | SYS Owned Functions | 02-Jan-2021 |
VERIFY_FUNCTION Dropped | SYS Owned Functions | 02-Jan-2021 |
VERIFY_FUNCTION_11G Dropped | SYS Owned Functions | 02-Jan-2021 |
Renamed Objects | ||
None Identified So Far | - | - |
New or Modified Functions, Operators, Procedures, and Types | ||
ANY_VALUE | ANY_VALUE | 06-Nov-2020 |
Changes to JSON, SODA and XML | ||
TBD | - | - |
New Built-in Packages | ||
DBFS_OFS_CONVERSION | DBFS_OFS_CONVERSION | 12-Dec-2020 |
DBMS_ACTIVITY | DBMS_ACTIVITY | 13-Dec-2020 |
DBMS_ADBTASK_ADMIN | DBMS_ADBTASK_ADMIN | 12-Dec-2020 |
DBMS_APP_CONT_REPORT | DBMS_APP_CONT_REPORT | 14-Dec-2020 |
DBMS_AQ_IND_MON | DBMS_AQ_IND_MON | 12-Dec-2020 |
DBMS_AQ_SUB | DBMS_AQ_SUB | 12-Dec-2020 |
DBMS_AUDIT_MGMT_SUPPORT | DBMS_AUDIT_MGMT_SUPPORT | 24-Aug-2021 |
DBMS_AUTO_MV | DBMS_AUTO_MV | 13-Dec-2020 |
DBMS_AUTO_SQLSET | DBMS_AUTO_SQLSET | 12-Dec-2020 |
DBMS_AUTO_ZONEMAP | DBMS_AUTO_ZONEMAP | 12-Dec-2020 |
DBMS_AUTO_ZONEMAP_INTERNAL | DBMS_AUTO_ZONEMAP_INTERNAL | 12-Dec-2020 |
DBMS_AVTUNE | DBMS_AVTUNE | 17-Dec-2020 |
DBMS_AVTUNE_UTIL | DBMS_AVTUNE_UTIL | 17-Dec-2020 |
DBMS_AWRHUB | DBMS_AWRHUB | 16-Dec-2020 |
DBMS_AWRHUB_SERVER | DBMS_AWRHUB_SERVER | 16-Dec-2020 |
DBMS_AWRHUB_SOURCE | DBMS_AWRHUB_SOURCE | 16-Dec-2020 |
DBMS_AWR_ANALYTICS | DBMS_AWR_ANALYTICS | 27-Dec-2020 |
DBMS_BLOCKCHAIN_TABLE | DBMS_BLOCKCHAIN_TABLE | 27-Dec-2020 |
DBMS_BLOCKCHAIN_UTL | DBMS_BLOCKCHAIN_UTL | 27-Dec-2020 |
DBMS_CLOUD | DBMS_CLOUD | 22-Aug-2021 |
DBMS_CLOUD_ADMIN | DBMS_CLOUD_ADMIN | 12-Mar-2023 |
DBMS_CLOUD_ADMIN_INTERNAL | DBMS_CLOUD_ADMIN_INTERNAL | 12-Mar-2023 |
DBMS_CLOUD_CAPABILITY | DBMS_CLOUD_CAPABILITY | 22-Aug-2021 |
DBMS_CLOUD_CORE | DBMS_CLOUD_CORE | 22-Aug-2021 |
DBMS_CLOUD_INTERNAL | DBMS_CLOUD_INTERNAL | 22-Aug-2021 |
DBMS_CLOUD_MACADM | DBMS_CLOUD_MACADM | 22-Aug-2021 |
DBMS_CLOUD_REQUEST | DBMS_CLOUD_REQUEST | 22-Aug-2021 |
DBMS_CLOUD_TASK | DBMS_CLOUD_TASK | 22-Aug-2021 |
DBMS_CLOUD_TYPES | DBMS_CLOUD_TYPES | 22-Aug-2021 |
DBMS_CUBE_PRVTEXP | DBMS_CUBE_PRVTEXP | 17-Dec-2020 |
DBMS_DLM | DBMS_DLM | 27-Dec-2020 |
DBMS_EDITIONS_UTILITIES2 | DBMS_EDITIONS_UTILITIES2 | 24-Aug-2021 |
DBMS_FLASHBACK_ARCHIVE_MIGRATE | DBMS_FLASHBACK_ARCHIVE_MIGRATE | 13-Dec-2020 |
DBMS_GSM_DDL | DBMS_GSM_DDL | 06-Dec-2020 |
DBMS_GSM_SEC | DBMS_GSM_SEC | 06-Dec-2020 |
DBMS_HCS_LOG | DBMS_HCS_LOG | 17-Dec-2020 |
DBMS_IMMUTABLE_TABLE | DBMS_IMMUTABLE_TABLE | 20-Aug-2021 |
DBMS_MAINTPLAN | DBMS_MAINTPLAN | 19-Dec-2020 |
DBMS_MAX_STRING_SIZE | DBMS_MAX_STRING_SIZE | 05-Jan-2021 |
DBMS_MDX_UTIL | DBMS_MDX_UTIL | 22-Dec-2020 |
DBMS_MLE | DBMS_MLE | 21-Mar-2021 |
DBMS_OPTIM_BUNDLE | DBMS_OPTIM_BUNDLE | 06-Jan-2021 |
DBMS_PQDIAG | DBMS_PQDIAG | 06-Jan-2021 |
DBMS_REPLAYHUB | DBMS_REPLAYHUB | 19-Feb-2021 |
DBMS_XMLSCHEMA_UTIL | DBMS_XMLSCHEMA_UTIL | 03-Jul-2021 |
DBMS_SWAT | DBMS_SWAT | 13-Dec-2020 |
DBMS_SWAT_ARM_INTERNAL | DBMS_SWAT_ARM_INTERNAL | 31-Dec-2020 |
DBMS_SWAT_INTERNAL | DBMS_SWAT_INTERNAL | 23-Dec-2020 |
DBMS_SWAT_MM_INTERNAL | DBMS_SWAT_MM_INTERNAL | 06-Jan-2021 |
DBMS_SWAT_MM_UTILS | DBMS_SWAT_MM_UTILS | 07-Jan-2021 |
DBMS_SWAT_VER_INTERNAL | DBMS_SWAT_VER_NTERNAL | 28-Dec-2020 |
DBMS_SYS_MLE | DBMS_SYS_MLE | 20-Dec-2020 |
DBMS_TABLE_DATA | DBMS_TABLE_DATA | 27-Dec-2020 |
DBMS_TEQK | DBMS_TEQK | 24-Dec-2020 |
DBMS_TSDP_PROTECT_INT | DBMS_TSDP_PROTECT_INT | 24-Dec-2020 |
DBMS_USER_CERTS | DBMS_USER_CERTS | 27-Dec-2020 |
DBMS_WRR_STATE_BASE (present in 21.1 but dropped in 21.3) | DBMS_WRR_STATE_BASE | 23-Dec-2020 |
LBAC_POLICY_ADMIN_INT | LBAC_POLICY_ADMIN_INT | 21-Dec-2020 |
LTI | LTI | 30-Dec-2020 |
REDO_DIFF | REDO_DIFF | 24-Aug-2021 |
SA_USER_ADMIN_INT | SA_USER_ADMIN_INT | 05-Jan-2021 |
TKHCS_LOG_PKG | TKHCS_LOG_PKG | 24-Aug-2021 |
UTL_RECOMP2 | UTL_RECOMP2 | 23-Aug-2021 |
Built-in Packages with New or Removed Objects | ||
CTX_DOC.FUNC_EVAL and .QUERY_IMCU removed | CTX_DOC | 03-Dec-2021 |
DBMS_APP_CONT_ADMIN has 5 new objects | DBMS_APP_CONT_ADMIN | 14-Dec-2020 |
DBMS_AQ has new SEEK procedure | DBMS_AQ | 08-Nov-2021 |
DBMS_AQADM_SYS has new AQTM_PARAM_CHK, ISTRANSACTIONALEVENTQUEUE, ISTXNEVENTQUEUE, and VERIFY_TRANSACTIONAL_EVENT_QUEUE objects | DBMS_AQADM_SYS | 08-Nov-2021 |
DBMS_AQADM has 6 new objects, 5 related to Transactional Event Queues | DBMS_AQADM | 06-Feb-2021 |
DBMS_ASH has new FETCH_OBJ_NAME and FETCH_SQLTEXT objects | DBMS_ASH | 29-Jan-2021 |
DBMS_ASH has FETCH_OBJ_NAME_AWR and 3 other objects removed | DBMS_ASH | 29-Jan-2021 |
DBMS_ASSERT has new SIMPLE_SQL_NAME_LIST function | DBMS_ASSERT | 07-Dec-2020 |
DBMS_AUDIT_MGMT_LSBY has 10 new objects | DBMS_AUDIT_MGMT_LSBY | 29-Jan-2021 |
DBMS_AUTOTASK_PRVT has new REQUEST_GRACE_PERIOD function | DBMS_AUTOTASK_PRVT | 29-Jan-2021 |
DBMS_AUTO_INDEX has new DROP_AUTO_INDEXES procedure | DBMS_AUTO_INDEX | 29-Jan-2021 |
DBMS_AUTO_INDEX_INTERNAL has 4 new objects | DBMS_AUTO_INDEX_INTERNAL | 11-Feb-2021 |
DBMS_AW dropped 3 ..._ACCESS_TRACKING objects | DBMS_AW | 12-Feb-2021 |
DBMS_AW_EXP has new LOB_WRITEAPPEND object with 2 overloads | DBMS_AW_EXP | 03-Dec-2021 |
DBMS_AW_INTERNAL has 4 new objects | DBMS_AW_INTERNAL | 12-Feb-2021 |
DBMS_BACKUP_RESTORE has 5 new objects | DBMS_BACKUP_RESTORE | 23-Feb-2021 |
DBMS_BLOCKCHAIN_TABLE has 4 new objects | DBMS_BLOCKCHAIN_TABLE | 27-Dec-2020 |
DBMS_BLOCKCHAIN_UTL has new IS_COPIER object | DBMS_BLOCKCHAIN_UTL | 27-Dec-2020 |
DBMS_CLOUD has 11 new objects | DBMS_CLOUD | 14-Dec-2020 |
DBMS_CRYPTO has new PKDECRYPT, PKENCRYPT, SIGN and VERIFY objects | DBMS_CRYPTO | 18-Feb-2021 |
DBMS_CRYPTO_FFI has new PKDECRYPT, PKENCRYPT, SIGN and VERIFY objects | DBMS_CRYPTO_FFI | 18-Feb-2021 |
DBMS_CUBE has new IMPORT_XML_BLOB procedure | DBMS_CUBE | 19-Feb-2021 |
DBMS_CUBE_LOG has new TABLE_DROP and TABLE_TRUNCATE procedures | DBMS_CUBE_LOG | 19-Feb-2021 |
DBMS_DBFS_CONTENT has 5 new objects | DBMS_DBFS_CONTENT | 14-May-2021 |
DBMS_DBFS_HS dropped UNLOCKPATH procedure | DBMS_DBFS_HS | 14-May-2021 |
DBMS_DBFS_SFS has 25 new objects | DBMS_DBFS_SFS | 14-May-2021 |
DBMS_DBFS_SFS_ADMIN has new NEWIDAUX object | DBMS_DBFS_SFS_ADMIN | 14-May-2021 |
DBMS_DRS has 37 new objects | DBMS_DRS | 24-Feb-2021 |
DBMS_EDITIONS_UTILITIES has new ACTUALIZE_ALL procedure | DBMS_EDITIONS_UTILITIES | 24-Feb-2021 |
DBMS_FUSE has new FS_MKSOC function with 3 overloads | DBMS_FUSE | 28-Feb-2021 |
DBMS_GSM_FIX has 12 new objects | DBMS_GSM_FIX | 04-Mar-2021 |
DBMS_GSM_FIXED has 4 new objects | DBMS_GSM_FIXED | 04-Mar-2021 |
DBMS_GSM_POOLADMIN has 11 new objects | DBMS_GSM_POOLADMIN | 05-Mar-2021 |
DBMS_GSM_UTILITY has 8 new objects | DBMS_GSM_UTILITY | 05-Mar-2021 |
DBMS_GSM_SEC has new PUTCATUSER procedure | DBMS_GSM_SEC | 19-Jan-2021 |
DBMS_HADOOP_INTERNAL has new EVAL_PART_KEY_OPERATOR procedure | DBMS_HADOOP_INTERNAL | 07-Mar-2021 |
DBMS_HADOOP_INTERNAL dropped 3 objects | DBMS_HADOOP_INTERNAL | 07-Mar-2021 |
DBMS_HIERARCHY has 3 new objects | DBMS_HIERARCHY | 08-Mar-2021 |
DBMS_INDEX_UTL has new GET_REORG_INDEX_ACTION procedure | DBMS_INDEX_UTL | 09-Mar-2021 |
DBMS_INTERNAL_ROLLING has new IS_PLSQL_PRAGMA procedure | DBMS_INTERNAL_ROLLING | 10-Mar-2021 |
DBMS_IR has new UPDATEFEASABILITYANDIMPACT procedure | DBMS_IR | 11-Mar-2021 |
DBMS_ISCHED has new CREATE_CLOUD_CREDENTIAL and RESOLVE3_NAME objects | DBMS_ISCHED | 11-Mar-2021 |
DBMS_ISCHED dropped DEFINE_CHAIN_RULE and DEFINE_CHAIN_STEP objects | DBMS_ISCHED | 11-Mar-2021 |
DBMS_I_INDEX_UTL has new I_ANALYZE_INDEX and I_COMPUTE_ACTION objects | DBMS_I_INDEX_UTL | 13-Feb-2021 |
DBMS_JSON has new BLOB_TO_JSON, GATHER_STATS, and GET_VIEW_SQL objects | DBMS_JSON | 14-Mar-2021 |
DBMS_JSON0 has new CHECKPK and GETMAXVCSIZE objects | DBMS_JSON0 | 14-Mar-2021 |
DBMS_JSON_INT has new BLOB2JSON procedure | DBMS_JSON_INT | 14-Mar-2021 |
DBMS_LOGMNR.INIT_REPLCATION_METADATA dropped | DBMS_LOGMNR | 14-Mar-2021 |
DBMS_LOB LOADFROMFILE and LOB new buffering support | DBMS_LOB | 22-Dec-2020 |
DBMS_MACADM has new ALLOW_COMMON_OPERATION procedure | DBMS_MACADM | 25-Dec-2021 |
DBMS_MACUTL has new GET_ACO_STATUS function | DBMS_MACUTL | 26-Dec-2021 |
DBMS_METADATA_UTIL has new IS_SHARD_TBL_IN_SHARD_CATALOG function | DBMS_METADATA_UTIL | 20-Mar-2021 |
DBMS_ODCI has UPGRADE_SECOBJ procedure removed | DBMS_ODCI | 24-Mar-2021 |
DBMS_PARALLEL_EXECUTE_INTERNAL has 4 new objects | DBMS_PARALLEL_EXECUTE_INTERNAL | 24-Mar-2021 |
DBMS_PLSQL_CODE_COVERAGE has new GET_BLOCK_MAP function | DBMS_PLSQL_CODE_COVERAGE | 22-Dec-2020 |
DBMS_PLUGTS has new KCP_SETPIRENA procedure | DBMS_PLUGTS | 28-Mar-2021 |
DBMS_PREUP dropped 20 objects from 19c and added 14 new objects | DBMS_PREUP | 29-Mar-2021 |
DBMS_RCVCAT has 26 new objects, drops ISTRANSLATEDPDBID, KTRANSLATEPDBNAME | DBMS_RCVCAT | 31-Mar-2021 |
DBMS_RCVMAN has 13 new objects | DBMS_RCVMAN | 31-Mar-2021 |
DBMS_RCVVPC has 8 new objects | DBMS_RCVVPC | 02-Apr-2021 |
DBMS_REDACT_INT dropped 3 "POLICY_DESCRIPTIONS" objects | DBMS_REDACT_INT | 30-Sep-2021 |
DBMS_REDEFINITION_INTERNAL has 9 new objects | DBMS_REDEFINITION_INTERNAL | 04-Apr-2021 |
DBMS_REGISTRY dropped 2 objects | DBMS_REGISTRY | 07-Apr-2021 |
DBMS_REGISTRY_SYS has 2 new objects | DBMS_REGISTRY_SYS | 18-Dec-2020 |
DBMS_RESULT_CACHE has 7 new objects | DBMS_RESULT_CACHE | 10-Apr-2021 |
DBMS_SMB_INTERNAL has new INIT_SMB_PARAMETER procedure | DBMS_SMB_INTERNAL | 21-Apr-2021 |
DBMS_SODA has 12 new objects | DBMS_SODA | 22-Apr-2021 |
DBMS_SODA_ADMIN has 11 new objects | DBMS_SODA_ADMIN | 08-Aug-2021 |
DBMS_SODA_DML has 3 new objects | DBMS_SODA_DML | 08-Aug-2021 |
DBMS_SODA_UTIL dropped CHECKANDGETCOMPAT and ISJDCS | DBMS_SODA_UTIL | 28-Aug-2021 |
DBMS_SODA_UTIL added GETSERVICENAME and LIST_USAGE_STATISTICS | DBMS_SODA_UTIL | 28-Aug-2021 |
DBMS_SPM_INTERNAL has 6 new objects and dropped LOAD_AUTO_EVOLVE_TASK_CONFIG | DBMS_SPM_INTERNAL | 22-Apr-2021 |
DBMS_SQADM_SYSCALLS has 2 new objects | DBMS_SQADM_SYSCALLS | 22-Apr-2021 |
DBMS_SQLCONTROL_INTERNAL renamed by prefix dropping all four previously existing objects | DBMS_SQLCONTROL_INTERNAL | 22-Apr-2021 |
DBMS_SQLCONTROL_INTERNAL added new GET_OBJECT_NAME procedure | DBMS_SQLCONTROL_INTERNAL | 22-Apr-2021 |
DBMS_SQLPATCH has new VERIFY_QUERYABLE_INVENTORY function | DBMS_SQLPATCH | 24-Apr-2021 |
DBMS_SQLQ_INTERNAL procedures renamed to drop I_ prefix and 4 objects dropped | DBMS_SQLQ_INTERNAL | 24-Apr-2021 |
DBMS_SQLQ_INTERNAL.CREATE_QUARANTINE_BY_TEXT renamed to _BY_SQLTEXT | DBMS_SQLQ_INTERNAL | 24-Apr-2021 |
DBMS_SQLTCB_INTERNAL has new FIXQ object | DBMS_SQLTCB_INTERNAL | 19-Mar-2021 |
DBMS_SQLTUNE has1 has 1 new object | DBMS_SQLTUNE | 27-Apr-2021 |
DBMS_SQLTUNE_UTIL0 has 1 new object | DBMS_SQLTUNE_UTIL0 | 27-Apr-2021 |
DBMS_SQLTUNE_UTIL1 has 3 new objects | DBMS_SQLTUNE_UTIL1 | 27-Apr-2021 |
DBMS_SQLTUNE_UTIL2 has 5 new objects | DBMS_SQLTUNE_UTIL2 | 27-Apr-2021 |
DBMS_STATS_INTERNAL has 35 new objects | DBMS_STATS_INTERNAL | 01-May-2021 |
DBMS_SWRF_INTERNAL has 3 new objects | DBMS_SWRF_INTERNAL | 06-May-2021 |
DBMS_WORKLOAD_CAPTURE dropped GET_STATE function | DBMS_WORKLOAD_CAPTURE | 12-May-2021 |
DBMS_WORKLOAD_CAPTURE_I dropped GET_STATE and USER_CALLS_GRAPH | DBMS_WORKLOAD_CAPTURE_I | 12-May-2021 |
DBMS_WORKLOAD_REPLAY dropped GET_STATE adds new CONFIGURE | DBMS_WORKLOAD_REPLAY | 12-May-2021 |
DBMS_WORKLOAD_REPLAY_I dropped GET_STATE adds new CONFIGURE | DBMS_WORKLOAD_REPLAY_I | 12-May-2021 |
DBMS_WORKLOAD_REPOSITORY has new AWR_EXP procedure | DBMS_WORKLOAD_REPOSITORY | 22-Jan-2021 |
DBMS_WRR_INTERNAL dropped the EXPORT_REP_EXT_TBL procedure | DBMS_WRR_INTERNAL | 23-Dec-2020 |
DBMS_WRR_PROTECTED has new GET_DBREPLAY_PATCH_INFO function | DBMS_WRR_PROTECTED | 23-Dec-2020 |
DBMS_XPLAN has new COMPARE_CURSOR and COMPARE_EXPLAIN objects | DBMS_XPLAN | 24-May-2021 |
DBMS_XSTREAM_GG_ADM has new PURGE_TXN_CDR_INFO object | DBMS_XSTREAM_GG_ADM | 04-Jan-2021 |
DBMS_XSTREAM_GG_INTERNAL has new PURGE_TXN_CDR_INFO_INTERNAL object | DBMS_XSTREAM_GG_INTERNAL | 28-May-2021 |
DBMS_XS_SIDP has new DODHEXCHANGE2 and DODHEXCHANGE3 procedures | DBMS_XS_SIDP | 31-May-2021 |
DIANA has 15 new objects | DIANA | 12-Oct-2021 |
EXCHANGE has new DO_DDL_JOB procedure | EXCHANGE | 03-Jun-2021 |
HTF has 2 new objects | HTF | - |
KBRSI_ICD has 4 objects removed and 19 new objects added | KBRSI_ICD | 17-Jan-2021 |
KUPF$FILE has 3 new objects | KUPF$FILE | 22-Jun-2022 |
KUPF$FILE_INT has 3 new objects | KUPF$FILE_INT | 08-Nov-2021 |
KUPP$PROC has 4 new objects | KUPP$PROC | 05-Jun-2021 |
KUPU$UTILITIES has 8 new objects and dropped WRITEAUDITRECORD | KUPU$UTILITIES | 28-Sep-2021 |
PRVTEMX_DBHOME has new REPORT_ASH_XML function | PRVTEMX_DBHOME | 20-Jun-2021 |
PRVTEMX_PERF has new ACTION_CANCEL_SQL_XML function | PRVTEMX_DBHOME | 20-Jun-2021 |
PRVT_AWR_VIEWER has 9 new objects | PRVT_AWR_VIEWER | 21-Jun-2021 |
PRVT_DBMS_INMEMORY_ADMIN has SPACE_USAGE2 and TRACE removed | PRVT_DBMS_INMEMORY_ADMIN | 09-Mar-2021 |
PRVT_DIMENSION_SYS_UTIL dropped the SET_DEBUG procedure | PRVT_DIMENSION_SYS_UTIL | 24-Jun-2021 |
PRVT_EMX has new OMX_LOCALES function | PRVT_EMX | 15-Mar-2021 |
STANDARD has 4 new objects | STANDARD | 30-Jun-2021 |
XS_ACL has new GRANT_PRIVILEGE and REVOKE_PRIVILEGE procedures | XS_ACL | 02-Jul-2021 |
Built-in Packages with New or Removed Overloads | ||
CTX_DOC.TOKENS has one new overloads | CTX_DOC | 03-Dec-2021 |
DBMS_AQ.DEQUEUE and ENQUEUE have new overloads | DBMS_AQ | 08-Nov-2021 |
DBMS_CLOUD.CREATE_CREDENTIAL has a new overload | DBMS_CLOUD | 14-Dec-2020 |
DBMS_JSON.ADD_VIRTUAL_COLUMNS and GET_INDEX_DATAGUIDE have new overloads | DBMS_JSON | 14-Mar-2021 |
DBMS_XDB_REPOS.LOCK_RESOURCE has a new overload | DBMS_XDB_REPOS | 05-Nov-2022 |
Built-in Packages with Parameters Changes | ||
DBMS_APP_CONT_PRVT.REPARE_REPLAY has 4 new parameters | DBMS_APP_CONT_ADMIN | 14-Dec-2020 |
DBMS_DST.UPGRADE_TABLE has a new FROM_TZ_VERSION parameter | DBMS_DST | 07-Dec-2020 |
DBMS_GSM_POOLADMIN.ADD_SHARD has 5 new parameters | DBMS_GSM_POOLADMIN | 05-Mar-2021 |
DBMS_HIERARCHY.VALIDATE_ANALYTIC_VIEW has 2 new parameters | DBMS_HIERARCHY | 08-Mar-2021 |
DBMS_JSON objects add 13 new parameters | DBMS_JSON | 14-Mar-2021 |
DBMS_SERVICE.DISCONNECT_SESSION has new GUID parameter | DBMS_SERVICE | 03-Jan-2021 |
DBMS_SNAPSHOT_UTL has new IMPORT_LPT_TRIGGER_STRING and SYNC_UP_LPT objs | DBMS_SNAPSHOT_UTL | 22-Jan-2021 |
KBRSI_ICD.RSKRSPDELETEDB has new P_TKEY parameter | KBRSI_ICD | 17-Jan-2021 |
KBRSI_ICD.RSSCHEDUNLOCK modified from BINARY_INTEGER (19c) to BOOLEAN (21c) | KBRSI_ICD | 17-Jan-2021 |
Built-in Packages with new Constants, Exceptions, Types, and other significant changes | ||
DBMS_ADVISOR has 32 new ZoneMap related constants | DBMS_ADVISOR | 06-Feb-2021 |
DBMS_AQADM has 4 new Retention Type constants | DBMS_AQADM | 06-Feb-2021 |
DBMS_BLOCKCHAIN_TABLE has new SIGN_ALGO_DEFAULT Constant | DBMS_BLOCKCHAIN_TABLE | 27-Dec-2020 |
DBMS_CLOUD has added new constants with version 21c | DBMS_CLOUD | 14-Dec-2020 |
DBMS_CLOUD_TYPES has 2 new constants with version 21c | DBMS_CLOUD_TYPES | 14-Dec-2020 |
DBMS_CLOUD_TYPES has 2 new types and has altered LIST_OBJECT_RET_T in 21c | DBMS_CLOUD_TYPES | 14-Dec-2020 |
DBMS_DB_VERSION has new 20c and 21c Constants | DBMS_DB_VERSION | 09-Jan-2021 |
DBMS_GSM_UTILITY has many new constants | DBMS_GSM_UTILITY | 05-Mar-2021 |
DBMS_INDEX_UTL has 6 constants for GET_REORG_INDEX_ACTION | DBMS_INDEX_UTL | 09-Mar-2021 |
DBMS_JSON objects has 11 new constants | DBMS_JSON | 14-Mar-2021 |
DBMS_LCR has 2 new OSON constants for JSON | DBMS_LCR | 18-Dec-2020 |
DBMS_PDB has 2 new FEATURE_ID constants | DBMS_PDB | 27-Mar-2021 |
DBMS_RCVCAT has new ECODE_UNKNOWN_INC constant | DBMS_RCVCAT | 31-Mar-2021 |
Related Topics |
---|
New in 11.2 |
New in 12.1 |
New in 12.2 |
New in 18c |
New in 19c |
New in 20c |
New in 23c |
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 | |||||||||
|
||||||||||