New In Oracle Database
Version 12.1

Description Link Last Modified
Architecture
New CREATE, ALTER, and DROP PLUGGABLE DATABASE Plugable Database 17-Feb-2014
CDB$ROOT Database (RDB) Plugable Database 17-Feb-2014
PDB$SEED Seed PDB PDB$SEED 14-Jul-2013
Pluggable Database (PDB) Plugable Database 17-Feb-2014
Configurable Threaded Execution Threaded Execution 19-Jul-2013
Common Profiles PROFILES 24-Apr-2015
Common Roles ROLES 07-Mar-2015
Common Users USERS 28-Jun-2013
 
General
New Roles
  • ADM_PARALLEL_EXECUTE_TASK
  • APEX_GRANTS_FOR_NEW_USERS_ROLE
  • AUDIT_ADMIN
  • AUDIT_VIEWER
  • CAPTURE_ADMIN
  • CDB_DBA
  • DBHADOOP
  • DV_AUDIT_CLEANUP
  • DV_GOLDENGATE_ADMIN
  • DV_GOLDENGATE_REDO_ACCESS
  • DV_MONITOR
  • DV_PATCH_ADMIN
  • DV_STREAMS_ADMIN
  • DV_XSTREAM_ADMIN
  • EM_EXPRESS_ALL
  • EM_EXPRESS_BASIC
  • GSMADMIN_ROLE
  • GSMUSER_ROLE
  • GSM_POOLADMIN_ROLE
  • HS_ADMIN_SELECT_ROLE
  • LBAC_DBA
  • OPTIMIZER_PROCESSING_RATE
  • PDB_DBA
  • PROVISIONER
  • XS_CACHE_ADMIN
  • XS_NAMESPACE_ADMIN
  • XS_RESOURCE
  • XS_SESSION_ADMIN
Deprecated Roles
  • DELETE_CATALOG_ROLE
Deprecated Role Privileges
  • RESOURCE role no longer grants the UNLIMITED TABLESPACE system privilege by default
ROLES 23-Dec-2013
New System Privileges
  • ADMINISTER KEY MANAGEMENT
  • ALTER ANY CUBE BUILD PROCESS
  • ALTER ANY MEASURE FOLDER
  • ALTER ANY SQL TRANSLATION PROFILE
  • CREATE ANY CREDENTIAL
  • CREATE ANY SQL TRANSLATION PROFILE
  • CREATE CREDENTIAL
  • CREATE PLUGGABLE DATABASE
  • CREATE SQL TRANSLATION PROFILE
  • DROP ANY SQL TRANSLATION PROFILE
  • EM EXPRESS CONNECT
  • EXEMPT ACCESS POLICY
  • EXEMPT DDL REDACTION POLICY
  • EXEMPT DML REDACTION POLICY
  • EXEMPT IDENTITY POLICY
  • EXEMPT REDACTION POLICY
  • INHERIT ANY PRIVILEGES
  • KEEP_DATE TIME
  • KEEP_SYSGUID
  • LOGMINING
  • PURGE DBA_RECYCLEBIN
  • REDEFINE ANY TABLE
  • SELECT ANY CUBE BUILD PROCESS
  • SELECT ANY MEASURE FOLDER
  • SET CONTAINER
  • SYSBACKUP
  • SYSDG
  • SYSKM
  • TRANSLATE ANY SQL
  • USE ANY SQL TRANSLATION PROFILE
SYSTEM PRIVILEGES 01-Oct-2013
Column size for many common data dictionary common columns have been increased from 30 to 128 bytes DATA DICTIONARY 27-Jun-2013
Automatic Data Optimization (ADO) ADO 07-Dec-2013
Containers Clause (querying across multiple containers) - -
Flashback Database Support for Container Databases Flashback Archive 15-Sep-2014
Full Database Caching In Memory Database 05-Nov-2014
In-Memory Aggregation - -
Data Guard Far Sync Data Guard -
Data Guard FastSync Data Guard -
In-Memory Column Store In Memory Database 27-Mar-2016
RMAN single table recovery RMAN -
 
Deprecated or Dropped
Change Data Capture is desupported (section 8.2.2) Click Here 23-Dec-2013
Compilation parameter PLSQL_DEBUG has been dropped - 02-Jan-2015
Globalization Support Changes (section 8.4) Click Here 23-Dec-2013
Streams is desupported (section 8.1.6) Click Here 23-Dec-2013
Data mining Java API is desupported (DBMS_DATA_MINING and DBMS_DATA_MINING_TRANSFORM) (section 8.2.3) Click Here 23-Dec-2013
Stored Outlines are deprecated (use Baselines) (section 8.1.14.3) Click Here 23-Dec-2013
A number of startup (init) parameters now deprecated Click Here 23-Dec-2013
Dynamic performance views gv$logmnr_callback and gv$logmnr_region dropped Dynamic Performance Views 09-Jul-2013
Package BLAST_CUR dropped Built-in Packages 29-Jun-2013
Package DVSYS.CODE$_PRIV dropped Built-in Packages 25-Oct-2014
Package DVSYS.COMMAND_RULE$_PRIV dropped Built-in Packages 25-Oct-2014
Package CWM2_OLAP_INSTALLER dropped Built-in Packages 29-Jun-2013
Package DBMSNCDB dropped Built-in Packages 29-Jun-2013
Package DBMS_AMD dropped Built-in Packages 29-Jun-2013
Package DBMS_APPCTX dropped Built-in Packages 29-Jun-2013
Package DBMS_DBLINK dropped Built-in Packages 29-Jun-2013
Package DBMS_JDM_INTERNAL dropped Built-in Packages 29-Jun-2013
Package DBMS_OWB dropped dropped Built-in Packages 29-Jun-2013
Package DBMS_RULE_COMPATIBLE_90 dropped Built-in Packages 29-Jun-2013
Package DBMS_SQL2, (only in 11gR2) dropped ... EXPAND_SQL_TEXT relocated to DBMS_UTILITY and PARSE to DBMS_SQL Built-in Packages 29-Jun-2013
Package DBMS_XDB deprecated DBMS_XDB 05-Feb-2014
Package DBMS_XDSUTL dropped Built-in Packages 29-Jun-2013
Package DBMS_XS_MTCACHE_FFI dropped Built-in Packages 29-Jun-2013
Package DBMS_XS_PRINCIPALS_INT dropped Built-in Packages 29-Jun-2013
Package DBMS_XS_PRINCIPAL_EVENTS_INT dropped Built-in Packages 29-Jun-2013
Package DBMS_XS_ROLESET_EVENTS_INT dropped Built-in Packages 29-Jun-2013
Package HTMLDB_SYSTEM dropped in 12.1.0.2 Built-in Packages 08-Nov-2014
Package MGMT_BSLN dropped Built-in Packages 29-Jun-2013
Package MGMT_BSLN_INTERNAL dropped Built-in Packages 29-Jun-2013
Package MGMT_DM dropped Built-in Packages 29-Jun-2013
Package MGMT_PREFERENCES dropped Built-in Packages 29-Jun-2013
Package MGMT_TARGET dropped Built-in Packages 29-Jun-2013
Package MGMT_USER dropped Built-in Packages 29-Jun-2013
Package ODM_ABN_MODEL dropped Built-in Packages 29-Jun-2013
Package OWA_DEBUG dropped Built-in Packages 08-Nov-2014
Package OWA_DEBUG_DEMO dropped Built-in Packages 08-Nov-2014
Package OWA_DEBUG_JDWP dropped Built-in Packages 08-Nov-2014
Package OWA_DEBUG_PROFILER dropped Built-in Packages 08-Nov-2014
Package OWA_DEBUG_TRACE dropped Built-in Packages 08-Nov-2014
Package XS$CATVIEW_UTIL dropped Built-in Packages 29-Jun-2013
Dynamic performance view GV$FALSE_PING deprecated Dynamic Performance Views 02-June-2015
WMSYS CONCAT Function dropped WMSYS Functions 26-Sep-2013
Numerous X$ objects dropped including X$KCLH, X$KCLFI, and X$KCLDELTAST X$ Objects 11-Mar-2015
 
