| Description |
Link |
Last Modified |
| Architecture |
| TBD |
|
|
| |
| General |
New Users
Deprecated/Dropped Users as Part of Default Install
|
USERS |
23-Feb-2019 |
New Roles
- APPLICATION_TRACE_VIEWER
- BDSQL_ADMIN
- BDSQL_USER
- GSMROOTUSER_ROLE
- MGW_ADMINISTRATOR_ROLE
- MGW_AGENT_ROLE
- ORACLE_JAVA_DEV
- SYSUMF_ROLE
Deprecated/Dropped Roles as Part of Default Install
|
ROLE |
23-Feb-2019 |
New System Privileges
Deprecated/Dropped System Privileges
|
SYSTEM PRIVILEGES |
23-Feb-2019 |
New Object Privileges
Deprecated/Dropped Object Privileges
|
Object Privileges |
23-Feb-2019 |
New Dynamic Performance Views
Deprecated/Dropped Dynamic Performance Views
|
Dynamic Performance Views |
23-Feb-2019 |
New Hints
- JSON_LENGTH
- NO_PQ_EXPAND_TABLE
- NO_USE_SCALABLE_GBY_INVDIST
- PQ_EXPAND_TABLE
- QUARANTINE
- USE_SCALABLE_GBY_INVDIST
|
Hints |
30-Jul-2019 |
New Initialization Parameters
- DATA_GUARD_MAX_IO_TIME
- DATA_GUARD_MAX_LONGIO_TIME
- ENABLE_IMC_WITH_MIRA
- LOG_SIGNATURE_ENABLE
- MAX_DATAPUMP_PARALLEL_PER_JOB
Deprecated Initialization Parameters
- CLUSTER_DATABASE_INSTANCES
- CURSOR_SPACE_FOR_TIME
|
Startup Parameters |
22-Oct-2020 |
New Built-In Packages
Dropped Built-In Packages
- DBMS_APPLY_HANDLER_ADM
- DBMS_APPLY_HANDLER_INTERNAL
- DBMS_FIX_CONTROL_PERSISTENCE
- DBMS_OPTIM_BUNDLE
- DBMS_OUTLN_EDIT
- DBMS_STREAMS_ADVISOR_ADM
- DBMS_STREAMS_ADV_ADM_UTL
- DBMS_STREAMS_ADV_ADM_UTL_INVOK
- DBMS_STREAMS_HANDLER_ADM
- DBMS_STREAMS_HANDLER_INTERNAL
- DBMS_STREAMS_MC
- DBMS_STREAMS_MC_INV
- DBMS_STREAMS_MESSAGING
- DBMS_SUMREF_UTIL
- OUTLN_EDIT_PKG
|
Built-In Packages |
21-Jun-2019 |
| |
| Deprecated or Dropped Objects |
| Product User Profile: The table still exists ...
but the functionality does not. |
|
09-Dec-2019 |
| |
| New Object Types |
| Hybrid Partitioned Tables |
Partitioning |
23-Feb-2019 |
| |
| New SQL |
| DISTINCT operator is now available for use with the LISTAGG aggregate |
Analytic Functions |
24-Feb-2019 |
| Materialized views query rewriting is enhanced to support queries with JSON_EXISTS, JSON_VALUE and other functions when it contains a JSON_TABLE function |
Materialized Views |
24-Feb-2019 |
| Application Continuity for sequence objects includes the new KEEP/NOKEEP syntax and privs |
SEQUENCE |
24-Apr-2023 |
| Enable sequence scalability offset SCALE/NOSCALE |
SEQUENCE |
24-Apr-2023 |
| Sequence option for use with Global Temporary
Tables: SESSION/GLOBAL |
SEQUENCE |
24-Apr-2023 |
| Generate unique sequence numbers across shards |
SEQUENCE |
24-Apr-2023 |
| |
| New PL/SQL |
| TBD |
|
|
| |
| New or Modified Functions, Operators, Procedures, and Types |
| TO_BLOB has 1 new overloads |
Conversion Function |
09-Mar-2019 |
| TO_CHAR has 2 new overloads (25 & 26) |
Conversion Function |
09-Mar-2019 |
| TO_CLOB has 2 new overloads |
Conversion Function |
09-Mar-2019 |
| |
| Renamed Objects |
| TBD |
|
|
| |
| New or Modified Functions, Operators, Procedures, and Types |
| New JSON_DATAGUIDE SQL aggregate function can detect GeoJSON in docs |
JSON |
24-Feb-2019 |
| New JSON_MERGE_PATCH function can update a JSON document declaratively applying one or more changes to multiple documents in a single statement |
JSON |
24-Feb-2019 |
| New JSON_SERIALIZE function to serialize JSON data to text or UTF-encoded BLOBs |
JSON |
24-Feb-2019 |
| |
| Changes to JSON, SODA and XML |
| Syntax simplifications for SQL/JSON path expressions and new JSON_SERIALIZE function |
JSON |
24-Feb-2019 |
| Materialized views query rewriting is enhanced to support queries with JSON_EXISTS, JSON_VALUE and other functions when it contains a JSON_TABLE function |
Materialized Views |
24-Feb-2019 |
| |
| New Built-in Packages |
| DBMS_APP_CONT_ADMIN with 10 objects relocated from DBMS_APP_CONT |
DBMS_APP_CONT_ADMIN |
30-Jun-2019 |
| DBMS_AQ_IMPORT_INTERNAL_DR |
DBMS_AQ_IMPORT_INTERNAL_DR |
01-Jul-2019 |
| DBMS_AUTO_INDEX |
DBMS_AUTO_INDEX |
02-Jul-2019 |
| DBMS_AUTO_INDEX_INTERNAL |
DBMS_AUTO_INDEX_INTERNAL |
02-Jul-2019 |
| DBMS_AWR_WAREHOUSE_SERVER |
DBMS_AWR_WAREHOUSE_SERVER |
30-Jun-2019 |
| DBMS_AWR_WAREHOUSE_SOURCE |
DBMS_AWR_WAREHOUSE_SOURCE |
30-Jun-2019 |
| DBMS_BDSQL |
DBMS_BDSQL |
30-Jun-2019 |
| DBMS_CHAIN_INVOKER |
DBMS_CHAIN_INVOKER |
03-Jul-2019 |
| DBMS_FEATURE_USAGE_CLIENT |
DBMS_FEATURE_USAGE_CLIENT |
03-Jul-2019 |
| DBMS_FUSE_PUBLIC |
DBMS_FUSE_PUBLIC |
30-Jun-2019 |
| DBMS_JAVA_DEV |
DBMS_JAVA_DEV |
02-Mar-2019 |
| DBMS_MEMOPTIMIZE_ADMIN |
DBMS_MEMOPTIMIZE_ADMIN |
22-Feb-2019 |
| DBMS_SQLCONTROL_INTERNAL |
DBMS_SQLCONTROL_INTERNAL |
28-Jun-2019 |
| DBMS_SQLQ |
DBMS_SQLQ |
23-Feb-2019 |
| DBMS_SQLQ_INTERNAL |
DBMS_SQLQ_INTERNAL |
28-Jun-2019 |
| KUBSD$DESC_INT |
KUBSD$DESC_INT |
24-Feb-2019 |
| KU$_DPLOAD |
KU$_DPLOAD |
04-Mar-2019 |
| KU$_DPLOCK |
KU$_DPLOCK |
04-Mar-2019 |
| PRVT_ASH_OMX |
PRVT_ASH_OMX |
28-Jun-2019 |
| SDO_RDF_SYS |
SDO_RDF_SYS |
25-Jan-2020 |
| UTL_RPADV |
UTL_RPADV |
22-Feb-2019 |
| XDB_MIGRATESCHEMA |
XDB_MIGRATESCHEMA |
28-Jun-2019 |
| |
| Built-in Packages with New or Removed Objects |
| CDBVIEW_INTERNAL has new CREATE_CDBVIEW procedure |
CDBVIEW_INTERNAL |
24-Feb-2019 |
| DBMS_APPLY_ADM ADD_STMT_HANDLER, REMOVE_STMT_HANDER and SET_CHANGE_HANDLER removed |
DBMS_APPLY_ADM |
25-Feb-2019 |
| DBMS_APPLY_ADM has new CLEAR_KEY_COLUMNS procedure |
DBMS_APPLY_ADM |
25-Feb-2019 |
| DBMS_APP_CONT had 10 new objects (4 relocated from DBMS_SESSION) |
DBMS_APP_CONT |
30-Jun-2019 |
| DBMS_AUTO_TASK_ADMIN has new MODIFY_AUTOTASK_SETTINGS procedure |
DBMS_AUTO_TASK_ADMIN |
26-Feb-2019 |
| DBMS_DATAPUMP_UTL has new |
DBMS_DATAPUMP_UTL |
03-May-2020 |
| DBMS_DBFS_SFS_ADMIN dropped BLESSUSER procedure |
DBMS_DBFS_SFS_ADMIN |
14-May-2019 |
| DBMS_DBFS_SFS_ADMIN has 6 new objects |
DBMS_DBFS_SFS_ADMIN |
14-May-2019 |
| DBMS_DRS has new METADATA_FILE procedure |
DBMS_DRS |
27-Feb-2019 |
| DBMS_GSM_CLOUDADMIN has new CAT_REDO_MARKER procedure |
DBMS_GSM_CLOUDADMIN |
04-Mar-2019 |
| DBMS_GSM_DBADMIN has 5 new objects |
DBMS_GSM_DBADMIN |
28-Feb-2019 |
| DBMS_GSM_FIX has new GETDBVERSION and VALIDATECDB objects |
DBMS_GSM_FIX |
20-May-2019 |
| DBMS_GSM_POOLADMIN has new PDB_FIXUP and RECOVERCHUNKS procedures |
DBMS_GSM_POOLADMIN |
17-Mar-2019 |
| DBMS_GSM_UTILITY has new GETVERSIONSTRING function |
DBMS_GSM_UTILITY |
20-May-2019 |
| DBMS_HADOOP has new CREATE_HYBRID_PARTNED_TABLE and USER_PRIVILEGED objects |
DBMS_HADOOP |
01-Mar-2019 |
| DBMS_HADOOP_INTERNAL has 3 objects removed and 13 new objects |
DBMS_HADOOP_INTERNAL |
01-Mar-2019 |
| DBMS_HS_PARALLEL.TABLE_SAMPLING relocated from DBMS_HS_PARALLEL_METADATA |
DBMS_HS_PARALLEL |
20-Mar-2019 |
| DBMS_HS_PARALLEL_METADATA.ABLE_SAMPLING > DBMS_HS_PARALLEL_METADATA |
DBMS_HS_PARALLEL_METADATA |
20-Mar-2019 |
| DBMS_INMEMORY_ADMIN has 6 new objects |
DBMS_INMEMORY_ADMIN |
24-Feb-2019 |
| DBMS_IR.UPDATEFEASABILITYANDIMPACT removed |
DBMS_IR |
11-Mar-2019 |
| DBMS_JSON has new GEOJSON function |
DBMS_JSON |
11-Mar-2019 |
| DBMS_LOGMNR has new INIT_REPLICATION_METADATA and PROFILE procedures |
DBMS_LOGMNR |
27-Feb-2019 |
| DBMS_MANAGEMENT_BOOTSTRAP has new CLEANUP_DB_REPLAY objects procedure |
DBMS_MANAGEMENT_BOOTSTRAP |
21-Mar-2019 |
| DBMS_MEMOPTIMIZE has 3 new objects |
DBMS_MEMOPTIMIZE |
11-Mar-2019 |
| DBMS_PDB_ALTER_SHARING renamed REMOVE_LINK to SET_SHARING_NONE |
DBMS_PDB_ALTER_SHARING |
25-Feb-2019 |
| DBMS_PDB_APP_CON has a new MOVE_DATA procedure |
DBMS_PDB_APP_CON |
25-Feb-2019 |
| DBMS_PLUGTS removed 12 objects and added 3 new ones |
DBMS_PLUGTS |
28-Feb-2019 |
| DBMS_PREUP has 15 new objects |
DBMS_PREUP |
26-Jul-2019 |
| DBMS_RCVMAN has 8 new objects |
DBMS_RCVMAN |
27-Feb-2019 |
| DBMS_REGISTRY removed the SET_RDBMS_UPGRADED_STATUS procedure |
DBMS_REGISTRY |
18-Mar-2019 |
| DBMS_REGISTRY adds nine new objects |
DBMS_REGISTRY |
18-Mar-2019 |
| DBMS_REGISTRY_SYS removed 9 objects |
DBMS_REGISTRY_SYS |
18-Mar-2019 |
| DBMS_REGISTRY_SYS has new CAPITALIZE_SINGLE_QUOTED and CATCON_QUERY objects |
DBMS_REGISTRY_SYS |
18-Mar-2019 |
| DBMS_SERVICE has new KILL_SESSION and TAG_SESSION objects |
DBMS_SERVICE |
28-Feb-2019 |
| DBMS_SESSION dropped 4 CONNECTION_TEST objects (moved to DBMS_APP_CONT) |
DBMS_SESSION |
17-Mar-2019 |
| DBMS_SESSION added new CURRENT_IS_ROLE_ENABLED and SESSION_IS_ROLE_ENABLED functions |
DBMS_SESSION |
17-Mar-2019 |
| DBMS_SPACE has new GET_COMPRESSSION_RATIO procedure |
DBMS_SPACE |
06-Apr-2019 |
| DBMS_SQLTUNE_UTIL0 removed CHECK_OBJ_PRIV function |
DBMS_SQLTUNE_UTIL0 |
11-Mar-2019 |
| DBMS_SQLTUNE_UTIL0 has new CHECK_DV_ACCESS and SET_DB_LINK_TO_PRIM objects |
DBMS_SQLTUNE_UTIL0 |
11-Mar-2019 |
| DBMS_SQLTUNE_UTIL1 has 7 new objects | DBMS_SQLTUNE_UTIL1 |
11-Mar-2019 |
| DBMS_SQLTUNE_UTIL2, RESOLV_EXEC_NAME moved to DBMS_SQLTUNE_UTIL1 |
DBMS_SQLTUNE_UTIL2 |
11-Mar-2019 |
| DBMS_STATS has 4 new objects |
DBMS_STATS |
10-Mar-2019 |
| DBMS_STATS_INTERNAL dropped GET_OBJ_ID_FOR_QUALIFIED_NAME |
DBMS_STATS_INTERNAL |
08-Apr-2019 |
| DBMS_STATS_INTERNAL has 28 new objects |
DBMS_STATS_INTERNAL |
08-Apr-2019 |
| DBMS_STREAMS_TABLESPACE_ADM removed PULL_SIMPLE_TABLESPACE and PULL_TABLESPACES objects |
DBMS_STREAMS_TABLESPACE_ADM |
02-Mar-2019 |
| DBMS_SUMMARY has SET_LOGFILE_NAME procedure removed |
DBMS_SUMMARY |
14-Mar-2019 |
| DBMS_UTILITY has new DIRECTORY_HAS_SYMLINK function |
DBMS_UTILITY |
17-Mar-2019 |
| DBMS_WORKLOAD_REPOSITORY has new AWR_IMP and MODIFY_TABLE_SETTINGS objects |
DBMS_WORKLOAD_REPOSITORY |
25-Feb-2019 |
| DBMS_WRR_INTERNAL dropped 3 objects |
DBMS_WRR_INTERNAL |
13-Jul-2019 |
| DBMS_WRR_INTERNAL has new FORMAT_TIME_INTERVAL and PROCESS_SQL_SCHEMA |
DBMS_WRR_INTERNAL |
13-Jul-2019 |
| DBMS_WRR_PROTECTED.SET_PDB_ENABLED has been removed |
DBMS_WRR_PROTECTED |
13-Jul-2019 |
| DBMS_WRR_PROTECTED has 5 new objects |
DBMS_WRR_PROTECTED |
13-Jul-2019 |
| DBMS_XDBZ has 6 objects removed |
DBMS_XDBZ |
03-Mar-2019 |
| DBMS_XPLAN has new COMPARE_PLANS, DISPLAY_SHARD_PLANS, GET_FINAL_PLAN objects |
DBMS_XPLAN |
05-Mar-2019 |
| |
| Built-in Packages with New or Removed Overloads |
| DBMS_APPLY_ADM.SET_KEY_COLUMNS has new 3rd overload |
DBMS_APPLY_ADM |
25-Feb-2019 |
| DBMS_GSM_FIX.VALIDATEDATABASE has a new 3rd overload |
DBMS_GSM_FIX |
20-May-2019 |
| DBMS_RCVMAN has 2 objects newly overloaded and deprecating overload 1 |
DBMS_RCVMAN |
27-Feb-2019 |
| DBMS_SQLTUNE_UTIL0.CBDCON_NAME2ID has new overload |
DBMS_SQLTUNE_UTIL0 |
11-Mar-2019 |
| |
| Built-in Packages with Parameters Changes |
| DBMS_GSM_POOLADMIN has new FAILOVER_RESTORE parameter |
DBMS_GSM_POOLADMIN |
17-Mar-2019 |
| DBMS_LOGSTDBY has new parameter CON_ID in SKIP_TRANSACTION and UNSKIP_TRANSACTION |
DBMS_LOGSTDBY |
23-May-2019 |
| DBMS_MVIEW has new SKIP_EXT_DATA parameter |
DBMS_MVIEW |
30-Mar-2019 |
| DBMS_SNAPSHOT has new SKIP_EXT_DATA parameter |
DBMS_SNAPSHOT |
30-Mar-2019 |
| DBMS_SQLPA.REMOTE_PROCESS_SQL has 3 new parameters |
DBMS_SQLPA |
31-Mar-2019 |
| DBMS_STATS has new REALTIME_STATS parameter |
DBMS_STATS |
10-Mar-2019 |
| DBMS_XSTREAM_ADM several objects have new LCRID_VERSION parameter |
DBMS_XSTREAM_ADM |
24-Feb-2019 |
| |
| Built-in Packages with new Constants, Exceptions, Types, and other significant changes |
| DBMS_DBMS_DATA_PUMP has a number of new constants |
DBMS_ADVISOR |
11-Mar-2019 |
| DBMS_ADVISOR has 2 new constants |
DBMS_DATAPUMP |
17-Mar-2019 |
| DBMS_GSM_COMMON has a large number of new constants |
DBMS_GSM_COMMON |
15-Mar-2019 |
| DBMS_GSM_UTILITY has many new constants |
DBMS_GSM_UTILITY |
20-May-2019 |
| DBMS_HANG_MANAGER has new RESOLUTION_SCOPE_NODE constant |
DBMS_HANG_MANAGER |
01-Mar-2019 |
| DBMS_PDB has three new constants and V_FEAT_MAX revalued to 38 |
DBMS_PDB |
04-Mar-2019 |
| DBMS_RCVMAN has new and modified PL/SQL types and constants |
DBMS_RCVMAN |
27-Feb-2019 |
| DBMS_REGISTRY has 4 new constants new values for previously existing constants |
DBMS_REGISTRY |
18-Mar-2019 |
| DBMS_RESOURCE_MANAGER drops 8 constants |
DBMS_RESOURCE_MANAGER |
11-Mar-2019 |
| DBMS_SERVER_ALERT has 11 new constants |
DBMS_SERVER_ALERT |
05-Apr-2019 |
| DBMS_SERVICE has many new constants |
DBMS_SERVICE |
28-Feb-2019 |
| DBMS_SESSION dropped 3 CONNECTION_TEST related constants (moved to DBMS_APP_CONT) |
DBMS_SESSION |
17-Mar-2019 |
| DBMS_SPACE has new VERIFY_SHRINK and OBJECT_SPACE_USAGE types |
DBMS_SPACE |
06-Apr-2019 |
| DBMS_SQLTUNE_UTIL1 has many new constants |
DBMS_SQLTUNE_UTIL1 |
11-Mar-2019 |
| DBMS_SQLTUNE_UTIL2 has 5 new constants |
DBMS_SQLTUNE_UTIL2 |
11-Mar-2019 |
| DBMS_SQL_TRANSLATOR has new ATTR_LOG_ERRORS constant |
DBMS_SQL_TRANSLATOR |
11-Apr-2019 |
| DBMS_STANDARD has new ORA_MAX_NAME_LEN constant |
DBMS_STANDARD |
10-Apr-2019 |
| DBMS_STATS,GET_COLUMN_STATS has new REALTIME_STATS parameter |
DBMS_STATS |
10-Mar-2019 |
| DBMS_TSDP_PROTECT has 2 new and 2 renamed constants |
DBMS_TSDP_PROTEC |
08-Apr-2019 |
| DBMS_UTILITY has new QUOTED_NAME_ARRAY data type and 2 new DIRECTORY_HAS_SYMLINK constants |
DBMS_UTILITY |
17-Mar-2019 |
| DBMS_XSTREAM_ADM has a new CLEAR_KEY_COLUMNS constant |
DBMS_XSTREAM_ADM |
24-Feb-2019 |
| ODCICONST has new CompReferencedCol constant |
ODCICONST |
25-Feb-2019 |
