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
|
USERS |
03-May-2018 |
New Roles
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
Deprecated/Dropped Object Privileges
|
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 |