New SQL
Constraints ONLINE DROP CONSTRAINT clause CONSTRAINTS 30-Sep-2013
CREATE DATABASE ... ENABLE PLUGGABLE DATABASE syntax DATABASE 11-Jun-2014
CREATE PLUGGABLE DATABASE syntax DATABASE 11-Jun-2014
ADVANCED INDEX COMPRESSION COMPRESSION 11-Jun-2014
ALTER DATABASE FULL_DATABASE_RECOVERY Clause for recovery from storage snapshots DATABASE 11-Jun-2014
ALTER DATABASE MOVE_DATAFILE_CLAUSE DATABASE 11-Jun-2014
ALTER DATABASE Control File management clauses DATABASE 11-Jun-2014
ALTER DATABASE Switch-Over and Fail-Over clauses DATABASE 11-Jun-2014
APPROX_COUNT_DISTINCT Function Numeric Functions 11-Sep-2014
Attribute Clustering TABLES 15-Sep-2014
Automatic Big Table Cache - 15-Sep-2014
CREATE USER syntax updated to include Editions and Containers USERS 28-Jun-2013
CLEANUP keyword added to ALTER INDEX ... COALESCE INDEXES 16-Oct-2013
Identity Columns Identity Columns 01-Sep-2013
Materialized Zonemap Miscellaneous Functions 05-Mar-2017
JSON Conditions and Functions JSON Functionality 30-Jan-2016
MATCH_RECOGNIZE clause for SELECT statements to be used for Map Reduce MAP REDUCE -
Model Clause extended with new NEXT and PREV functions Model Clause -
USING TRUSTED CONSTRAINTS clause for Materialized Views Materialized Views 17-Jul-2014
USING TRUSTED CONSTRAINTS clause for Partitioned Materialized Views PARTITIONING 23-Mar-2014
KEEP and NOKEEP syntax for SEQUENCES affecting the NEXTVAL pseudocolumn during REPLAY SEQUENCES 29-Jun-2013
SESSION and GLOBAL syntax for CREATE and ALTER SEQUENCES SEQUENCES 29-Jun-2013
32K maximum size for VARCHAR2 and NVARCHAR2 columns in tables and views TABLES 15-Sep-2014
Table Evaluate Edition Clause TABLES 15-Sep-2014
Table ILM Policy Clause TABLES 15-Sep-2014
Table Invisible / Invisible Column Clause TABLES 15-Sep-2014
Table Tiering TABLES 15-Sep-2014
Table Unusable Editions Clause TABLES 15-Sep-2014
PERIOD_DEFINITION Clause TEMPORAL VALIDITY 19-Nov-2013
ON_NULL Clause for CREATE and ALTER Table TABLES 15-Sep-2014
VISIBLE | INVISIBLE Clause TABLES 15-Sep-2014
CASCADE Clause and new Asynchronous Global Index Maintenance for Partitioned Tables TRUNCATE 01-Jan-2014
Unified Auditing with CREATE, ALTER, and DROP AUDIT POLICY statements, and AUDIT, NOAUDIT Unified Audit Policy 04-Nov-2015
Unified Key Management interface for TDE with ADMINISTER KEY MANAGEMENT Transparent Data Encryption 19-Mar-2015
 
New PL/SQL
ACCESSIBLE BY Clause ACCESSIBLE BY 29-Jul-2014
FETCH FIRST Clause BULK COLLECT 09-Jun-2014
PL/SQL Predefined Inquiry Directives ($$PLSQL_UNIT_OWNER, $$PLSQL_UNIT_TYPE, and compilation parameters) Predefined Inquiry Directives 14-Feb-2014
Invoker’s Rights Functions Can Be Result-Cached DBMS_RESULT_CACHE 25-Nov-2014
More PL/SQL-Only Data Types Can Cross PL/SQL-to-SQL Interface - -
Roles can be granted to PL/SQL Packages and Standalone Subprograms ROLES 11-Jun-2014
More Data Types Have Same Maximum Size in SQL and PL/SQL Data Types 13-May-2014
A Library Can Be Defined as a DIRECTORY Object and With CREDENTIAL - -
Implicit Statement Results - -
UPDATE Triggers for LOB Columns and LOGICAL LOB UPDATE Triggers - -
BEQUEATH CURRENT_USER Views - -
INHERIT PRIVILEGES and INHERIT ANY PRIVILEGES Privileges - -
Objects, Not Types, Are Editioned or Noneditioned with a new ALTER syntax Procedures 03-Jul-2013
PL/SQL Functions That Run Faster in SQL - -
PDB_NAME attribute in the ALERT_TYPE data type - -
 
New or Modified Functions, Operators, Procedures, and Types
SYS.ALERT_TYPE has new PDB_NAME column - 20-Mar-2014
CLASSIFIER function as part of Map Reduce MAP REDUCE -
CLUSTER_DETAILS, CLUSTER_DISTANCE, and FEATURE_DETAILS Analytic Functions Analytic Functions 26-Aug-2013
CLUSTER_DETAILS, CLUSTER_DISTANCE, and FEATURE_DETAILS Analytic Functions Data Mining Functions 12-Sep-2013
CON_DBID_TO_ID, CON_GUID_TO_ID, CON_NAME_TO_ID, and CON_UID_TO_ID functions supporting CDBs PDB$SEED -14-Jul-2013
DBMS_FEATURE_ACTIVE_DATA_GUARD procedure DBMS_FEATURE_USAGE Procs 12-Nov-2014
DBMS_FEATURE_ADAPTIVE_PLANS procedure DBMS_FEATURE_USAGE Procs 12-Nov-2014
DBMS_FEATURE_ADV_IDXCMP procedure DBMS_FEATURE_USAGE Procs 12-Nov-2014
DBMS_FEATURE_ADV_TABCMP procedure DBMS_FEATURE_USAGE Procs 12-Nov-2014
DBMS_FEATURE_AUDIT_OPTIONS procedure DBMS_FEATURE_USAGE Procs 12-Nov-2014
DBMS_FEATURE_AUTO_REOPT procedure DBMS_FEATURE_USAGE Procs 12-Nov-2014
DBMS_FEATURE_BA_OWNER procedure DBMS_FEATURE_USAGE Procs 12-Nov-2014
DBMS_FEATURE_CONCURRENT_STATS procedure DBMS_FEATURE_USAGE Procs 12-Nov-2014
DBMS_FEATURE_DATABASE_ODM procedure DBMS_FEATURE_USAGE Procs 12-Nov-2014
DBMS_FEATURE_DATA_REDACTION procedure DBMS_FEATURE_USAGE Procs 12-Nov-2014
DBMS_FEATURE_DBFS_CONTENT procedure DBMS_FEATURE_USAGE Procs 12-Nov-2014
DBMS_FEATURE_DBFS_HS procedure DBMS_FEATURE_USAGE Procs 12-Nov-2014
DBMS_FEATURE_DBFS_SFS procedure DBMS_FEATURE_USAGE Procs 12-Nov-2014
DBMS_FEATURE_EMX procedure DBMS_FEATURE_USAGE Procs 12-Nov-2014
DBMS_FEATURE_FGA_AUDIT procedure DBMS_FEATURE_USAGE Procs 12-Nov-2014
DBMS_FEATURE_GATEWAYS procedure DBMS_FEATURE_USAGE Procs 12-Nov-2014
DBMS_FEATURE_GOLDENGATE procedure DBMS_FEATURE_USAGE Procs 12-Nov-2014
DBMS_FEATURE_HCCRLL procedure DBMS_FEATURE_USAGE Procs 12-Nov-2014
DBMS_FEATURE_HEATMAP procedure DBMS_FEATURE_USAGE Procs 12-Nov-2014
DBMS_FEATURE_IDH procedure DBMS_FEATURE_USAGE Procs 12-Nov-2014
DBMS_FEATURE_ILM procedure DBMS_FEATURE_USAGE Procs 12-Nov-2014
DBMS_FEATURE_IMA procedure DBMS_FEATURE_USAGE Procs 12-Nov-2014
DBMS_FEATURE_IMC procedure DBMS_FEATURE_USAGE Procs 12-Nov-2014
DBMS_FEATURE_IOT procedure DBMS_FEATURE_USAGE Procs 12-Nov-2014
DBMS_FEATURE_JSON procedure DBMS_FEATURE_USAGE Procs 12-Nov-2014
DBMS_FEATURE_LABEL_SECURITY procedure DBMS_FEATURE_USAGE Procs 12-Nov-2014
DBMS_FEATURE_MOVE_DATAFILE procedure DBMS_FEATURE_USAGE Procs 12-Nov-2014
DBMS_FEATURE_ONLINE_REDEF procedure DBMS_FEATURE_USAGE Procs 12-Nov-2014
DBMS_FEATURE_PILLAR_EHCC procedure DBMS_FEATURE_USAGE Procs 12-Nov-2014
DBMS_FEATURE_PILLAR_STORAGE procedure DBMS_FEATURE_USAGE Procs 12-Nov-2014
DBMS_FEATURE_PRIV_CAPTURE procedure DBMS_FEATURE_USAGE Procs 12-Nov-2014
DBMS_FEATURE_RAS procedure DBMS_FEATURE_USAGE Procs 12-Nov-2014
DBMS_FEATURE_ROND procedure DBMS_FEATURE_USAGE Procs 12-Nov-2014
DBMS_FEATURE_SEG_MAIN_ONL_COMP procedure DBMS_FEATURE_USAGE Procs 12-Nov-2014
DBMS_FEATURE_SPD procedure DBMS_FEATURE_USAGE Procs 12-Nov-2014
DBMS_FEATURE_STREAMS procedure DBMS_FEATURE_USAGE Procs 12-Nov-2014
DBMS_FEATURE_TSDP procedure DBMS_FEATURE_USAGE Procs 12-Nov-2014
DBMS_FEATURE_UNIFIED_AUDIT procedure DBMS_FEATURE_USAGE Procs 12-Nov-2014
DBMS_FEATURE_XSTREAM_IN procedure DBMS_FEATURE_USAGE Procs 12-Nov-2014
DBMS_FEATURE_XSTREAM_OUT procedure DBMS_FEATURE_USAGE Procs 12-Nov-2014
DBMS_FEATURE_XSTREAM_STREAMS procedure DBMS_FEATURE_USAGE Procs 12-Nov-2014
DBMS_FEATURE_ZFS_EHCC procedure DBMS_FEATURE_USAGE Procs 12-Nov-2014
DBMS_FEATURE_ZFS_STORAGE procedure DBMS_FEATURE_USAGE Procs 12-Nov-2014
DBMS_FEATURE_ZMAP procedure DBMS_FEATURE_USAGE Procs 12-Nov-2014
DBMS_PDB_EXEC_SQL procedure Undocumented Oracle 30-Nov-2014
ORA_DST_AFFECTED function for use with DBMS_DST DBMS_DST 11-Jul-2013
ORA_DST_CONVERT, function for use with DBMS_DST DBMS_DST 11-Jul-2013
ORA_DST_ERROR function for use with DBMS_DST DBMS_DST 11-Jul-2013
ORA_INVOKING_USER function Miscellaneous Functions 01-Sep-2013
ORA_INVOKING_USERID function Miscellaneous Functions 01-Sep-2013
STANDARD_HASH function Miscellaneous Functions 01-Sep-2013
System Event Triggering for AFTER CLONE and BEFORE UNPLUG System Event Triggers 09-Jun-2014
SYS_CONTEXT functionality with CDB_NAME, CON_NAME, DBLINK_INFO attributes SYS_CONTEXT 24-Jul-2013
SYS_SESSION_ROLES context SYS_CONTEXT 24-Jul-2013
SYS_OP_ZONE_ID Function Miscellaneous Functions 05-Mar-2017
 
