New In Oracle Database
Version 18c

Description Link Last Modified
Architecture
NO AUTHENTICATION schemas Users 06-Mar-2018
Read Only Oracle Home (ROOH) ROOH 26-Feb-2018
DataPump No Logging Option for Import DataPump -
SQL*Loader Express Mode SQL*Loader -
Full transportable support for point-in-time recoveryof PDBs - -
 
General
New Users
  • APEX_PUBLIC_USER
  • APEX_REST_PUBLIC_USER
  • FLOWS_FILES
Deprecated/Dropped Roles as Part of Default Install
  • SPATIAL_CSW_ADMIN_USR
 USERS 03-May-2018
New Roles
  • None
Deprecated/Dropped Roles as Part of Default Install
  • JAVA_DEPLOY
  • SPATIAL_CSW_ADMIN
  • XFILES_ADMINISTRATOR
  • XFILES_USER
 ROLE 04-Mar-2018
New System Privileges
  • READ ANY ANALYTIC VIEW CACHE
  • TEXT DATASTORE ACCESS
  • WRITE ANY ANALYTIC VIEW CACHE
Deprecated/Dropped System Privileges
  • EXEMPT DDL REDACTION POLICY
  • EXEMPT DML REDACTION POLICY
 SYSTEM PRIVILEGES 04-Mar-2018
New Object Privileges
  • None
Deprecated/Dropped Object Privileges

  • None
 Object Privileges 04-Mar-2018
New Dynamic Performance Views
  • gv$aq_ipc_active_msgs
  • gv$aq_ipc_msg_stats
  • gv$aq_ipc_pending_msgs
  • gv$aq_job_coordinator
  • gv$asm_audit_load_jobs
  • gv$asm_cache_events
  • gv$database_replay_progress
  • gv$imhmseg
  • gv$im_delta_header
  • gv$im_smu_delta
  • gv$java_patching_status
  • gv$java_services
  • gv$memoptimize_write_area
  • gv$quarantine_summary
  • gv$lockdown_rules
  • gv$sqlcommand
  • gv$sql_shard
  • gv$subscr_registration_stats
  • gv$wlm_pcservice
  • vw_x$aud_xs_actions
  • v$_lock
Deprecated/Dropped Dynamic Performance Views
  • v$diag_dfs_purge
  • gv$unified_audit_trial
 Dynamic Performance Views 17-Jan-2019
New Initialization Parameters
  • ADG_ACCOUNT_INFO_TRACKING
  • AWR_PDB_MAX_PARALLEL_SLAVES
  • DBFIPS_140
  • DB_BLOCK_CHECKING (the old parameter was TRUE/FALSE this one is not)
  • FORWARD_LISTENER
  • INMEMORY_AUTOMATIC_LEVEL
  • INMEMORY_OPTIMIZED_ARITHMETIC
  • INMEMORY_PREFER_XMEM_MEMCOMPRESS
  • INMEMORY_PREFER_XMEM_PRIORITY
  • INMEMORY_XMEM_SIZE
  • MEMOPTIMIZE_POOL_SIZE
  • MULTISHARD_QUERY_DATA_CONSISTENCY
  • MULTISHARD_QUERY_PARTIAL_RESULTS
  • OPTIMIZER_IGNORE_HINTS
  • OPTIMIZER_IGNORE_PARALLEL_HINTS
  • PARALLEL_MIN_DEGREE
  • PDB_TEMPLATE
  • PRIVATE_TEMP_TABLE_PREFIX
  • RESOURCE_MANAGER_CPU_ALLOCATION
  • STANDBY_PDB_SOURCE_FILE_DBLINK
  • STANDBY_PDB_SOURCE_FILE_DIRECTORY
  • TDE_CONFIGURATION
  • UNIFIED_AUDIT_SYSTEMLOG
  • WALLET_ROOT
Deprecated Initialization Parameters
  • DBA_REGISTERED_MVIEW_GROUPS
  • DB_BLOCK_CHECKING (the parameter name still exists but valid values have changed)
  • GLOBAL_CONTEXT_POOL_SIZE
  • MAX_ENABLED_ROLES
  • OPTIMIZER_ADAPTIVE_FEATURES
  • PARALLEL_AUTOMATIC_TUNING
  • PARALLEL_IO_CAP_ENABLED
  • PARALLEL_SERVER
  • PARALLEL_SERVER_INSTANCES
  • STANDBY_ARCHIVE_DEST
  • UTL_FILE_DIR
 Startup Parameters 01-Apr-2018
 
