New In Oracle Database Versions 20c and 21c |
---|
Description | Link | Last Modified |
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 | 20-Mar-2021 |
RMAN Repository | ||
New
|
RMAN | 31-Mar-2020 |
Other Deprecated or Dropped Objects | ||
TBD | - | |
Object Types and Features | ||
New
|
BlockChain Tables DBMS_AQADM |
27-Dec-2020 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 |
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_EM_DIAG | DBMS_FEATURE Procedures | 08-Dec-2020 |
DBMS_FEATURE_EM_GC | DBMS_FEATURE Procedures | 08-Dec-2020 |
DBMS_FEATURE_EM_INT | DBMS_FEATURE Procedures | 08-Dec-2020 |
DBMS_FEATURE_EM_TUNING | 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 |
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 |
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_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 | 05-Dec-2020 |
DBMS_CLOUD_TYPES | DBMS_CLOUD_TYPES | 05-Dec-2020 |
DBMS_CUBE_PRVTEXP | DBMS_CUBE_PRVTEXP | 17-Dec-2020 |
DBMS_DLM | DBMS_DLM | 27-Dec-2020 |
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_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_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 | DBMS_WRR_STATE_BASE | 23-Dec-2020 |
LBAC_POLICY_ADMIN_INT | LBAC_POLICY_ADMIN_INT | 21-Dec-2020 |
LTI | LTI | 30-Dec-2020 |
SA_USER_ADMIN_INT | SA_USER_ADMIN_INT | 05-Jan-2021 |
Built-in Packages with New or Removed Objects | ||
DBMS_APP_CONT_ADMIN has 5 new objects | DBMS_APP_CONT_ADMIN | 14-Dec-2020 |
DBMS_AQ has new SEEK procedure | DBMS_AQ | 06-Feb-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_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_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_FIXED has 12 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_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_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_SQLTCB_INTERNAL has new FIXQ object | DBMS_SQLTCB_INTERNAL | 19-Mar-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_XSTREAM_GG_ADM has new PURGE_TXN_CDR_INFO object | DBMS_XSTREAM_GG_ADM | 04-Jan-2021 |
KBRSI_ICD has 19 new objects | KBRSI_ICD | 17-Jan-2021 |
KBRSI_ICD has 4 objects removed | KBRSI_ICD | 17-Jan-2021 |
PRVT_DBMS_INMEMORY_ADMIN has SPACE_USAGE2 and TRACE removed | PRVT_DBMS_INMEMORY_ADMIN | 09-Mar-2021 |
PRVT_EMX has new OMX_LOCALES function | PRVT_EMX | 15-Mar-2021 |
Built-in Packages with New or Removed Overloads | ||
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 |
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 |
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-2019 Daniel A. Morgan All Rights Reserved | |||||||||
|
||||||||||