XML
INSERTCHILDXMLAFTER function XML Functions 27-Aug-2013
INSERTCHILDXMLBEFORE function XML Functions 27-Aug-2013
 
New Built-In Packages
AMGT$DATAPUMP package with one procedure AMGT$DATAPUMP 07-Apr-2015
APEX_DATAPUMP_SUPPORT with 2 objects APEX_DATAPUMP_SUPPORT -
CDBVIEW package with 1 object which worked in 12.1.0.1 and is broken in 12.1.0.2 CDBVIEW 05-Dec-2014
DBMS_ADR_APP package with 10 objects DBMS_ADR_APP 25-Oct-2014
DBMS_ADR_INTERNAL package with 10 objects DBMS_ADR_INTERNAL -25-Oct-2014
DBMS_APPLY_ADM_IVK package with 1 object DBMS_APPLY_ADM_IVK 25-Oct-2014
DBMS_APP_CONT package with 1 object DBMS_APP_CONT 25-Oct-2014
DBMS_AUTO_REPORT package with 7 objects DBMS_AUTO_REPORT 28-Oct-2014
DBMS_AUTO_REPORT_INTERNAL package with 2 objects DBMS_AUTO_REPORT_INTERNAL 29-Oct-2014
DBMS_BA_POOL package with 24 objects DBMS_BA_POOL 14-Feb-2017
DBMS_CAPTURE_ADM_IVK package with 9 objects DBMS_CAPTURE_ADM_IVK 07-Nov-2014
DBMS_CLOBUTIL package with 11 objects DBMS_CLOBUTIL 17-Oct-2014
DBMS_CLR and its creation file were not found in 12.1.0.1 but is back with 12.1.0.2 DBMS_CLR 17-Oct-2014
DBMS_CREDENTIAL package with 5 objects DBMS_CREDENTIAL 09-Nov-2014
DBMS_EXPORT_EXTENSION_I package with 28 objects DBMS_EXPORT_EXTENSION_I 28-Oct-2014
DBMS_FS package with 3 non-functional objects DBMS_FS 13-Nov-2014
DBMS_HEAT_MAP package with 6 objects DBMS_HEAT_MAP 10-Oct-2016
DBMS_ILM package with 10 objects DBMS_ILM 16-Nov-2014
DBMS_ILM_ADMIN with 3 objects DBMS_ILM_ADMIN 16-Nov-2014
DBMS_INMEMORY package with 11 objects DBMS_INMEMORY 16-Oct-2014
DBMS_INTERNAL_CLKM package with 1 procedure DBMS_INTERNAL_CLKM 19-Mar-2015
DBMS_INTERNAL_ROLLING package with 11 objects DBMS_INTERNAL_ROLLING 16-Nov-2014
DBMS_ISYNCREF package with 3 objects DBMS_ISYNCREF 16-Nov-2014
DBMS_JAVA_MISC package with 16 objects in 12.1.0.1 but only 2 in 12.1.0.2: each with 2 overloads DBMS_JAVA_MISC 16-Nov-2014
DBMS_LOG package with 4 objects DBMS_LOG 17-Nov-2014
DBMS_LOGSTDBY_CONTEXT package with 4 objects DBMS_LOGSTDBY_CONTEXT 17-Nov-2014
DBMS_OBJECTS_APPS_UTILS package with 2 objects DBMS_OBJECTS_APPS_UTILS 18-Oct-2014
DBMS_PART package with 2 objects DBMS_PART 19-Nov-2014
DBMS_PDB package with 14 objects DBMS_PDB 19-Nov-2014
DBMS_PERF package with 7 objects DBMS_PERF 19-Nov-2014
DBMS_PREUP package with 228 objects: many overloaded DBMS_PREUP 22-Oct-2015
DBMS_PRIVILEGE_CAPTURE package with 5 objects DBMS_PRIVILEGE_CAPTURE 26-Jun-2015
DBMS_PRIV_CAPTURE package with 15 objects DBMS_PRIV_CAPTURE 22-Nov-2014
DBMS_PRVTSQDS package with 14 objects DBMS_PRVTSQDS -
DBMS_PRVTSQIS package with 13 objects DBMS_PRVTSQIS -
DBMS_QOPATCH package with 10 objects DBMS_QOPATCH 22-Nov-2014
DBMS_RAT_MASK package with 9 objects DBMS_RAT_MASK 22-Nov-2014
DBMS_RECTIFIER_DIFF_INTERNAL package with 4 objects DBMS_RECTIFIER_DIFF_INTERNAL 22-Nov-2014
DBMS_REDACT with 8 objects for Data Redaction and Transparent Sensitive Data Protection DBMS_REDACT 22-Nov-2014
DBMS_REDACT_INT with 10 objects for Data Redaction and Transparent Sensitive Data Protection DBMS_REDACT_INT -
DBMS_RESULT_CACHE_INTERNAL package with 1 object DBMS_RESULT_CACHE_INTERNAL 12-Nov-2014
DBMS_RMIN_SYS package with 39 objects plus overloads DBMS_RMIN_SYS -
DBMS_ROLLING package with 8 objects DBMS_ROLLING 25-Nov-2014
DBMS_SCHED_ARGUMENT_IMPORT package with 3 objects DBMS_SCHED_ARGUMENT_IMPORT -
DBMS_SCN package with 11 objects DBMS_SCN 16-Oct-2014
DBMS_SECUREFILE_LOG_ADMIN package with 2 objects DBMS_SECUREFILE_LOG_ADMIN 25-Nov-2014
DBMS_SERVICE_ERR package with 2 objects DBMS_SERVICE_ERR 25-Nov-2014
DBMS_SERVICE_PRVT package with 6 objects DBMS_SERVICE_PRVT 25-Nov-2014
DBMS_SPD package with 9 objects DBMS_SPD 29-Nov-2014
DBMS_SPD_INTERNAL package with 10 objects DBMS_SPD_INTERNAL -
DBMS_SQADM_SYSCALLS package with 4 objects DBMS_SQADM_SYSCALLS 30-Jan-2018
DBMS_SQLPATCH package with 11 objects DBMS_SQLPATCH 16-Oct-2014
DBMS_SQL_MONITOR package with 6 objects DBMS_SQL_MONITOR 03-Dec-2014
DBMS_SQL_TRANSLATOR package with 18 objects DBMS_SQL_TRANSLATOR 01-Feb-2016
DBMS_SQL_TRANSLATOR_EXPORT package with 6 objects DBMS_SQL_TRANSLATOR_EXPORT 03-Dec-2014
DBMS_STREAMS_ADM_IVK package with 43 objects DBMS_STREAMS_ADM_IVK -
DBMS_SYNC_REFRESH with 14 objects for synchronizing CDBs and PDBs DBMS_SYNC_REFRESH 08-Dec-2014
DBMS_TSDP_MANAGE with 9 documented objects for managing sensitive columns and types supporting Transparent Sensitive Data Protection DBMS_TSDP_MANAGE 08-Dec-2014
DBMS_TSDP_PROTECT with 10 objects for Transparent Sensitive Data Protection DBMS_TSDP_PROTECT 08-Dec-2014
DBMS_XSTREAM_AUTH_IVK with 4 objects DBMS_XSTREAM_AUTH_IVK 20-Dec-2014
DBMS_XSTREAM_GG_INTERNAL with 2 objects DBMS_XSTREAM_GG_INTERNAL -
DBMS_XS_FIDM with 3 objects DBMS_XS_FIDM 25-Dec-2015
DBMS_XS_NSATTR with 1 object DBMS_XS_NSATTR -
DBMS_XS_SIDP with 2 objects DBMS_XS_SIDP 25-Dec-2015
DBMS_XS_SYSTEM with 4 objects supporting Real Application Security DBMS_XS_SYSTEM 25-Dec-2015
DBMS_XS_SYSTEM_FFI with 4 objects supporting Real Application Security DBMS_XS_SYSTEM_FFI 25-Dec-2015
DMCLAIMP with 6 objects DMCLAIMP -
DMCLBIMP with 6 objects DMCLBIMP -
DMFEBIMP with 6 objects DMFEBIMP -
DMGLMBIMP with 18 objects DMGLMBIMP -
DMSVMAIMP with 12 objects DMSVMAIMP -
DM_FE_CUR package header with no package body DM_FE_CUR -
HTMLDB_UTIL with 162 objects HTMLDB_UTIL 20-Mar-2015
JAVAVM_SYS with 2 objects JAVAVM_SYS 20-Dec-2014
KBRSI_ICD with 54 objects KBRSI_ICD -
KUBSAGT with 7 objects KUBSAGT 08-Nov-2014
OJDS_CONTEXT with 16 objects OJDS_CONTEXT -
OJDS_NAMESPACE with 3 objects OJDS_NAMESPACE -
ORDAUDIOEXCEPTIONS package header with no package bodfy ORDAUDIOEXCEPTIONS 16-Dec-2014
ORDSOURCEEXCEPTIONS package header with no package bodfy ORDSOURCEEXCEPTIONS 16-Dec-2014
ORDVIDEOEXCEPTIONS package header with no package bodfy ORDVIDEOEXCEPTIONS 16-Dec-2014
PRVTEMX_ADMIN with 53 objects PRVTEMX_ADMIN 29-Dec-2014
PRVTEMX_CELL with 2 objects PRVTEMX_CELL 29-Dec-2014
PRVTEMX_DBHOME with 23 objects PRVTEMX_DBHOME 29-Dec-2014
PRVTEMX_MEMORY with 1 object PRVTEMX_MEMORY 09-Dec-2014
PRVTEMX_PERF with 2 objects PRVTEMX_PERF 09-Dec-2014
PRVTPARENTCHILD with 2 objects PRVTPARENTCHILD -
PRVT_AWRV_METADATA with 7 objects PRVT_AWRV_METADATA -
PRVT_AWR_DATA with 27 objects PRVT_AWR_DATA -
PRVT_AWR_DATA_CP package with 4 objects PRVT_AWR_DATA_CP -
PRVT_AWR_INST_META package with 1 object PRVT_AWR_INST_META -
PRVT_AWR_PERIOD package with 5 objects PRVT_AWR_PERIOD -
PRVT_AWR_VIEWER package with 12 objects PRVT_AWR_VIEWER 02-Jan-2015
PRVT_CPADDM package with 8 objects PRVT_CPADDM -
PRVT_EMX package with 16 objects PRVT_EMX -
PRVT_HDM package with 6 objects PRVT_HDM -
PRVT_ILM package with 45 objects PRVT_ILM -
PRVT_RTADDM package with 3 objects PRVT_RTADDM -
PSTDY_DATAPUMP_SUPPORT package with 2 objects PSTDY_DATAPUMP_SUPPORT 09-Dec-2014
TSDP$DATAPUMP package with 1 object TSDP$DATAPUMP 09-Dec-2014
UTL_CALL_STACK package with 13 objects UTL_CALL_STACK 02-Jan-2015
UTL_ORAMTS package with 11 objects UTL_ORAMTS 02-Sep-2014
WWV_FLOW_KEY orphan package header WWV_FLOW_KEY 08-Nov-2014
XS_ACL package with 9 objects XS_ACL -
XS_ACL_INT package with 9 objects XS_ACL_INT -
XS_ADMIN_INT package with 8 objects XS_ADMIN_INT -
XS_ADMIN_UTIL package with 11 objects XS_ADMIN_UTIL 22-Dec-2015
XS_DATA_SECURITY package with 13 objects XS_DATA_SECURITY -
XS_DATA_SECURITY_INT package with 12 objects XS_DATA_SECURITY_INT -
XS_DATA_SECURITY_UTIL package with 5 objects XS_DATA_SECURITY_UTIL 24-Dec-2015
XS_DIAG package with 7 objects XS_DIAG -
XS_DIAG_INT package with 2 objects XS_DIAG_INT 14-Aug-2013
XS_MTCACHE_INT package with 3 objects XS_MTCACHE 23-Dec-2015
XS_NAMESPACE package with 6 objects and 3 overloads XS_NAMESPACE 25-Dec-2015
XS_NAMESPACE_INT package with 6 objects and 5 overloads XS_NAMESPACE_INT 25-Dec-2015
XS_OBJECT_MIGRATION package with 2 objects XS_OBJECT_MIGRATION -
XS_PRINCIPAL package with 22 objects XS_PRINCIPAL 22-Dec-2015
XS_PRINCIPAL_INT package with 24 objects XS_PRINCIPAL_INT -
XS_ROLESET package with 5 objects XS_ROLESET -
XS_ROLESET_INT package with 5 objects XS_ROLESET_INT -
XS_SECURITY_CLASS package with 9 objects XS_SECURITY_CLASS -
XS_SECURITY_CLASS_INT package with 9 objects XS_SECURITY_CLASS_INT -
 