Deprecated or Dropped
DBMS_CDC_EXPDP N/A 02-Mar-2018
DBMS_CDC_EXPVDP DBMS_CDC_EXPVDP 02-Mar-2018
DBMS_CDC_IMPDP N/A 02-Mar-2018
DBMS_CDC_IMPDPV DBMS_CDC_IMPDPV 02-Mar-2018
DBMS_CDC_IPUBLISH N/A 02-Mar-2018
DBMS_CDC_ISUBSCRIBE N/A 02-Mar-2018
DBMS_CDC_PUBLISH DBMS_CDC_PUBLISH 02-Mar-2018
DBMS_CDC_SUBSCRIBE DBMS_CDC_SUBSCRIBE 02-Mar-2018
DBMS_CDC_SYS_IPUBLISH N/A 02-Mar-2018
DBMS_CDC_DPUTIL N/A 02-Mar-2018
DBMS_CDC_UTILITY DBMS_CDC_UTILITY 02-Mar-2018
DBMS_FEATURE_CDC DBMS_FEATURE_USAGE 04-Jun-2018
DBMS_FIXED_CONTROL_PERSISTENCE DBMS_FIX_CONTROL_PERSISTENCE 14-Jan-2019
DBMS_XMLQUERY DBMS_XMLQUERY 05-Apr-2018
DBMS_XMLSAVE DBMS_XMLSAVE 05-Apr-2018
Oracle Multimedia and DICOM Multiple Built-in Packages 05-Apr-2018
ORD_DICOM_PROTOCOL N/A 06-Dec-2018
 
New Object Types
Private Temporary Tables Temporary Tables 06-Mar-2018
 
New SQL
TRUNCATE TABLE CASCADE Truncate 07-Jan-2019
 
New PL/SQL
??? ??? TBD
 
New or Modified Functions, Operators, Procedures, and Types
APPROX_COUNT Numeric Functions 17-Mar-2018
APPROX_RANK Numeric Functions 17-Mar-2018
APPROX_SUM Numeric Functions 17-Mar-2018
AS_JSON Undocumented Oracle 26-Dec-2018
COLUMNS Undocumented Oracle 26-Dec-2018
CON_ID_TO_CON_NAME Undocumented Oracle 26-Dec-2018
CON_ID_TO_DBID Undocumented Oracle 26-Dec-2018
DBMS_FEATURE_VPD DBMS_FEATURE_USAGE 04-Jun-2018
JSONTOXML Undocumented Oracle 26-Dec-2018
JSON_EQUAL Undocumented Oracle 26-Dec-2018
JSON_MERGEPATCH Undocumented Oracle 26-Dec-2018
JSON_TEXTCONTAINS2 Undocumented Oracle 26-Dec-2018
LAG_DIFF Undocumented Oracle 26-Dec-2018
LAG_DIFF_PERCENT Undocumented Oracle 26-Dec-2018
LDAP_SERVER_TYPE SYS_CONTEXT 31-May-2018
LEAD_DIFF Undocumented Oracle 26-Dec-2018
LEAD_DIFF_PERCENT Undocumented Oracle 26-Dec-2018
ORA_CHECK_SYS_PRIV Undocumented Oracle 26-Dec-2018
ORA_PARTITION_VALIDATION Undocumented Oracle 26-Dec-2018
OSON Undocumented Oracle 26-Dec-2018
ROUND_TIED_TO_EVEN Numeric Functions 17-Mar-2018
SYS_PLSQL_COUNT Undocumented Oracle 26-Dec-2018
SYS_PLSQL_CPU Undocumented Oracle 26-Dec-2018
SYS_PLSQL_IO Undocumented Oracle 26-Dec-2018
TO_UTC_TIMEZONE_TZ Conversion Function 26-Dec-2018
 
Object Rename
XS_DATA_SECURITY_UTIL renamed to XS_DATA_SECURITY_UTIL_INT XS_DATA_SECURITY_UTIL_INT 26-Jul-2018
 
