| Description |
Link |
Last Modified |
| Architecture |
| New CREATE, ALTER, and DROP PLUGGABLE DATABASE |
|
18-Nov-2012 |
| Root Database (RDB) |
|
18-Nov-2012 |
| Pluggable Database (PDB) |
|
18-Nov-2012 |
| Common Users |
USERS |
01-Jun-2013 |
| Common Roles |
ROLES |
01-Jun-2013 |
| |
| General |
New Roles
- ADM_PARALLEL_EXECUTE_TASK
- APEX_GRANTS_FOR_NEW_USERS_ROLE
- AUDIT_ADMIN
- AUDIT_VIEWER
- CALLBACK (not in Beta but mentioned in final docs)
- 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
- PROVISIONER
- XS_CACHE_ADMIN
- XS_NSATTR_ADMIN
- XS_RESOURCE
- XS_SESSION_ADMIN
|
ROLES |
01-Jun-2013 |
New System Privileges
- ADMINISTER KEY MANAGEMENT
- ALTER ANY CUBE BUILD PROCESS
- ALTER ANY MEASURE FOLDER
- ALTER ANY SQL TRANSLATION PROFILE
- CLONE PLUGGABLE DATABASE
- 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 DDL REDACTION POLICY
- EXEMPT DML REDACTION 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 |
23-Feb| |
| New Column size for many common data dictionary common columns have been increased from 30 to 128 bytes |
DATA DICTIONARY |
01-Jun-2013 |
| |
|
|
| |
| Deprecated or Dropped |
| Package BLAST_CUR dropped |
|
01-Jun-2013 |
| Package CWM2_OLAP_INSTALLER dropped |
|
01-Jun-2013 |
| Package DBMSNCDB dropped |
|
01-Jun-2013 |
| Package DBMS_AMD dropped |
|
01-Jun-2013 |
| Package DBMS_DBLINK dropped |
|
01-Jun-2013 |
| Package DBMS_JDM_INTERNAL dropped |
|
01-Jun-2013 |
| Package DBMS_OWB dropped dropped |
|
01-Jun-2013 |
| Package DBMS_RULE_COMPATIBLE_90 dropped |
|
01-Jun-2013 |
| Package DBMS_SQL2, from 11gR2, dropped ... EXPAND_SQL_TEXT relocated to DBMS_UTILITY and PARSE to
DBMS_SQL |
|
01-Jun-2013 |
| Package DBMS_XDSUTL dropped |
|
01-Jun-2013 |
| Package DBMS_XS_MTCACHE_FFI dropped |
|
01-Jun-2013 |
| Package DBMS_XS_PRINCIPALS_INT dropped |
|
01-Jun-2013 |
| Package DBMS_XS_PRINCIPAL_EVENTS_INT dropped |
|
01-Jun-2013 |
| Package DBMS_XS_ROLESET_EVENTS_INT dropped |
|
01-Jun-2013 |
| Package ODM_ABN_MODEL dropped |
|
01-Jun-2013 |
| Package XS$CATVIEW_UTIL dropped |
|
01-Jun-2013 |
| RESOURCE role no longer grants the UNLIMITED TABLESPACE system privilege by default |
ROLES |
01-Jun-2013 |
| |
| SQL |
Need to add MULTISET and MULTISET EXCEPT and MULTISET INTERSECT and MULTISET UNION
with their own library page even though not new |
MULTISET |
22-Oct-2012 |
| CREATE DATABASE ... ENABLE PLUGGABLE DATABASE syntax |
DATABASE |
23-Oct-2012 |
| CREATE PLUGGABLE DATABASE syntax |
DATABASE |
23-Oct-2012 |
| New ALTER DATABASE FULL_DATABASE_RECOVERY Clause supporting recovery from storage snapshots |
DATABASE |
|
| New ALTER DATABASE MOVE_DATAFILE_CLAUSE |
DATABASE |
|
| New ALTER DATABASE Control File management clauses |
DATABASE |
|
| New ALTER DATABASE Switfch-Over and Fail-Over clauses |
DATABASE |
|
| CREATE USER syntax updated to include Editions and Containers |
USERS |
28-Oct-2012 |
| New CLEANUP keyword added to ALTER INDEX ... COALESCE |
INDEXES |
|
| New USING TRUSTED CONSTRAINTS clause for Materialized Views |
MATERIALIZED VIEWS |
03-Nov-2012 |
| New KEEP and NOKEEP syntax for SEQUENCES affecting the behaviour of the NEXTVAL pseudocolumn during
REPLAY |
SEQUENCES |
|
| New SESSION and GLOBAL syntax for CREATE and ALTER SEQUENCES |
SEQUENCES |
|
| New 32K maximum size for VARCHAR2 and NVARCHAR2 columns in tables and views |
TABLES |
01-Jun-2013 |
| New Unified Auditing with CREATE, ALTER, and DROP AUDIT POLICY statements and new AUDIT NOAUDIT
abilities |
AUDIT |
|
| New unified key management interface for Transparent Data Encryption with ADMINISTER KEY MANAGEMENT
statement |
Transparent Data Encryption |
|
| |
| PL/SQL |
| New ACCESSIBLE BY Clause |
ACCESSIBLE BY |
01-Jun-2013 |
| New FETCH FIRST Clause |
BULK COLLECT |
01-Jun-2013 |
| New PL/SQL Predefined Inquiry Directives ($$PLSQL_UNIT_OWNER, $$PLSQL_UNIT_TYPE, and compilation parameters) |
Predefined Inquiry Directives |
01-Jun-2013 |
| Invoker’s Rights Functions Can Be Result-Cached |
DBMS_RESULT_CACHE |
01-Jun-2013 |
| More PL/SQL-Only Data Types Can Cross PL/SQL-to-SQL Interface |
|
14-Nov-2012 |
| Roles can be granted to PL/SQL Packages and Standalone Subprograms |
ROLES |
01-Jun-2013 |
| More Data Types Have Same Maximum Size in SQL and PL/SQL |
Data Types |
01-Jun-2013 |
| A Library Can Be Defined as DIRECTORY Object and With CREDENTIAL |
|
14-Nov-2012 |
| New Implicit Statement Results |
|
14-Nov-2012 |
| UPDATE Triggers for LOB Columns and LOGICAL LOB UPDATE Triggers |
|
14-Nov-2012 |
| BEQUEATH CURRENT_USER Views |
|
14-Nov-2012 |
| INHERIT PRIVILEGES and INHERIT ANY PRIVILEGES Privileges |
|
14-Nov-2012 |
| Invisible Columns |
|
14-Nov-2012 |
| Objects, Not Types, Are Editioned or Noneditioned |
|
14-Nov-2012 |
| PL/SQL Functions That Run Faster in SQL |
|
14-Nov-2012 |
| New PDB_NAME attribute in the ALERT_TYPE data type. |
|
01-Jun-2013 |
| |
| Functions and Procedures |
| New DBMS_FEATURE_ACTIVE_DATA_GUARD procedure |
DBMS_FEATURE_USAGE Procedures |
01-Jun-2013 |
| New DBMS_FEATURE_AUDIT_OPTIONS procedure |
DBMS_FEATURE_USAGE Procedures |
01-Jun-2013 |
| New DBMS_FEATURE_DATA_REDACTION procedure |
DBMS_FEATURE_USAGE Procedures |
01-Jun-2013 |
| New DBMS_FEATURE_DBFS_CONTENT procedure |
DBMS_FEATURE_USAGE Procedures |
01-Jun-2013 |
| New DBMS_FEATURE_DBFS_HS procedure |
DBMS_FEATURE_USAGE Procedures |
01-Jun-2013 |
| New DBMS_FEATURE_DBFS_SFS procedure |
DBMS_FEATURE_USAGE Procedures |
01-Jun-2013 |
| New DBMS_FEATURE_FGA_AUDIT procedure |
DBMS_FEATURE_USAGE Procedures |
01-Jun-2013 |
| New DBMS_FEATURE_GOLDENGATE procedure |
DBMS_FEATURE_USAGE Procedures |
01-Jun-2013 |
| New DBMS_FEATURE_ILM procedure |
DBMS_FEATURE_USAGE Procedures |
01-Jun-2013 |
| New DBMS_FEATURE_LABEL_SECURITY procedure |
DBMS_FEATURE_USAGE Procedures |
01-Jun-2013 |
| New DBMS_FEATURE_OLTP_INDEXCOMP procedure |
DBMS_FEATURE_USAGE Procedures |
01-Jun-2013 |
| New DBMS_FEATURE_OJVM procedure |
DBMS_FEATURE_USAGE Procedures |
01-Jun-2013 |
| New DBMS_FEATURE_PILLAR_EHCC procedure |
DBMS_FEATURE_USAGE Procedures |
01-Jun-2013 |
| New DBMS_FEATURE_PILLAR_STORAGE procedure |
DBMS_FEATURE_USAGE Procedures |
01-Jun-2013 |
| New DBMS_FEATURE_PRIV_CAPTURE procedure |
DBMS_FEATURE_USAGE Procedures |
01-Jun-2013 |
| New DBMS_FEATURE_RAS procedure |
DBMS_FEATURE_USAGE Procedures |
01-Jun-2013 |
| New DBMS_FEATURE_STREAMS procedure |
DBMS_FEATURE_USAGE Procedures |
01-Jun-2013 |
| New DBMS_FEATURE_SYSTEM_OJVM procedure |
DBMS_FEATURE_USAGE Procedures |
01-Jun-2013 |
| New DBMS_FEATURE_TSDP procedure |
DBMS_FEATURE_USAGE Procedures |
01-Jun-2013 |
| New DBMS_FEATURE_UNIFIED_AUDIT procedure |
DBMS_FEATURE_USAGE Procedures |
01-Jun-2013 |
| New DBMS_FEATURE_XSTREAM_IN procedure |
DBMS_FEATURE_USAGE Procedures |
01-Jun-2013 |
| New DBMS_FEATURE_XSTREAM_OUT procedure |
DBMS_FEATURE_USAGE Procedures |
01-Jun-2013 |
| New DBMS_FEATURE_XSTREAM_STREAMS procedure |
DBMS_FEATURE_USAGE Procedures |
01-Jun-2013 |
| New DBMS_FEATURE_ZFS_EHCC procedure |
DBMS_FEATURE_USAGE Procedures |
01-Jun-2013 |
| New DBMS_FEATURE_ZFS_STORAGE procedure |
DBMS_FEATURE_USAGE Procedures |
01-Jun-2013 |
| New Undocumented STANDARD_HASH function |
Undocumented Oracle |
01-Jun-2013 |
| New SYS_CONTEXT functionality with CDB_NAME, CON_NAME, and DBLINK_INFO attributes |
SYS_CONTEXT |
01-Jun-2013 |
| |
| XML |
| New |
|
|
| New |
|
|
| |
| New Built-in Packages |
| New AMGT$DATAPUMP package with one procedure |
AMGT$DATAPUMP |
01-Jun-2013 |
| New APEX_DATAPUMP_SUPPORT package with 2 objects |
|
01-Jun-2013 |
| New CDBVIEW package with 1 object |
CDBVIEW |
01-Jun-2013 |
| New DBMS_ADR_APP package with 10 objects |
DBMS_ADR_APP |
01-Jun-2013 |
| New DBMS_ADR_INTERNAL package with 10 objects |
DBMS_ADR_INTERNAL |
01-Jun-2013 |
| New DBMS_APPLY_ADM_IVK package with 1 object |
DBMS_APPLY_ADM_IVK |
01-Jun-2013 |
| New DBMS_APP_CONT package with 1 object |
DBMS_APP_CONT |
01-Jun-2013 |
| New DBMS_AUTO_REPORT package with 7 objects |
DBMS_AUTO_REPORT |
01-Jun-2013 |
| New DBMS_AUTO_REPORT_INTERNAL package with 2 objects |
DBMS_AUTO_REPORT_INTERNAL |
01-Jun-2013 |
| New DBMS_CAPTURE_ADM_IVK package with 9 objects |
DBMS_CAPTURE_ADM_IVK |
01-Jun-2013 |
| New DBMS_CREDENTIAL package with 5 objects |
DBMS_CREDENTIAL |
01-Jun-2013 |
| New DBMS_FS package with 3 non-functional objects |
DBMS_FS |
01-Jun-2013 |
| New DBMS_ILM package with 10 objects - DOCUMENTED |
DBMS_ILM |
24-Oct-2012 |
| New DBMS_ILM_ADMIN with 3 objects |
DBMS_ILM_ADMIN |
01-Jun-2013 |
| New DBMS_INTERNAL_ROLLING package with 11 objects |
DBMS_INTERNAL_ROLLING |
24-Oct-2012 |
| New DBMS_ISYNCREF package with 3 objects |
DBMS_ISYNCREF |
24-Oct-2012 |
| New DBMS_JAVA_MISC package with 16 objects |
DBMS_JAVA_MISC |
24-Oct-2012 |
| New DBMS_LOG package with 4 objects |
DBMS_LOG |
24-Oct-2012 |
| New DBMS_LOGSTDBY_CONTEXT package with 4 objects |
|
01-Jun-2013 |
| New DBMS_NETWORK_ACL_IMPORT package with 2 objects |
DBMS_NETWORK_ACL_IMPORT |
24-Oct-2012 |
| New DBMS_OPATCH package with 19 objects |
DBMS_OPATCH |
24-Oct-2012 |
| New DBMS_PART package with 2 objects |
DBMS_PART |
01-Jun-2013 |
| New DBMS_PDB package with 5 objects |
DBMS_PDB |
01-Jun-2013 |
| New DBMS_PREUP package with 148 objects: many overloaded |
DBMS_PREUP |
01-Jun-2013 |
| New DBMS_PRIVILEGE_CAPTURE package with 5 objects |
DBMS_PRIVILEGE_CAPTURE |
01-Jun-2013 |
| New DBMS_PRIV_CAPTURE package with 9 objects - same rdbms/admin file |
DBMS_PRIV_CAPTURE |
01-Jun-2013 |
| New DBMS_PRVTSQDS package with 14 objects |
DBMS_PRVTSQDS |
24-Oct-2012 |
| New DBMS_PRVTSQIS package with 13 objects |
DBMS_PRVTSQIS |
24-Oct-2012 |
| New DBMS_RAT_MASK package with 9 objects |
DBMS_RAT_MASK |
24-Oct-2012 |
| New DBMS_REDACT package with 8 objects for working with Data Redaction and Transparent Sensitive Data Protection - DOCUMENTED |
DBMS_REDACT |
01-Jun-2013 |
| New DBMS_REDACT_INT package with 10 objects for working with Data Redaction and Transparent Sensitive Data Protection |
DBMS_REDACT_INT |
24-Oct-2012 |
| New DBMS_RESULT_CACHE_INTERNAL package with 1 object |
DBMS_RESULT_CACHE_INTERNAL |
24-Oct-2012 |
| New DBMS_RMIN_SYS package with 39 objects plus overloads |
DBMS_RMIN_SYS |
24-Oct-2012 |
| New DBMS_ROLLING package with 8 objects |
DBMS_ROLLING |
01-Jun-2013 |
| New DBMS_SCHED_ARGUMENT_IMPORT package with 3 objects |
DBMS_SCHED_ARGUMENT_IMPORT |
24-Oct-2012 |
| New DBMS_SECUREFILE_LOG_ADMIN package with 1 object |
DBMS_SECUREFILE_LOG_ADMIN |
01-Jun-2013 |
| New DBMS_SERVICE_ERR package with 2 objects |
DBMS_SERVICE_ERR |
01-Jun-2013 |
| New DBMS_SERVICE_PRVT package with 6 objects |
DBMS_SERVICE_PRVT |
01-Jun-2013 |
| New DBMS_SPD package with 9 objects - DOCUMENTED |
DBMS_SPD |
24-Oct-2012 |
| New DBMS_SPD_INTERNAL package with 10 objects |
DBMS_SPD_INTERNAL |
24-Oct-2012 |
| New DBMS_SQADM_SYSCALLS package with 4 objects |
DBMS_SQADM_SYSCALLS |
24-Oct-2012 |
| New DBMS_SQL_MONITOR package with 6 objects - DOCUMENTED |
DBMS_SQL_MONITOR |
24-Oct-2012 |
| New DBMS_SQL_TRANSLATOR package with 16 objects - DOCUMENTED |
DBMS_SQL_TRANSLATOR |
24-Oct-2012 |
| New DBMS_SQL_TRANSLATOR_EXPORT package with 6 objects |
DBMS_SQL_TRANSLATOR_EXPORT |
24-Oct-2012 |
| New DBMS_STREAMS_ADM_IVK package with 43 objects |
DBMS_STREAMS_ADM_IVK |
24-Oct-2012 |
| DBMS_SYNC_REFRESH with 14 objects for synchronizing CDBs and PDBs |
DBMS_SYNC_REFRESH |
01-Jun-2013 |
| DBMS_TSDP_MANAGE with 9 documented objects for managing sensitive columns and types supporting Transparent Sensitive Data Protection |
DBMS_TSDP_MANAGE |
01-Jun-2013 |
| DBMS_TSDP_PROTECT with 10 objects for Transparent Sensitive Data Protection |
DBMS_TSDP_PROTECT |
01-Jun-2013 |
| DBMS_XSTREAM_AUTH_IVK with 4 objects |
DBMS_XSTREAM_AUTH_IVK |
25-Oct-2012 |
| DBMS_XSTREAM_GG_INTERNAL with 2 objects |
DBMS_XSTREAM_GG_INTERNAL |
25-Oct-2012 |
| DBMS_XS_FIDM with 3 objects |
XS_FIDM |
25-Oct-2012 |
| DBMS_XS_NSATTR with 1 object |
DBMS_XS_NSATTR |
25-Oct-2012 |
| DBMS_XS_SIDP with 2 objects |
DBMS_XS_SIDP |
25-Oct-2012 |
| DBMS_XS_SYSTEM with 4 objects supporting Real Application Security |
DBMS_XS_SYSTEM |
25-Oct-2012 |
| DBMS_XS_SYSTEM_FFI with 4 objects supporting Real Application Security |
DBMS_XS_SYSTEM_FFI |
25-Oct-2012 |
| DBMS_XS_WEAK_AUTH with 4 objects |
DBMS_XS_WEAK_AUTH |
25-Oct-2012 |
| DMCLAIMP with 6 objects |
DMCLAIMP |
25-Oct-2012 |
| DMCLBIMP with 6 objects |
DMCLBIMP |
25-Oct-2012 |
| DMFEBIMP with 6 objects |
DMFEBIMP |
25-Oct-2012 |
| DMGLMBIMP with 18 objects |
DMGLMBIMP |
25-Oct-2012 |
| DMSVMAIMP with 12 objects |
DMSVMAIMP |
25-Oct-2012 |
| DM_FE_CUR package header with no package body |
DM_FE_CUR |
25-Oct-2012 |
| JAVAVM_SYS with 3 objects |
JAVAVM_SYS |
01-Jun-2013 |
| KBRSI_ICD with 54 objects |
KBRSI_ICD |
25-Oct-2012 |
| OJDS_CONTEXT with 16 objects |
OJDS_CONTEXT |
25-Oct-2012 |
| OJDS_NAMESPACE with 3 objects |
OJDS_NAMESPACE |
25-Oct-2012 |
| PRVTEMX_ADMIN with 53 objects |
PRVTEMX_ADMIN |
25-Oct-2012 |
| PRVTEMX_DBHOME with 8 objects |
PRVTEMX_DBHOME |
25-Oct-2012 |
| PRVTEMX_MEMORY with 1 object |
PRVTEMX_MEMORY |
25-Oct-2012 |
| PRVTEMX_PERF with 2 objects |
PRVTEMX_PERF |
25-Oct-2012 |
| PRVTPARENTCHILD with 2 objects |
PRVTPARENTCHILD |
25-Oct-2012 |
| PRVT_AWRV_METADATA with 7 objects |
PRVT_AWRV_METADATA |
25-Oct-2012 |
| PRVT_AWR_DATA with 27 objects |
PRVT_AWR_DATA |
25-Oct-2012 |
| New PRVT_AWR_DATA_CP package with 4 objects |
PRVT_AWR_DATA_CP |
25-Oct-2012 |
| New PRVT_AWR_INST_META package with 1 object |
PRVT_AWR_INST_META |
25-Oct-2012 |
| New PRVT_AWR_PERIOD package with 5 objects |
PRVT_AWR_PERIOD |
25-Oct-2012 |
| New PRVT_AWR_VIEWER package with 11 objects |
PRVT_AWR_VIEWER |
25-Oct-2012 |
| New PRVT_CPADDM package with 8 objects |
PRVT_CPADDM |
25-Oct-2012 |
| New PRVT_EMX package with 16 objects |
PRVT_EMX |
25-Oct-2012 |
| New PRVT_HDM package with 6 objects |
PRVT_HDM |
25-Oct-2012 |
| New PRVT_ILM package with 45 objects |
PRVT_ILM |
25-Oct-2012 |
| New PRVT_RTADDM package with 3 objects |
PRVT_RTADDM |
25-Oct-2012 |
| New PSTDY_DATAPUMP_SUPPORT package with 2 objects |
PSTDY_DATAPUMP_SUPPORT |
01-Jun-2013 |
| New TSDP$DATAPUMP package with 1 object |
TSDP$DATAPUMP |
01-Jun-2013 |
| New UTL_CALL_STACK package with 13 objects |
UTL_CALL_STACK |
01-Jun-2013 |
| New XS_ACL package with 9 objects |
XS_ACL |
25-Oct-2012 |
| New XS_ACL_INT package with 9 objects |
XS_ACL_INT |
25-Oct-2012 |
| New XS_ADMIN_INT package with 8 objects |
XS_ADMIN_INT |
25-Oct-2012 |
| New XS_ADMIN_UTIL package with 11 objects |
XS_ADMIN_UTIL |
25-Oct-2012 |
| New XS_DATA_SECURITY package with 13 objects |
XS_DATA_SECURITY |
25-Oct-2012 |
| New XS_DATA_SECURITY_INT package with 12 objects |
XS_DATA_SECURITY_INT |
25-Oct-2012 |
| New XS_DATA_SECURITY_UTIL package with 5 objects |
XS_DATA_SECURITY_UTIL |
25-Oct-2012 |
| New XS_DIAG package with 7 objects |
XS_DIAG |
25-Oct-2012 |
| New XS_DIAG_INT package with 2 objects |
XS_DIAG_INT |
01-Jun-2013 |
| New XS_MTCACHE_INT package with 3 objects |
XS_MTCACHE_INT |
25-Oct-2012 |
| New XS_NAMESPACE package with 6 objects and 3 overloads |
XS_NAMESPACE |
25-Oct-2012 |
| New XS_NAMESPACE_INT package with 6 objects and 5 overloads |
XS_NAMESPACE_INT |
25-Oct-2012 |
| New XS_OBJECT_MIGRATION package with 2 objects |
XS_OBJECT_MIGRATION |
25-Oct-2012 |
| New XS_PRINCIPAL package with 21 objects |
XS_PRINCIPAL |
25-Oct-2012 |
| New XS_PRINCIPAL_INT package with 24 objects |
XS_PRINCIPAL_INT |
25-Oct-2012 |
| New XS_ROLESET package with 5 objects |
XS_ROLESET |
25-Oct-2012 |
| New XS_ROLESET_INT package with 5 objects |
XS_ROLESET_INT |
25-Oct-2012 |
| New XS_SECURITY_CLASS package with 9 objects |
XS_SECURITY_CLASS |
25-Oct-2012 |
| New XS_SECURITY_CLASS_INT package with 9 objects |
XS_SECURITY_CLASS_INT |
25-Oct-2012 |
| |
| Built-in Packages with New or Removed Functions and Procedures |
| DBMS_ADDM has 5 new functions |
DBMS_ADDM |
01-Jun-2013 |
| DBMS_ADR has 7 new objects and new constants |
DBMS_ADR |
01-Jun-2013 |
| DBMS_APBACKEND has new GETSTOREID function |
|
- |
| DBMS_APPLY_ADM has 3 new procedures one with an overload |
DBMS_APPLY_ADM |
01-Jun-2013 |
| DBMS_APPLY_ADM_INTERNAL.RECOVER_APPLY_PROGRESS dropped |
|
- |
| DBMS_APPLY_ADM_INTERNAL has 2 new objects |
|
- |
| DBMS_APP_CONT_PRVT has 2 new objects |
DBMS_APP_CONT_PRVT |
01-Jun-2013 |
| DBMS_AQADM has 2 new objects: CREATE_SHARDED_QUEUE and DROP_SHARDED_QUEUE |
DBMS_AQADM |
01-Jun-2013 |
| DBMS_AQADM_SYS has 9 new objects one of which is overloaded |
|
- |
| DBMS_AQADM_SYSCALLS has 3 new objects |
|
- |
| DBMS_AQJMS has 17 new objects |
|
- |
| DBMS_AQJMS_INTERNAL has 3 new objects |
|
- |
| DBMS_AQ_EXP_QUEUE_TABLES has 2 new objects |
|
- |
| DBMS_AQ_IMP_INTERNAL has new IMPORT_QUEUE_DQTMAP object |
|
- |
| DBMS_AQ_IMP_INTERNAL has 6 new objects |
|
- |
| DBMS_AQ_SYS_EXP_ACTIONS has 3 new objects |
|
- |
| DBMS_AQ_SYS_EXP_INTERNAL has 5 new objects |
|
- |
| DBMS_AQ_SYS_IMP_INTERNAL has 12 new objects |
|
- |
| DBMS_ASH_INTERNAL has 3 new objects |
|
- |
| DBMS_AUDIT_MGMT has 3 new objects: 1 overloaded |
DBMS_AUDIT_MGMT |
01-Jun-2013 |
| DBMS_AUTO_REPORT has 7 new objects |
|
- |
| DBMS_AUTO_REPORT_INTERNAL has 2 new objects |
|
- |
| DBMS_AUTO_TASK_ADMIN new DEFAULT_RESET procedure |
DBMS_AUTO_TASK_ADMIN |
01-Jun-2013 |
| DBMS_BACKUP_RESTORE has 5 objects removed |
DBMS_BACKUP_RESTORE |
01-Jun-2013 |
| DBMS_BACKUP_RESTORE has 41 new objects and overloads |
DBMS_BACKUP_RESTORE |
01-Jun-2013 |
| DBMS_CAPTURE_ADM_INTERNAL has 10 new objects |
|
- |
| DBMS_CUBE has 8 new objects |
DBMS_CUBE |
01-Jun-2013 |
| DBMS_CUBE_UTIL new 2 new objects CREATE_RPT_FILTER with two overloads |
|
- |
| DBMS_DATA_MINING.GET_MODEL_DETAILS_ABN dropped |
|
- |
| DBMS_DATA_MINING has 4 new objects |
|
- |
| DBMS_DATA_MINING_INTERNAL.CREATE_TEMP_META_TABLE dropped |
|
- |
| DBMS_DATA_MINING_INTERNAL has 3 new objects |
|
- |
| DBMS_DATAPUMP has 3 new objects |
DBMS_DATAPUMP |
01-Jun-2013 |
| DBMS_DATAPUMP_UTL has 4 new objects |
DBMS_DATAPUMP_UTL |
01-Jun-2013 |
| DBMS_DBFS_CONTENT_ADMIN has 4 new objects |
DBMS_DBFS_CONTENT_ADMIN |
01-Jun-2013 |
| DBMS_DBFS_SFS_ADMIN has 11 new objects |
DBMS_DBFS_SFS_ADMIN |
01-Jun-2013 |
| DBMS_DM_EXP_INTERNAL has 8 objects removed |
|
- |
| DBMS_DM_IMP_INTERNAL package dropped |
|
- |
| DBMS_DM_MODEL_EXP.INSTANCE_INFO_EXP, SCHEMA_CALLOUT, and SCHEMA_INFO_EXP dropped |
|
- |
| DBMS_DM_MODEL_EXP new AUDIT_EXP, AUDIT_SYSPRIVS_EXP, CREATE_EXP, GRANT_EXP, and GRANT_SYSPRIVS_EXP |
|
- |
| DBMS_DM_UTIL.DISPLAY_MSG and DUMP_MSG dropped |
|
- |
| DBMS_DM_UTIL new NUMVAL object |
|
- |
| DBMS_DM_UTIL_INTERNAL package dropped |
|
- |
| DBMS_EDITIONS_UTILITIES new SET_NULL_COLUMN_VALUES_TO_EXPR procedure |
DBMS_EDITIONS_UTILITIES |
01-Jun-2013 |
| DBMS_FLASHBACK_ARCHIVE has 16 new objects |
DBMS_FLASHBACK_ARCHIVE |
01-Jun-2013 |
| DBMS_INTERNAL_LOGSTDBY dropped 7 objects and has 14 new objects |
DBMS_INTERNAL_LOGSTDBY |
01-Jun-2013 |
| DBMS_IREFRESH new ENQUOTE_LITERAL object |
|
- |
| DBMS_ISCHED has 11 new objects |
|
- |
| DBMS_ISNAPSHOT has new FIND_DBLINKS object |
|
- |
| DBMS_JAVA has 16 objects removed and 4 new ones added |
DBMS_JAVA |
01-Jun-2013 |
| DBMS_LOBUTIL has new, overloaded, COPY_PRIMARY_DEDUP proc |
DBMS_LOBUTIL |
01-Jun-2013 |
| DBMS_LOCK new ALLOCATE_UNIQUE_AUTONOMOUS procedure |
DBMS_LOCK |
01-Jun-2013 |
| DBMS_LOGMNR_D new SET_TABLESPACE procedure |
DBMS_LOGMNR_D |
01-Jun-2013 |
| DBMS_LOGMNR_INTERNAL has 4 objects removed and LOGMNR_KRVIBLD added |
|
- |
| DBMS_LOGREP_UTIL has 5 new objects |
DBMS_LOGREP_UTIL |
01-Jun-2013 |
| DBMS_LOGSTDBY.EDS_EVOLVE_TABLE and VALIDATE_AUTH removed: EDS_EVOLVE_AUTOMATIC and
EDS_EVOLVE_MANUAL added |
DBMS_LOGSTDBY |
01-Jun-2013 |
| DBMS_METADATA has 3 new objects |
DBMS_METADATA |
01-Jun-2013 |
| DBMS_METADATA_INT has new GET_OBJECT_TYPE_INFO object |
|
- |
| DBMS_METADATA_UTIL has 10 new objects |
DBMS_METADATA_UTIL |
01-Jun-2013 |
| DBMS_NETWORK_ACK_ADMIN has multiple new objects and 7 newly deprecated objects. HANDLEPREDELETE has
been dropped |
DBMS_NETWORK_ACL_ADMIN |
01-Jun-2013 |
| DBMS_OBJECTS_UTILS has two new procedures |
DBMS_OBJECTS_UTILS |
01-Jun-2013 |
| DBMS_RCVMAN has 11 new objects |
DBMS_RCVMAN |
01-Jun-2013 |
| DBMS_REDEFINITION has new REDEF_TABLE procedure |
DBMS_REDEFINITION |
01-Jun-2013 |
| DBMS_REDEFINITION_INTERNAL has 10 new objects |
DBMS_REDEFINITION_INTERNAL |
01-Jun-2013 |
| DBMS_REGISTRY has 7 new objects one overloaded |
DBMS_REGISTRY |
01-Jun-2013 |
| DBMS_REGISTRY_SYS has 8 new objects |
DBMS_REGISTRY_SYS |
01-Jun-2013 |
| DBMS_REPORT.CREATE_SHARED_DIRECTORY, DROP_SHARED_DIRECTORY, and STORE_FILE removed |
DBMS_REPORT |
01-Jun-2013 |
| DBMS_RLS has new ALTER_GROUPED_POLICY and ALTER_POLICY procedures |
DBMS_RLS |
01-Jun-2013 |
| DBMS_RMIN has 23 objects removed and 2 new objects added |
|
- |
| DBMS_RULE has new EVALUATE_EXPRESSION and IS_FAST objects |
|
- |
| DBMS_RULE_EXP_UTL has new ENQUOTE_NAME and IS_SYSTEM_EXPORT objects |
|
- |
| DBMS_SCHEDULER has four new objects |
DBMS_SCHEDULER |
01-Jun-2013 |
| DBMS_SCHED_MAIN_EXPORT has new I_INSTANCE_CALLOUT_IMP and I_SYSTEM_CALLOUT_IMP objects |
|
- |
| DBMS_SERVICE has new IMPORT_CRS_SERVICES procedure |
DBMS_SERVICE |
01-Jun-2013 |
| DBMS_SESSION has new USE_DEFAULT_EDITION_DEFERRED procedure |
DBMS_SESSION |
01-Jun-2013 |
| DBMS_SMB has new UPGRADE_STGTAB object |
|
- |
| DBMS_SMB_INTERNAL has new CHECK_SMO_PROPS and GET_PLAN_FROM_STGTAB objects |
|
- |
| DBMS_SNAP_INTERNAL has new SET_I_AM_AN_ACLMV and TRANSFORM_DDL objects |
|
- |
| DBMS_SPACE_ADMIN new TABLESPACE_FIX_AFFINITY procedure |
DBMS_SPACE_ADMIN |
01-Jun-2013 |
| DBMS_SPM has 12 new objects related to baseplane evolution |
DBMS_SPM |
01-Jun-2013 |
| DBMS_SPM_INTERNAL.FETCH_PLAN_INFO and GET_SPM_HINTSET removed |
|
- |
| DBMS_SQADM_SYSCALLS has 4 new objects |
|
- |
| DBMS_SQL.BIND_ARRAY and DEFINE_ARRAY support 32K VARCHAR2s |
DBMS_SQL |
01-Jun-2013 |
| DBMS_SQL has new GET_NEXT_RESULT and RETURN_RESULT objects |
DBMS_SQL |
01-Jun-2013 |
| DBMS_SQLDIAG has new REPLAY_SQL_TESTCASE procedure |
DBMS_SQLDIAG |
01-Jun-2013 |
| DBMS_SQLDIAG_INTERNAL has new I_GENERATE_PARAM_IMPORT object |
|
- |
| DBMS_SQLTCB_INTERNAL has 5 new objects |
|
- |
| DBMS_SQLTUNE_INTERNAL has 7 new objects and new container related parameters |
|
- |
| DBMS_SQLTUNE_UTIL0 has 4 new objects and new container related parameters |
|
- |
| DBMS_SQLTUNE_UTIL1 has new GET_DBID_FROM_CONID object and new container related parameters |
|
- |
| DBMS_SQLTUNE_UTIL2 has new GET_TIMING_INFO object |
|
- |
| DBMS_STATS has 21 new objects including support for Containers |
DBMS_STATS |
01-Jun-2013 |
| DBMS_STATS_INTERNAL.GET_CHTAB removed |
|
- |
| DBMS_STREAMS_ADM_UTL has new CREATE_RULE_STRING_PROCEDURE object |
|
- |
| DBMS_SWRF_REPORT_INTERNAL.TO_1000S and TO_1024S removed and 16 new objects |
|
- |
| DBMS_TTS has 4 new objects |
DBMS_TTS |
01-Jun-2013 |
| DBMS_WRR_INTERNAL has 10 new objects |
DBMS_WRR_INTERNAL |
01-Jun-2013 |
| DBMS_XDBUTIL_INT has new INSTANCE_CALLOUT_IMP and INSTANCE_EXPORT_ACTION objects |
DBMS_XDBUTIL_INT |
01-Jun-2013 |
| DBMS_XDS.REFRESH_DSD removed and 8 new objects added |
|
- |
| DBMS_XPLAN has several few pipelined table functions |
DBMS_XPLAN |
01-Jun-2013 |
| DBMS_XSTREAM_ADM_INTERNAL has new UPDATE_GOLDENGATE_PRIVILEGE object |
|
- |
| DBMS_XSTREAM_ADM_UTL has 3 new objects |
DBMS_XSTREAM_ADM_UTL |
01-Jun-2013 |
| DBMS_XSTREAM_GG_ADM has 50 new objects and overloads |
|
- |
| DBMS_XSTREAM_GG_INTERNAL has 2 new objects |
|
- |
| DBMS_XS_MTCACHE.SECCLS_DELETE and SECCLS_UPDATE removed |
DBMS_XS_MTCACHE |
01-Jun-2013 |
| DBMS_XS_PRINCIPALS has 2 objects removed and 3 new objects added |
|
- |
| DBMS_XS_SESSIONS has 6 objects removed and 4 new objects added |
|
- |
| DBMS_XS_SESSIONS_FFI has 6 objects removed and 3 new objects added |
|
- |
| DIANA has 9 new objects |
|
|
| DMP_SEC.GET_MODEL_DETAILS_ABN removed |
|
- |
| DMP_SYS has 4 objects removed and 4 new objects added |
|
- |
| DM_QGEN has had the LS_DUMP procedure removed and 2 new objects added |
DM_QGEN |
01-Jun-2013 |
| INITJVMAUX has 2 new objects |
|
- |
| LOGMNR_DICT_CACHE.PURGE_SCN removed |
|
01-Jun-2013 |
| LOGSTDBY_INTERNAL.EDS_EVOLVE_TABLE_1_I removed |
|
01-Jun-2013 |
| ODM_CLUSTERING_UTIL.IS_DEBUG_ENABLED removed |
|
- |
| ODM_MODEL_UTIL has 5 objects removed |
|
- |
| ODM_UTIL.COMPUTE_LOG_COMBINATIONS removed and 3 new objects: 2 with 4 overloads |
|
- |
| PRVT_COMPRESSION has 4 new objects |
PRVT_COMPRESSION |
01-Jun-2013 |
| UTL_I18N has a new function GET_MAX_CHARACTER_SIZE |
UTL_I18N |
01-Jun-2013 |
| UTL_XML has 8 new objects |
UTL_XML |
01-Jun-2013 |
| UTL_XML objects XMLGETTABLEFROMDOC, XMLTERM and XSLSETSTYLESHEET removed |
UTL_XML |
01-Jun-2013 |
| WWV_DBMS_SQL has 4 new objects |
<==== |
- |
| |
| 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 |
|
22-Oct-2012 |
| DBMSOBJG2 has new parameters in all 3 procs |
|
22-Oct-2012 |
| DBMSOBJG_DP has three new parameters in GENERATE_DDL_DP |
|
22-Oct-2012 |
| DBMS_COMPRESSION.GET_COMPRESSION_RATIO now has 3 overloads |
DBMS_COMPRESSION |
01-Jun-2013 |
| DBMS_DATAPUMP has a new overload 5 of GET_STATUS |
DBMS_DATAPUMP |
01-Jun-2013 |
| DBMS_LOGMNR_LOGREP_DICT has new overloads for ADD_COL and ADD_OBJ |
|
- |
| DBMS_METADATA_INT.SET_OBJECTS_FETCHED has new overload 3 |
|
- |
| DBMS_PICKLER.GET_TYPE_SHAPE has two new overloads |
DBMS_PICKLER |
01-Jun-2013 |
| DBMS_SQL.BIND_VARIABLE_ROWID is no longer overloaded and PARSE no longer has overloads 5-12 |
DBMS_SQL |
01-Jun-2013 |
| DBMS_SYS_SQL has overloads removed, overloads added, and two new functions with overloads |
DBMS_SYS_SQL |
01-Jun-2013 |
| DBMS_XS_PRINCIPALS.SET_PASSWORD overload removed |
|
01-Jun-2013 |
| DBMS_XS_SESSIONS.SET_ATTRIBUTE overload removed |
|
01-Jun-2013 |
| ODM_MODEL_UTIL.DROP_TABLE overload removed |
|
01-Jun-2013 |
| DBMS_PRVTAQIM has new CREATE_BASE_VIEW11_2_0 and CREATE_BASE_VIEW_12C objects |
|
- |
| DBMS_PRVTAQIS has 15 new objects |
|
- |
| DBMS_SERVICE.CREATE_SERVICE and MODIFY_SERVICE are now overloaded |
DBMS_SERVICE |
01-Jun-2013 |
| UTL_XML SSCFIND 3 args |
UTL_XML |
22-Oct-2012 |
| UTL_XML SSCGETCTX 2 args |
UTL_XML |
22-Oct-2012 |
| UTL_XML SSCMINIMIZECACHE 1 arg |
UTL_XML |
22-Oct-2012 |
| UTL_XML SSCPARSE 3 args |
UTL_XML |
22-Oct-2012 |
| UTL_XML SSCPURGE 1 arg |
UTL_XML |
22-Oct-2012 |
| UTL_XML SSCSETDEBUG 1arg |
UTL_XML |
22-Oct-2012 |
| UTL_XML XMLDUMPCTXS 1arg |
UTL_XML |
22-Oct-2012 |
| UTL_XML XMLSETMEMDEBUG 1arg |
UTL_XML |
22-Oct-2012 |
| UTL_XML XMLTERM 1 - removed |
UTL_XML |
22-Oct-2012 |
| WWV_DBMS_SQL.PARSE_AS_USER and RUN_DDL each have one new overload |
|
- |
| |
| Built-in Packages with Parameters Changes |
| DBMS_AUDIT_MGMT.CLEAN_AUDIT_TRAIL has new CONTAINER parameter |
DBMS_AUDIT_MGMT |
01-Jun-2013 |
| DBMS_AUDIT_MGMT.CLEAR_LAST_ARCHIVE_TIMESTAMP has new CONTAINER parameter |
DBMS_AUDIT_MGMT |
01-Jun-2013 |
| DBMS_AUDIT_MGMT.CREATE_PURGE_JOB has new CONTAINER parameter |
DBMS_AUDIT_MGMT |
01-Jun-2013 |
| DBMS_AUDIT_MGMT.DEINIT_CLEANUP has new CONTAINER parameter |
DBMS_AUDIT_MGMT |
01-Jun-2013 |
| DBMS_AUDIT_MGMT.INIT_CLEANUP has new CONTAINER parameter |
DBMS_AUDIT_MGMT |
01-Jun-2013 |
| DBMS_AUDIT_MGMT.IS_CLEANUP_INITIALIZED has new CONTAINER parameter |
DBMS_AUDIT_MGMT |
01-Jun-2013 |
| DBMS_AUDIT_MGMT.SET_LAST_ARCHIVE_TIMESTAMP has new CONTAINER parameter |
DBMS_AUDIT_MGMT |
01-Jun-2013 |
| DBMS_APPLY_ADM.SET_TABLE_xxx_SCN procs have a new SOURCE_ROOT_NAME parameter |
DBMS_APPLY_ADM |
01-Jun-2013 |
| DBMS_CAPTURE_ADM.CREATE_CAPTURE has new SOURCE_ROOT_NAME and CAPTURE_CLASS parameters |
DBMS_CAPTURE_ADM |
01-Jun-2013 |
| DBMS_CLIENT_RESULT_CACHE has new parameters |
DBMS_CLIENT_RESULT_CACHE |
01-Jun-2013 |
| DBMS_GOLDENGATE_AUTH procedures have new CONTAINER parameter |
DBMS_GOLDENGATE_AUTH |
01-Jun-2013 |
| DBMS_INDEX_UTL has new FORCED_DEGREE parameter |
DBMS_INDEX_UTL |
01-Jun-2013 |
| DBMS_SCHEDULER.RUN_JOB has one new parameter and SUBMIT_REMOTE_EXTERNAL_JOB has four new parameters |
DBMS_SCHEDULER |
01-Jun-2013 |
| DBMS_SQLPA has new CON_DBID and CON_NAME parameters to provide Container DB support: Also new
default analysis parameters |
DBMS_SQLPA |
01-Jun-2013 |
| DBMS_SQLTUNE has new AUTOTUNE_PERIOD parameter |
DBMS_SQLTUNE |
To be done |
| DBMS_STATS type ObjectElem dropped the confidence element and multiple objects with new parameters |
DBMS_STATS |
01-Jun-2013 |
| |
| Built-in Packages with new Constants, Exceptions, Types, and other significant changes |
| DBMS_AQADM has new sort_list parameter |
DBMS_AQADM |
01-Jun-2013 |
| DBMS_COMPRESSION has 10 new constants |
DBMS_COMPRESSION |
01-Jun-2013 |
| DBMS_CRYPTO has new SHA2 constants |
DBMS_CRYPTO |
01-Jun-2013 |
| DBMS_DATA_PUMP has 18 new constants and a new value for KU$_STATUS_VERSION |
DBMS_DATAPUMP |
01-Jun-2013 |
| DBMS_DB_VERSION has new Version 12 constants |
DBMS_DB_VERSION |
01-Jun-2013 |
| DBMS_METADATA has new MARKER_STATISTICS constant and new XS_USER object_type |
DBMS_METADATA |
01-Jun-2013 |
| UTL_IDENT has new IS_ORACLE_XE constant |
UTL_IDENT |
01-Jun-2013 |