Built-In Packages with New or Removed Functions and Procedures
CTX_DDL has 5 new objects CTX_DDL 25-Oct-2014
DBMS_ADDM has 5 new functions DBMS_ADDM 25-Oct-2014
DBMS_ADR has 7 new objects DBMS_ADR 25-Oct-2014
DBMS_APBACKEND has new GETSTOREID function DBMS_APBACKEND -
DBMS_APPLY_ADM has 4 new procedures one with an overload DBMS_APPLY_ADM 25-Oct-2014
DBMS_APPLY_ADM_INTERNAL.RECOVER_APPLY_PROGRESS dropped DBMS_APPLY_ADM_INTERNAL -
DBMS_APPLY_ADM_INTERNAL has 2 new objects DBMS_APPLY_ADM_INTERNAL -
DBMS_APP_CONT_PRVT has 2 new objects DBMS_APP_CONT_PRVT 25-Oct-2014
DBMS_AQ has 4 new objects DBMS_AQ 25-Oct-2014
DBMS_AQADM has 6 new objects for Sharded Pools and for Streams pool sizing DBMS_AQADM 26-Jun-2015
DBMS_AQADM_SYS has 9 new objects one of which is overloaded DBMS_AQADM_SYS -
DBMS_AQADM_SYSCALLS has 3 new objects DBMS_AQADM_SYSCALLS -
DBMS_AQELM has new GET_TXTIMEOUT procedure DBMS_AQELM 26-Oct-2014
DBMS_AQJMS has 17 new objects DBMS_AQJMS -
DBMS_AQJMS_INTERNAL has 3 new objects DBMS_AQJMS_INTERNAL -
DBMS_AQ_EXP_QUEUE_TABLES has 2 new objects DBMS_AQ_EXP_QUEUE_TABLES -
DBMS_AQ_IMP_INTERNAL has 6 new objects DBMS_AQ_IMP_INTERNAL -
DBMS_AQ_SYS_EXP_ACTIONS has 3 new objects DBMS_AQ_SYS_EXP_ACTIONS -
DBMS_AQ_SYS_EXP_INTERNAL has 5 new objects DBMS_AQ_SYS_EXP_INTERNAL -
DBMS_AQ_SYS_IMP_INTERNAL has 12 new objects DBMS_AQ_SYS_IMP_INTERNAL -
DBMS_ASH_INTERNAL has new ASH_SQL_FOR_AWR function DBMS_ASH_INTERNAL 27-Oct-2014
DBMS_AUDIT_MGMT has 5 new objects: 1 overloaded DBMS_AUDIT_MGMT 27-Oct-2014
DBMS_AUTO_REPORT has 7 new objects DBMS_AUTO_REPORT 28-Oct-2014
DBMS_AUTO_REPORT_INTERNAL has 2 new objects DBMS_AUTO_REPORT_INTERNAL 29-Oct-2014
DBMS_AUTO_TASK_ADMIN new DEFAULT_RESET procedure DBMS_AUTO_TASK_ADMIN 29-Oct-2014
DBMS_AW has new AW_IS_SYSTEM function DBMS_AW 06-Nov-2014
DBMS_AWR_REPORT_LAYOUT has 3 new objects DBMS_AWR_REPORT_LAYOUT 06-Nov-2014
DBMS_BACKUP_RESTORE has 43 new objects and overloads DBMS_BACKUP_RESTORE 26-Jan-2015
DBMS_CAPTURE_ADM_INTERNAL has 10 new objects DBMS_CAPTURE_ADM_INTERNAL -
DBMS_COMPRESSION has new DUMP_RECOMMESION_MAP procedure DBMS_COMPRESSION 09-Nov-2014
DBMS_CUBE has 8 new objects DBMS_CUBE 10-Nov-2014
DBMS_CUBE_UTIL new 2 new objects CREATE_RPT_FILTER with two overloads DBMS_CUBE_UTIL -
DBMS_DATAPUMP has 3 new objects in 12.1.0.1 and new filters and transforms in 12.1.0.2 DBMS_DATAPUMP 10-Nov-2014
DBMS_DATAPUMP_UTL has 4 new objects DBMS_DATAPUMP_UTL 10-Nov-2014
DBMS_DATA_MINING.GET_MODEL_DETAILS_ABN dropped DBMS_DATA_MINING -
DBMS_DATA_MINING has 4 new objects DBMS_DATA_MINING -
DBMS_DATA_MINING_INTERNAL.CREATE_TEMP_META_TABLE dropped DBMS_DATA_MINING_INTERNAL -
DBMS_DATA_MINING_INTERNAL has 3 new objects DBMS_DATA_MINING_INTERNAL -
DBMS_DBFS_CONTENT_ADMIN has 3 new objects DBMS_DBFS_CONTENT_ADMIN 11-Nov-2014
DBMS_DBFS_SFS_ADMIN has 11 new objects DBMS_DBFS_SFS_ADMIN 11-Nov-2014
DBMS_DM_EXP_INTERNAL has 8 objects removed DBMS_DM_EXP_INTERNAL -
DBMS_DM_IMP_INTERNAL package dropped DBMS_DM_EXP_INTERNAL -
DBMS_DM_MODEL_EXP.INSTANCE_INFO_EXP, SCHEMA_CALLOUT, and SCHEMA_INFO_EXP dropped DBMS_DM_MODEL_EXP -
DBMS_DM_MODEL_EXP has 5 new objects DBMS_DM_MODEL_EXP -
DBMS_DM_UTIL.DISPLAY_MSG and DUMP_MSG dropped DBMS_DM_UTIL -
DBMS_DM_UTIL has new NUMVAL object DBMS_DM_UTIL -
DBMS_DM_UTIL_INTERNAL package dropped DBMS_DM_UTIL_INTERNAL -
DBMS_EDITIONS_UTILITIES new COMPARE_EDITION and SET_NULL_COLUMN_VALUES_TO_EXPR procedure DBMS_EDITIONS_UTILITIES 12-Nov-2014
DBMS_FLASHBACK_ARCHIVE has 16 new objects DBMS_FLASHBACK_ARCHIVE 13-Nov-2014
DBMS_INTERNAL_LOGSTDBY dropped 7 objects and has 15 new objects DBMS_INTERNAL_LOGSTDBY 16-Nov-2014
DBMS_IREFRESH has new ENQUOTE_LITERAL object DBMS_IREFRESH -
DBMS_ISCHED has 11 new objects in 12.1.0.1 and 3 new objects in 12.1.0.2 DBMS_ISCHED 16-Nov-2014
DBMS_ISNAPSHOT has new FIND_DBLINKS object DBMS_ISNAPSHOT -
DBMS_JAVA has 16 objects removed and 4 new ones added DBMS_JAVA 17-Nov-2014
DBMS_LOBUTIL has new, overloaded, COPY_PRIMARY_DEDUP proc DBMS_LOBUTIL 17-Nov-2014
DBMS_LOCK new ALLOCATE_UNIQUE_AUTONOMOUS procedure DBMS_LOCK 17-Nov-2014
DBMS_LOGMNR_D new SET_TABLESPACE procedure DBMS_LOGMNR_D 17-Nov-2014
DBMS_LOGMNR_INTERNAL has 4 objects removed and LOGMNR_KRVIBLD added DBMS_LOGMNR_INTERNAL -
DBMS_LOGREP_UTIL has 9 new objects in 12.1.0.2 and 2 more in 12.1.0.2 DBMS_LOGREP_UTIL 17-Nov-2014
DBMS_LOGSTDBY.EDS_EVOLVE_TABLE and VALIDATE_AUTH removed: EDS_EVOLVE_AUTOMATIC and EDS_EVOLVE_MANUAL added DBMS_LOGSTDBY 17-Nov-2014
DBMS_METADATA has 5 new object in 12.1.0.1 and 2 more in 12.1.0.2 DBMS_METADATA 16-Dec-2015
DBMS_METADATA_INT has new GET_OBJECT_TYPE_INFO object DBMS_METADATA_INT 17-Nov-2014
DBMS_METADATA_UTIL has 13 new objects in 12.1.0.1 and 3 more in 12.1.0.2 DBMS_METADATA_UTIL 17-Nov-2014
DBMS_NETWORK_ACL_ADMIN has multiple new objects and 7 newly deprecated objects. HANDLEPREDELETE has been dropped DBMS_NETWORK_ACL_ADMIN 19-Nov-2014
DBMS_OBJECTS_UTILS gained 2 new procedures and two existing ones moved to DBMS_OBJECTS_APPS_UTILS DBMS_OBJECTS_UTILS 22-Nov-2014
DBMS_PSWMG_IMPORT has a new PURGE_HISTORY procedure DBMS_PSWMG_IMPORT -
DBMS_RANDOM has 2 new objects DBMS_RANDOM 23-Nov-2014
DBMS_RCVCAT has 2 new objects DBMS_RCVCAT 26-Jan-2015
DBMS_RCVMAN has 14 new objects DBMS_RCVMAN 26-Jan-2015
DBMS_REDEFINITION has 3 new objects DBMS_REDEFINITION 02-Aug-2015
DBMS_REDEFINITION_INTERNAL has 12 new objects DBMS_REDEFINITION_INTERNAL 22-Nov-2014
DBMS_REGISTRY has 16 new objects one overloaded DBMS_REGISTRY 22-Nov-2014
DBMS_REGISTRY_SIMPLE has 4 new objects one overloaded DBMS_REGISTRY_SIMPLE 29-Nov-2014
DBMS_REGISTRY_SYS has 13 new objects DBMS_REGISTRY_SYS 07-Dec-2014
DBMS_REPAIR has new REPAIR_CLUSTER_INDEX_KEYCOUNT procedure DBMS_REPAIR 20-Nov-2014
DBMS_REPORT has 14 new objects DBMS_REPORT 23-Nov-2014
DBMS_REPORT.CREATE_SHARED_DIRECTORY, DROP_SHARED_DIRECTORY, and STORE_FILE removed DBMS_REPORT 23-Nov-2014
DBMS_RESOURCE_MANAGER has 10 new CDB-PDB related objects DBMS_RESOURCE_MANAGER 29-Nov-2014
DBMS_RLS has new ALTER_GROUPED_POLICY and ALTER_POLICY procedures DBMS_RLS 25-Nov-2014
DBMS_RMIN has 23 objects removed and 2 new objects added DBMS_RMIN -
DBMS_RULE has new EVALUATE_EXPRESSION and IS_FAST objects DBMS_RULE -
DBMS_RULE_EXP_UTL has new ENQUOTE_NAME and IS_SYSTEM_EXPORT objects DBMS_RULE_EXP_UTL -
DBMS_SCHEDULER has four new objects DBMS_SCHEDULER 25-Nov-2014
DBMS_SCHED_MAIN_EXPORT has 2 new objects DBMS_SCHED_MAIN_EXPORT -
DBMS_SERVICE has new IMPORT_CRS_SERVICES procedure DBMS_SERVICE 25-Nov-2014
DBMS_SESSION has new USE_DEFAULT_EDITION_DEFERRED procedure DBMS_SESSION 29-Nov-2014
DBMS_SMB has new UPGRADE_STGTAB object DBMS_SMB -
DBMS_SMB_INTERNAL has new CHECK_SMO_PROPS and GET_PLAN_FROM_STGTAB objects DBMS_SMB_INTERNAL -
DBMS_SNAPHOT_UTL has new UPDATE_LOG_PLACEHOLDER object DBMS_SNAPSHOT_UTL 29-Nov-2014
DBMS_SNAP_INTERNAL has new SET_I_AM_AN_ACLMV and TRANSFORM_DDL objects DBMS_SNAP_INTERNAL -
DBMS_SPACE_ADMIN 10 new objects DBMS_SPACE_ADMIN 29-Nov-2014
DBMS_SPM has 12 new objects related to baseplane evolution DBMS_SPM 28-Jan-2016
DBMS_SPM_INTERNAL.FETCH_PLAN_INFO and GET_SPM_HINTSET removed DBMS_SPM_INTERNAL 29-Nov-2014
DBMS_SQADM_SYSCALLS has 4 new objects DBMS_SQADM_SYSCALLS -
DBMS_SQL.BIND_ARRAY and DEFINE_ARRAY support 32K VARCHAR2s DBMS_SQL 29-Nov-2014
DBMS_SQL has new GET_NEXT_RESULT and RETURN_RESULT objects DBMS_SQL 29-Nov-2014
DBMS_SQLDIAG has 3 new objects DBMS_SQLDIAG 03-Dec-2014
DBMS_SQLDIAG_INTERNAL has new I_GENERATE_PARAM_IMPORT object DBMS_SQLDIAG_INTERNAL 03-Dec-2014
DBMS_SQLTCB_INTERNAL has 5 new objects DBMS_SQLTCB_INTERNAL -
DBMS_SQLTUNE has 14 new objects and 13 new container related parameters DBMS_SQLTUNE 03-Dec-2014
DBMS_SQLTUNE_INTERNAL has 7 new objects and new container related parameters DBMS_SQLTUNE_INTERNAL -
DBMS_SQLTUNE_UTIL0 has 5 new CDB-related objects DBMS_SQLTUNE_UTIL0 03-Dec-2014
DBMS_SQLTUNE_UTIL1 has new GET_DBID_FROM_CONID and GET_SQLSET_CON_DBID objects DBMS_SQLTUNE_UTIL1 03-Dec-2014
DBMS_SQLTUNE_UTIL2 has new GET_TIMING_INFO object DBMS_SQLTUNE_UTIL2 03-Dec-2014
DBMS_STANDARD has new ORIGINALSQL_TXT function DBMS_STANDARD 03-Dec-2014
DBMS_STATS has 25 new objects including support for Containers DBMS_STATS 05-Dec-2014
DBMS_STATS.TO_CASCADE_TYPE, TO_DEGREE_TYPE, TO_ESTIMATE_PERCENT_TYPE, and TO_PUBLISH_TYPE removed DBMS_STATS 05-Dec-2014
DBMS_STATS_INTERNAL has 59 new objects DBMS_STATS_INTERNAL 05-Dec-2014
DBMS_STATS_INTERNAL.GET_CHTAB, DELETE_TABLE_SYNOPSIS, EXPORT_SYNOPSIS_HEAD, and GET_SYNOPSIS_BLKCNT removed DBMS_STATS_INTERNAL 05-Dec-2014
DBMS_STREAMS has new COMPATIBLE_12_1 function DBMS_STREAMS 06-Dec-2014
DBMS_STREAMS_ADM_UTL has new CREATE_RULE_STRING_PROCEDURE object DBMS_STREAMS_ADM_UTL -
DBMS_SWRF_INTERNAL has 5 new objects DBMS_SWRF_INTERNAL 07-Dec-2014
DBMS_SWRF_REPORT_INTERNAL.TO_1000S and TO_1024S removed and 16 new objects DBMS_SWRF_REPORT_INTERNAL -
DBMS_TTS has 4 new objects DBMS_TTS 10-Dec-2014
EXPAND_SQL_TEXT relocated to DBMS_UTILITY from DBMS_SQL2 DBMS_UTILITIES 10-Dec-2014
DBMS_WM has CREATEFASTLIVE, DROPFASTLIVE, GET_SID, and SYNCFASTLIVE removed DBMS_WM 09-Dec-2014
DBMS_WM has 3 new objects DBMS_WM 09-Dec-2014
DBMS_WLM has 13 new objects DBMS_WLM 09-Dec-2014
DBMS_WORKLOAD_CAPTURE has 3 new objects DBMS_WORKLOAD_CAPTURE 07-Apr-2016
DBMS_WORKLOAD_REPLAY has 34 new objects DBMS_WORKLOAD_REPLAY 10-Dec-2014
DBMS_WORKLOAD_REPLAY.SYNCPOINT_WAIT_TO_POST introduced in 12.1.0.1 removed in 12.1.0.2 DBMS_WORKLOAD_REPLAY 10-Dec-2014
DBMS_WORKLOAD_REPOSITORY has 3 new objects DBMS_WORKLOAD_REPOSITORY 11-Dec-2014
DBMS_WRR_INTERNAL with 74 new objects DBMS_WRR_INTERNAL 11-Dec-2014
DBMS_XDBUTIL_INT has new INSTANCE_CALLOUT_IMP and INSTANCE_EXPORT_ACTION DBMS_XDBUTIL_INT 12-Dec-2014
DBMS_XDB_ADMIN has 5 new objects DBMS_XDB_ADMIN 12-Dec-2014
DBMS_XDS.REFRESH_DSD removed and 8 new objects added DBMS_XDS.REFRESH_DSD -
DBMS_XMLINDEX dropped the DELETE_TABLE_STATS and GATHER_TABLE_STATS objects DBMS_XMLINDEX 13-Dec-2014
DBMS_XMLINDEX0 has new GETPARAMETERNAME function DBMS_XMLINDEX0 13-Dec-2014
DBMS_XMLSTORE has new SETPRESERVEWHITESPACE procedure DBMS_XMLSTORE 20-Dec-2014
DBMS_XPLAN has several few pipelined table functions DBMS_XPLAN 20-Aug-2015
DBMS_XSLPROCESSOR has had CLOB2URL and URL2CLOB objects removed DBMS_XSLPROCESSOR 20-Dec-2014
DBMS_XSTREAM_ADM has 30 new objects DBMS_XSTREAM_ADM 20-Dec-2014
DBMS_XSTREAM_ADM_INTERNAL has new UPDATE_GOLDENGATE_PRIVILEGE object DBMS_XSTREAM_ADM_INTERNAL -
DBMS_XSTREAM_ADM_UTL has 4 new objects DBMS_XSTREAM_ADM_UTL 20-Dec-2014
DBMS_XSTREAM_GG_ADM has 50 new objects and overloads DBMS_XSTREAM_GG_ADM -
DBMS_XSTREAM_GG_INTERNAL has 2 new objects DBMS_XSTREAM_GG_INTERNAL -
DBMS_XS_MTCACHE.SECCLS_DELETE and SECCLS_UPDATE removed DBMS_XS_MTCACHE 20-Dec-2014
DBMS_XS_PRINCIPALS has 2 objects removed and 3 new objects added DBMS_XS_PRINCIPALS 26-Dec-2015
DBMS_XS_SESSIONS has 6 objects removed and 4 new objects added DBMS_XS_SESSIONS 27-Dec-2015
DBMS_XS_SESSIONS_FFI has 6 objects removed and 3 new objects added DBMS_XS_SESSIONS_FFI 27-Dec-2015
DIANA has 9 new objects DIANA -
DMP_SEC.GET_MODEL_DETAILS_ABN removed DMP_SEC -
DMP_SYS has 4 objects removed and 4 new objects added DMP_SYS -
DM_QGEN has had the LS_DUMP procedure removed and 2 new objects added DM_QGEN 20-Dec-2014
HTMLDB_UTIL has 4 JSON related procs HTMLDB_UTIL -
INITJVMAUX has 2 new objects INITJVMAUX -
LOGMNR_DICT_CACHE.PURGE_SCN removed LOGMNR_DICT_CACHE -
LOGSTDBY_INTERNAL.EDS_EVOLVE_TABLE_1_I removed LOGSTDBY_INTERNAL -
LT has new 3 new, CREATEFASTLIVE, DROPFASTLIVE, GET_SID removed DBMS_WM 09-Dec-2014
ODM_CLUSTERING_UTIL.IS_DEBUG_ENABLED removed ODM_CLUSTERING_UTIL -
ODM_MODEL_UTIL has 5 objects removed ODM_MODEL_UTIL -
ODM_UTIL.COMPUTE_LOG_COMBINATIONS removed and 3 new objects: 2 with 4 overloads ODM_UTIL -
PRVT_COMPRESS has 2 new objects with revised params in one making it essentially new as well PRVT_COMPRESS 10-Dec-2014
PRVT_COMPRESSION has 4 new objects PRVT_COMPRESSION 28-Dec-2014
UTL_HTTP has a new GET and SET_CONTENT_ENCODING_SUPPORT procedures UTL_HTTP 08-Jan-2015
UTL_I18N has a new function GET_MAX_CHARACTER_SIZE UTL_I18N 08-Jan-2015
UTL_XML has 9 new objects UTL_XML 12-Jan-2015
UTL_XML objects XMLGETTABLEFROMDOC, XMLTERM and XSLSETSTYLESHEET removed UTL_XML 12-Jan-2015
WPG_DOCLOAD has new GET_DOWNLOAD_FILE_RAW procedure WPG_DOCLOAD 12-Jan-2015
WWV_DBMS_SQL has 14 new objects WWV_DBMS_SQL 12-Jan-2015
 