New or Modified Functions, Operators, Procedures, and Types
TBD ??? TBD
 
JSON, SODA and XML
SQL and PL/SQL can be instructed to return JSON data using TREAT JSON TBD
SQL/JSON queries can return LOBs JSON TBD
SQL/JSON path expression enhancements JSON TBD
Data Dictionary Views can be used to extract path and type information for data guide enabled JSON JSON TBD
SQL/JSON dot notation to access fields JSON TBD
SQL/JSON automatic renaming of projected columns JSON TBD
Materialized Views created from JSON tables can be automatically synchronized JSON TBD
JSON key names can be 255 bytes JSON TBD
PL/SQL programs can interact with SODA document collections stored in the database SODA TBD
 
New Built-in Packages
DBMS_AWR_PROTECTED DBMS_AWR_PROTECTED 04-Mar-2018
DBMS_ISCHEDFW with FILE_WATCH_JOB and WATCH_FOR_FILES from DBMS_ISCHED DBMS_ISCHEDFW 23-Mar-2019
DBMS_ISCHED_AGENT DBMS_ISCHED_AGENT 06-Mar-2018
DBMS_ISCHED_UTL with CHECK_OBJECT_PRIVS from DBMS_ISCHED DBMS_ISCHED_UTL 23-Mar-2019
DBMS_MEMOPTIMIZE DBMS_MEMOPTIMIZE 16-Sep-2018
DBMS_PDB_APP_CON DBMS_PDB_APP_CON 03-Mar-2018
DBMS_RAT_MASK_INTERNAL DBMS_RAT_MASK_INTERNAL 28-Mar-2019
DBMS_SODA DBMS_SODA 25-Feb-2018
DBMS_SQLSET DBMS_SQLSET 03-Mar-2018
DBMS_STATS_INTERNAL_AGG DBMS_STATS_INTERNAL_AGG 08-Apr-2018
DBMS_WORKLOAD_CAPTURE_I DBMS_WORKLOAD_CAPTURE_I 19-May-2018
DBMS_WORKLOAD_REPLAY_I DBMS_WORKLOAD_REPLAY_I 19-May-2018
DBMS_WRR_REPORT DBMS_WRR_REPORT -
DBMS_XDS_INT DBMS_XDS_INT 07-May-2018
 
