New In Oracle Database Versions 19cR2
Version 19.2.0.1

Description Link Last Modified
Architecture
TBD    
 
General
New Users
  • BDSQL_USER
  • GSMROOTUSER
Deprecated/Dropped Users as Part of Default Install
  • None
USERS 23-Feb-2019
New Roles
  • APPLICATION_TRACE_VIEWER
  • BDSQL_ADMIN
  • GSMROOTUSER_ROLE
  • MGW_ADMINISTRATOR_ROLE
  • MGW_AGENT_ROLE
  • ORACLE_JAVA_DEV
  • SYSUMF_ROLE
Deprecated/Dropped Roles as Part of Default Install
  • None
ROLE 23-Feb-2019
New System Privileges
  • TBD
Deprecated/Dropped System Privileges
  • TBD
SYSTEM PRIVILEGES  
New Object Privileges
  • TBD
Deprecated/Dropped Object Privileges

  • TBD
Object Privileges  
New Dynamic Performance Views
  • TBD
Deprecated/Dropped Dynamic Performance Views
  • TBD
Dynamic Performance Views  
New Initialization Parameters
  • TBD
Deprecated Initialization Parameters

  • CLUSTER_DATABASE_INSTANCES
Startup Parameters 26-Feb-2019
New Built-In Packages
  • See below
Dropped Built-In Packages
  • DBMS_FIX_CONTROL_PERSISTENCE
  • DBMS_OUTLN_EDIT
  • DBMS_STREAMS_ADVISOR_ADM
  • OUTLN_EDIT_PKG
Built-In Packages 08-Apr-2019
 
Deprecated or Dropped Objects
TBD    
 
New Object Types
Hybrid Partitioned Tables Partitioning  
 
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
 
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_AUTO_INDEX DBMS_AUTO_INDEX 22-Feb-2019
DBMS_AWR_WAREHOUSE_SERVER DBMS_AWR_WAREHOUSE_SERVER 25-Feb-2019
DBMS_AWR_WAREHOUSE_SOURCE DBMS_AWR_WAREHOUSE_SOURCE 25-Feb-2019
DBMS_BDSQL DBMS_BDSQL 25-Feb-2019
DBMS_FUSE_PUBLIC DBMS_FUSE_PUBLIC 04-Mar-2019
DBMS_JAVA_DEV DBMS_JAVA_DEV 02-Mar-2019
DBMS_MEMOPTIMIZE_ADMIN DBMS_MEMOPTIMIZE_ADMIN 22-Feb-2019
DBMS_SQLQ DBMS_SQLQ 23-Feb-2019
DEBUG_EXTPROC DEBUG_EXTPROC 23-Feb-2019
KUBSD$DESC_INT KUBSD$DESC_INT 24-Feb-2019
KU$_DPLOAD KU$_DPLOAD 04-Mar-2019
KU$_DPLOCK KU$_DPLOCK 04-Mar-2019
UTL_RPADV UTL_RPADV 22-Feb-2019
XDB_MIGRATESCHEMA XDB_MIGRATESCHEMA 01-Mar-2019
 
Built-in Packages with New or Removed Functions and Procedures
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 has 10 new objects (4 relocated from DBMS_SESSION) DBMS_APP_CONT 22-Feb-2019
DBMS_AUTO_TASK_ADMIN has new MODIFY_AUTOTASK_SETTINGS procedure DBMS_AUTO_TASK_ADMIN 26-Feb-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_POOLADMIN has new PDB_FIXUP and RECOVERCHUNKS procedures DBMS_GSM_POOLADMIN 17-Mar-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 has new TABLE_SAMPLING relocated from DBMS_HS_PARALLEL_METADATA DBMS_HS_PARALLEL 20-Mar-2019
DBMS_HS_PARALLEL_METADATA TABLE_SAMPLING relocated toDBMS_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_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 objectsDBMS_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_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_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_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_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 has 3 newnew 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 constants for the DIRECTORY_HAS_SYMLINK function 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
 
Related Topics
New in 11.2.0.3
New in 12.1.0.2
New in 12.2.0.1
New in 18.3.0.1
  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-2019 Daniel A. Morgan All Rights Reserved