Built-In Packages with New or Removed Overloads
DBMSOBJG has a new FIND_TS_INFO procedure or function and GENERATE_DDL has more parameters as does GET_TAB_SPACE DBMSOBJG 25-Oct-2014
DBMSOBJG2 has new parameters in all 3 procs DBMSOBJG2 25-Oct-2014
DBMSOBJG_DP has three new parameters in GENERATE_DDL_DP DBMSOBJG_DP 25-Oct-2014
DBMS_AQ_IMP_ZECURITY.CHECK_IMPORT_PRIV now has an overload DBMS_AQ_IMP_ZECURITY 25-Oct-2014
DBMS_BACKUP_RESTORE.COPYDATAFILECOPY has a new overload 4 DBMS_BACKUP_RESTORE 26-Jan-2015
DBMS_BACKUP_RESTORE.DEVICEALLOCATE has a new overload 4 DBMS_BACKUP_RESTORE 26-Jan-2015
DBMS_COMPRESSION.GET_COMPRESSION_RATIO now has 3 overloads DBMS_COMPRESSION 09-Nov-2014
DBMS_DATAPUMP.GET_STATUS has a new overload 5 DBMS_DATAPUMP 10-Nov-2014
DBMS_DRS.PING has a new overload DBMS_DRS 12-Nov-2014
DBMS_JAVA.SET_RUNTIME_EXEC_CREDENTIALS has 1 new overload DBMS_JAVA 17-Nov-2014
DBMS_LOGMNR_LOGREP_DICT has new overloads for ADD_COL and ADD_OBJ -  
DBMS_METADATA_INT.SET_OBJECTS_FETCHED has new overload 3 DBMS_METADATA_INT 17-Nov-2014
DBMS_PICKLER.GET_TYPE_SHAPE has two new overloads DBMS_PICKLER 19-Nov-2014
DBMS_REPORT FORMAT_REPORT and GET_REPORT have new overloads DBMS_REPORT 23-Nov-2014
DBMS_SQL.BIND_VARIABLE_ROWID overloaded removed, PARSE has 4 new overloads DBMS_SQL 29-Nov-2014
DBMS_STATS_INTERNAL.COMPOSE_HASHVAL_CLOB_REC has modified parameters DBMS_STATS_INTERNAL 05-Dec-2014
DBMS_SYS_SQL has overloads removed, overloads added, and two new functions with overloads DBMS_SYS_SQL 08-Dec-2014
DBMS_XS_PRINCIPALS.SET_PASSWORD overload removed DBMS_XS_PRINCIPALS -
DBMS_XS_SESSIONS.SET_ATTRIBUTE overload removed DBMS_XS_SESSIONS -
DBMS_PRVTAQIM has new CREATE_BASE_VIEW11_2_0 and CREATE_BASE_VIEW_12C objects DBMS_PRVTAQIM -
DBMS_PRVTAQIS has 15 new objects DBMS_PRVTAQIS -
DBMS_SERVICE.CREATE_SERVICE and MODIFY_SERVICE are now overloaded DBMS_SERVICE 25-Nov-2014
DBMS_WORKLOAD_REPOSITORY.CREATE_BASELINE has two new overloads DBMS_WORKLOAD_REPOSITORY 11-Dec-2014
DM_QGEN.TO_LITERAL has 2 new overloads DM_QGEN 20-Dec-2014
ODM_MODEL_UTIL.DROP_TABLE overload removed ODM_MODEL_UTIL -
UTL_XML SSCFIND 3 args UTL_XML 12-Jan-2015
UTL_XML SSCGETCTX 2 args UTL_XML 12-Jan-2015
UTL_XML SSCMINIMIZECACHE 1 arg UTL_XML 12-Jan-2015
UTL_XML SSCPARSE 3 args UTL_XML 12-Jan-2015
UTL_XML SSCPURGE 1 arg UTL_XML 12-Jan-2015
UTL_XML SSCSETDEBUG 1arg UTL_XML 12-Jan-2015
UTL_XML XMLDUMPCTXS 1arg UTL_XML 12-Jan-2015
UTL_XML XMLSETMEMDEBUG 1arg UTL_XML 12-Jan-2015
UTL_XML XMLTERM - removed UTL_XML 12-Jan-2015
WWV_DBMS_SQL.PARSE_AS_USER and RUN_DDL each have one new overload WWV_DBMS_SQL 06-Oct-2013
 