Built-in Packages with New or Removed Functions and Procedures
DBMS_ADR has three new objects DBMS_ADR 10-Feb-2019
DBMS_ADR_APP has GET_CALL_ERROR_MSG and GET_CALL_STATUS functions DBMS_ADR_APP 29-Dec-2018
DBMS_AQ has 12 new objects DBMS_AQ 10-Dec-2018
DBMS_AQADM_VAR has 2 new functions DBMS_AQADM_VAR 10-Dec-2018
DBMS_AUDIT_MGMT has 4 new objects DBMS_AUDIT_MGMT 05-Dec-2018
DBMS_AW has three new objects DBMS_AW 31-Dec-2018
DBMS_BACKUP_RESTORE has 9 new objects DBMS_BACKUP_RESTORE 01-Jan-2019
DBMS_CSX_INT drops testDecodeJC and testEncodeJC functions DBMS_CSX_INT 01-Jan-2019
DBMS_CSX_INT adds 4 new objects DBMS_CSX_INT 01-Jan-2019
DBMS_CUBE_ADVISE_SEC removed 6 objects DBMS_CUBE_ADVISE_SEC 06-Jan-2019
DBMS_DBFS_CONTENT_ADMIN has 3 new objects DBMS_DBFS_CONTENT_ADMIN 07-Jan-2019
DBMS_DDL_INTERNAL dropped two HAS_ objects DBMS_DDL_INTERNAL 08-Jan-2019
DBMS_DM_UTIL has 6 objects removed DBMS_DM_UTIL 13-Dec-2018
DBMS_DEBUG has new GET_DIAGNOSTIC_LEVEL and GET_TIMEOUT objects DBMS_DEBUG 08-Jan-2019
DBMS_DNFS has new RESTORE_DATAFILE_PERMISSIONS object DBMS_DNFS 13-Dec-2018
DBMS_DRS has had 6 objects removed DBMS_DATA_MINING_INTERNAL 06-Dec-2018
DBMS_DRS has 27 new objects several with overloads DBMS_DRS 05-Dec-2018
DBMS_EDITIONS_UTILITIES has new CLEAN_UNUSABLE_EDITIONS procedures DBMS_EDITIONS_UTILITIES 31-Jan-2019
DBM_FREQUENT_ITEMSET has 3 new objects DBMS_FREQUENT_ITEMSET 13-Dec-2018
DBM_FS has new DESTROY_ORACLE_FS procedure DBMS_FS 13-Dec-2018
DBM_GOLDENGATE_ADM has new UPDATE_IDENTITY_COLUMN_HWM procedures DBMS_GOLDENGATE_ADM 31-Jan-2019
DBM_GSM_COMMON has 6 new objects DBMS_GSM_COMMON 17-Feb-2019
DBM_GSM_DBADMIN has 4 new objects DBMS_GSM_DBADMIN 18-Feb-2019
DBM_GSM_FIX has 2 new objects DBMS_GSM_FIX 18-Feb-2019
DBM_GSM_FIXED has 2 new objects DBMS_GSM_FIXED 18-Feb-2019
DBM_GSM_POOLADMIN has 8 new objects DBMS_GSM_POOLADMIN 18-Feb-2019
DBM_GSM_UTILITY has 8 new objects DBMS_GSM_UTILITY 18-Feb-2019
DBM_HADOOP_INTERNAL has 4 new objects DBMS_HADOOP_INTERNAL 19-Feb-2019
DBMS_HPROF has new CREATE_TABLES procedure DBMS_HPROF 14-Mar-2018
DBMS_ISCHED relocated 3 objects, see above, and removed GET_CREDENTIAL_PASSWORD DBMS_ISCHED 23-Mar-2019
DBMS_ISCHED has 10 new objects DBMS_ISCHED 23-Mar-2019
DBMS_LOGREP_UTIL has 25 new obects, 2 with overloads DBMS_LOGREP_UTIL 17-Dec-2018
DBMS_LOGREP_UTIL_INVOK has 2 new obects, DBMS_LOGREP_UTIL_INVOK 18-Dec-2018
DBMS_MANAGEMENT_PACKS has new PURGE_SQLSETS procedures DBMS_MANAGEMENT_PACKS 23-Mar-2019
DBMS_METADATA removed the 2 VAT_TABLE_NAME objects DBMS_METADATA 25-Dec-2018
DBMS_METADATA has new CHECK_CONSTRAINT function DBMS_METADATA 25-Dec-2018
DBMS_METADATA_UTIL dropped PARSE_CONDITION, DEFAULT, and QUERY DBMS_METADATA_UTIL 24-Mar-2019
DBMS_METADATA_UTIL has 5 new objects DBMS_METADATA_UTIL 24-Mar-2019
DBMS_NETWORK_ACL_ADMIN.INSTANCE_EXPORT_ACTION dropped DBMS_NETWORK_ACL_ADMIN 06-Feb-2019
DBMS_OBJECTS_UTILS has new PERSISTABLE_DOWNGRADE_CHECK function DBMS_OBJECTS_UTILS 22-Dec-2018
DBMS_PDB has removed REMOVE_LINK and UPDATE_OBJLINK_STATS DBMS_PDB 29-Jun-2018
DBMS_PDB has 5 new objects DBMS_PDB 29-Jun-2018
DBMS_PLSQL_CODE_COVERAGE dropped ANALYZE, FLUSH, RESET objects DBMS_PLSQL_CODE_COVERAGE 24-Mar-2019
DBMS_QOPATCH has 4 new objects DBMS_QOPATCH 19-Jan-2019
DBMS_RCVVPC has 4 new objects DBMS_RCVVPC 03-Apr-2019
DBMS_REDEFINITION has 5 new objects DBMS_REDEFINITION 22-Nov-2018
DBMS_SESSION has 5 new objects DBMS_SESSION 30-May-2018
DBMS_PREUP ... has the same name and function as previous versions but contents all new DBMS_PREUP 30-Sep-2018
DBMS_SPM has new LOAD_PLANS_FROM_AWR function DBMS_SPM 08-Dec-2018
DBMS_SQLPATCH has 8 new objects and dropped VERIFY_QUERYABLE_INVENTORY DBMS_SQLPATCH 01-Oct-2018
DBMS_SQL has new BIND_VARIABLE_PKG and VARIABLE_VALUE_PKG objects DBMS_SQL 05-Dec-2018
DBMS_SQLDIAG has new SQL_DIAGNOSE_AND_REPAIR function with 3 overloads DBMS_SQLDIAG 11-Apr-2019
DBMS_SQLDIAG_INTERNAL has 6 new objects DBMS_SQLDIAG_INTERNAL 11-Apr-2019
DBMS_SQLTUNE has 6 new objects DBMS_SQLTUNE 09-Jul-2018
DBMS_STREAMS_TABLESPACE_ADM has 2 new objects DBMS_STREAMS_TABLESPACE_ADM 06-Feb-2019
DBMS_TF contains 11 new objects DBMS_TF 12-Apr-2018
DBMS_TG_DBG has new SET_SESSION_DRAINABLE procedure DBMS_TG_DBG 27-Jan-2019
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_WORKLOAD_REPOSITORY has 8 new objects DBMS_WORKLOAD_REPOSITORY 27-Jan-2019
DBMS_WRR_INTERNAL dropped the 3 objects from 12c and added 4 new objects DBMS_WRR_INTERNAL 10-Feb-2019
DBMS_WRR_PROTECTED dropped the 2 objects from 12c and added 3 new objects DBMS_WRR_PROTECTED 26-Jan-2019
DBMS_XMLSCHEMA has new GETSCHEMAELEMENTNAME function DBMS_XMLSCHEMA 22-Mar-2019
DBMS_XPLAN has 2 new objects DBMS_XPLAN 23-May-2018
DBMS_XSTREAM_ADM has new GET_IS_XSTREAM function DBMS_XSTREAM_ADM 10-Feb-2019
DBMS_XS_PRINCIPALS ADD and REMOVE schema proxy objects dropped DBMS_XS_PRINCIPALS 22-Nov-2018
KUBSAGT has new DESCRIBE_VERSION function KUBSAGT 06-Jul-2018
KUPP$PROC has three new objects KUPP$PROC 17-Feb-2019
PRVTEMX_DBHOME has 4 objects removed and 2 new objects PRVTEMX_DBHOME 20-Nov-2018
PRVT_AWR_VIEWER has 14 new objects PRVT_AWR_VIEWER 20-Nov-2018
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_CHARACTER_ENCODING function UTL_I18N 27-Jul-2018
XS_ADMIN_UTIL has new VALIDATE_DB_USER procedure XS_ADMIN_UTIL 26-Jul-2018
XS_PRINCIPAL has new SET_ACL procedure XS_PRINCIPAL 06-Feb-2019
 