Built-In Packages with Parameter Changes
AS_REPLAY.PREPARE_AS_REPLAY synchronization parameter changed from BOOLEAN to VARCHAR2 AS_REPLAY 25-Oct-2014
DBMS_APPLY_ADM.SET_<GLOBAL | SCHEMA | TABLE>_INSTANTIATION_SCN objects have a new parameter DBMS_APPLY_ADM 25-Oct-2014
DBMS_APPLY_ADM.SET_TABLE_xxx_SCN procs have a new SOURCE_ROOT_NAME parameter DBMS_APPLY_ADM 25-Oct-2014
DBMS_ASH_INTERNAL.ASH_ROLLUP_SQL_1D has 2 new parameters DBMS_ASH_INTERNAL 27-Oct-2014
DBMS_ASH_INTERNAL.ASH_ROLLUP_SQL_2D has 2 new parameters DBMS_ASH_INTERNAL 27-Oct-2014
DBMS_ASH_INTERNAL.ASH_ROLLUP_SQL_3D has 2 new parameters DBMS_ASH_INTERNAL 27-Oct-2014
DBMS_ASH_INTERNAL.GET_PLSQL_NAME has 1 new parameter DBMS_ASH_INTERNAL 27-Oct-2014
DBMS_ASH_INTERNAL.REPORT_ASHVIEWER_XML has 2 new parameters DBMS_ASH_INTERNAL 27-Oct-2014
DBMS_ASH_INTERNAL.RUNREPORT has 2 new parameters DBMS_ASH_INTERNAL 27-Oct-2014
DBMS_AUDIT_MGMT.CLEAN_AUDIT_TRAIL has 3 new parameters DBMS_AUDIT_MGMT 27-Oct-2014
DBMS_AUDIT_MGMT.CLEAR_LAST_ARCHIVE_TIMESTAMP has 3 new parameters DBMS_AUDIT_MGMT 27-Oct-2014
DBMS_AUDIT_MGMT.CREATE_PURGE_JOB has new CONTAINER parameter DBMS_AUDIT_MGMT 27-Oct-2014
DBMS_AUDIT_MGMT.DEINIT_CLEANUP has new CONTAINER parameter DBMS_AUDIT_MGMT 27-Oct-2014
DBMS_AUDIT_MGMT.INIT_CLEANUP has new CONTAINER parameter DBMS_AUDIT_MGMT 27-Oct-2014
DBMS_AUDIT_MGMT.IS_CLEANUP_INITIALIZED has new CONTAINER parameter DBMS_AUDIT_MGMT 27-Oct-2014
DBMS_AUDIT_MGMT.SET_LAST_ARCHIVE_TIMESTAMP has new CONTAINER parameter DBMS_AUDIT_MGMT 27-Oct-2014
DBMS_AWR_REPORT_LAYOUT has 12 previously existing objects with new CDB related parameters DBMS_AWR_REPORT_LAYOUT 06-Nov-2014
DBMS_CACHEUTIL.DISSOLVE_AFFINITY and .GRAB_AFFINITY have a new ACTIVE_DRM param DBMS_CACHEUTIL 06-Nov-2014
DBMS_CAPTURE_ADM.CREATE_CAPTURE has 2 new parameters DBMS_CAPTURE_ADM 07-Nov-2014
DBMS_CLIENT_RESULT_CACHE has many new parameters DBMS_CLIENT_RESULT_CACHE 07-Nov-2014
DBMS_DATAPUMP.DATA_REMAP has a new REMAP_FLAGS parameter DBMS_DATAPUMP 10-Nov-2014
DBMS_GOLDENGATE_AUTH procedures have new CONTAINER parameter DBMS_GOLDENGATE_AUTH 13-Nov-2014
DBMS_INDEX_UTL has new FORCED_DEGREE and RETRY_ONLINE parameters DBMS_INDEX_UTL 16-Nov-2014
DBMS_I_INDEX_UTL has new FORCED_DEGREE and RETRY_ONLINE parameters DBMS_I_INDEX_UTL 16-Nov-2014
DBMS_METADATA.SET_VAT_TABLE_NAME has a new NETWORK_LINK parameter DBMS_METADATA 16-Dec-2015
DBMS_RCVMAN has objects with new parameters DBMS_RCVMAN 26-Jan-2015
DBMS_REDEFINITION some objects have new CONTINUE_AFTER_ERRORS, DML_LOCK_TIMEOUT, and COPY_VPD_OPT parameters DBMS_REDEFINITION 22-Nov-2014
DBMS_RESOURCE_MANAGER.CREATE_PLAN_DIRECTIVE has 6 new parameters DBMS_RESOURCE_MANAGER 29-Nov-2014
DBMS_RESOURCE_MANAGER.UPDATE_PLAN_DIRECTIVE has 6 new parameters DBMS_RESOURCE_MANAGER 29-Nov-2014
DBMS_RLS.ADD_POLICY has new namespace and attribute parameters DBMS_RLS 25-Nov-2014
DBMS_SCHEDULER.RUN_JOB and SUBMIT_REMOTE_EXTERNAL_JOB have new parameters DBMS_SCHEDULER 25-Nov-2014
New DBMS_SERVER_ALERT OBJARGPOS and PDB_NAME parameters DBMS_SERVER_ALERT 25-Nov-2014
DBMS_SQLPA has new CON_DBID, CON_NAME and new default analysis parameters DBMS_SQLPA 03-Dec-2014
DBMS_SQLTUNE has new AUTOTUNE_PERIOD parameter DBMS_SQLTUNE 03-Dec-2014
DBMS_STATS type ObjectElem dropped the confidence element and multiple objects with new parameters and new OPTIONS parameter DBMS_STATS 05-Dec-2014
DBMS_STATS has new OPTIONS and STAT_CATEGORY parameters in multiple objects DBMS_STATS 05-Dec-2014
DBMS_STATS new EXADATA option for GATHER_SYSTEM_STATS DBMS_STATS 05-Dec-2014
DBMS_SWRF_INTERNAL.AWR_DECODE_OBJECT_TYPE has new MAX_LENGTH parameter DBMS_SWRF_INTERNAL 07-Dec-2014
DBMS_WORKLOAD_REPLAY.DELETE_REPLAY_INFO has new PERMANENT parameter DBMS_WORKLOAD_REPLAY 10-Dec-2014
DBMS_WORKLOAD_REPLAY.GET_REPLAY_INFO has new LOAD_DIVERGENCE parameter DBMS_WORKLOAD_REPLAY 10-Dec-2014
DBMS_WORKLOAD_REPLAY.PROCESS_REPLAY_GRAPH has new PARALLEL_LEVEL parameter DBMS_WORKLOAD_REPLAY 10-Dec-2014
DBMS_WORKLOAD_REPOSITORY.AWR_SET_REPORT_THRESHOLDS has 3 new parameters DBMS_WORKLOAD_REPOSITORY 11-Dec-2014
DBMS_WRR_INTERNAL.ADD_CAPTURE has 1 new parameter in 12.1.0.2 DBMS_WRR_INTERNAL 11-Dec-2014
DBMS_WRR_INTERNAL.ADD_REPLAY has 2 new parameters in 12.1.0.2 DBMS_WRR_INTERNAL 11-Dec-2014
DBMS_XSTREAM_ADM has many new parameters: some Container related DBMS_XSTREAM_ADM 20-Dec-2014
DBMS_XSTREAM_ADM_UTL has many new parameters: some Container related DBMS_XSTREAM_ADM_UTL 20-Dec-2014
 
Built-In Packages with new Constants, Exceptions, Types, or Other Significant Changes
DBMS_ADR has new constants DBMS_ADR 25-Oct-2014
DBMS_ADVISOR has new SPM Evolve Constants DBMS_ADVISOR 25-Oct-2014
DBMS_AQADM has new sort_list parameter constants DBMS_AQADM 25-Oct-2014
DBMS_COMPRESSION has 18 new constants DBMS_COMPRESSION 09-Nov-2014
DBMS_CRYPTO has new SHA-2 constants DBMS_CRYPTO 09-Nov-2014
DBMS_DATAPUMP has 19 new constants and a new value for KU$_STATUS_VERSION DBMS_DATAPUMP 10-Nov-2014
DBMS_DB_VERSION has new version 12 constants DBMS_DB_VERSION 16-Nov-2014
DBMS_ILM_ADMIN has new ILM_RETENTION_TIME constant DBMS_ILM_ADMIN 16-Nov-2014
DBMS_METADATA has new MARKER_STATISTICS constant and 9 new XS (RAS) types DBMS_METADATA 16-Dec-2015
DBMS_PARALLEL_EXECUTE has one new constant and a redefinition of others from 11g DBMS_PARALLEL_EXECUTE 16-Jan-2015
DBMS_RLS has many new constants DBMS_RLS 25-Nov-2014
DBMS_SPACE_ADMIN new HEAT_MAP_MAXSIZE_UNLIMITED constant DBMS_SPACE_ADMIN 29-Nov-2014
DBMS_SQLHASH new HASH_SH256, HASH_SH384, and HASH_SH512 constants DBMS_SQLHASH 03-Dec-2014
DBMS_STATS new RECLAIM_SYNOPSIS constant DBMS_STATS 05-Dec-2014
DBMS_XPLAN has a new ADAPTIVE parameter to handle evolving optimizer plans DBMS_XPLAN 20-Aug-2015
ODCICONST has three new ODCIEnv.Envflag constants ODCICONST 25-Dec-2014
UTL_IDENT has new IS_ORACLE_XE constant UTL_IDENT 12-Jan-2015
UTL_RECOMP has new NEW_EDITION constant UTL_RECOMP 08-Jan-2015
 
Related Topics
New in 11.2
New in 12.2
New in 18c
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-2019 Daniel A. Morgan All Rights Reserved
  DBSecWorx