Built-in Packages with New or Removed Overloads
DBMS_FILE_TRANSFER.COPY_FILE has 1 new overload DBMS_FILE_TRANSFER 31-Jan-2019
DBM_GSM_COMMON.RESETDBPARAMETER has 1 new overload DBMS_GSM_COMMON 17-Feb-2019
DBM_GSM_COMMON.SETDBPARAMETER has 3 new overloads DBMS_GSM_COMMON 17-Feb-2019
DBMS_HPROF ANALYZE has 2 new overloads, START_PROFILING has 1 DBMS_HPROF 14-Mar-2018
DBMS_SQLTUNE.BIND_VARIABLE and VARIABLE_VALUE have new overloads DBMS_SQL 05-Dec-2018
DBMS_SQLTUNE.CREATE and SCHEDULE _TUNING TASK has 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_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_XPLAN.PREPARE_RECORDS has 4 new parameters DBMS_XPLAN 23-May-2018
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_ADR_APP has new NOERROR and PURGE_DEFAULT_THRESHOLD constants DBMS_ADR_APP 29-Dec-2018
DBMS_AUDIT_MGMT has 2 new Partition Interval constants DBMS_AUDIT_MGMT 05-Dec-2018
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_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 12.2
New in 19c
New in 20c
New in 21c
  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-2023 Daniel A. Morgan All Rights Reserved
  DBSecWorx