| Description |
Link |
Last Modified |
| General |
| No New Changes Found So Far |
- |
- |
| |
| Deprecated |
| IS_OBJECT_XDB_GENERATED and SET_PARSING dropped |
DBMS_METADATA |
06-Feb-2012 |
| BINARY2VARCHAR, GET_HASHCODE, SET_PARSING, UPDATE_FEATURE_TABLE dropped |
DBMS_METADATA_UTIL |
06-Feb-2012 |
| createRepositoryXMLIndex, XMLIndexAddPath, XMLIndexRemovePath, and dropRepositoryXMLIndex |
DBMS_XDB_ADMIN |
07-Jan-2012 |
| XML schema annotation (attribute) csx:encodingType |
- |
05-Jan-2012 |
| XMLIndex index on CLOB portions of hybrid XMLType storage, that is, on CLOB data that is embedded within object-relational storage |
- |
05-Jan-2012 |
| |
| SQL |
| No New SQL Syntax Found So Far |
- |
- |
| |
| PL/SQL |
| No New PL/SQL Syntax Found So Far |
- |
- |
| |
| XML |
| No New XML Syntax Found So Far |
- |
- |
| |
| New Built-in Packages |
| DBMS_APP_CONT_PRVT |
DBMS_APP_CONT_PRVT |
27-Dec-2011 |
| DBMS_REDEFINITION_INTERNAL |
DBMS_REDEFINITION_INTERNAL |
28-Dec-2011 |
| DBMS_SQL2 |
DBMS_SQL2 |
29-Dec-2011 |
| XDB.DBMS_XMLDOM_ICD |
DBMS_XMLDOM_ICD |
- |
| DBMS_XSTREAM_GG |
DBMS_XSTREAM_GG |
- |
| DBMS_XSTREAM_GG_ADM |
DBMS_XSTREAM_GG_ADM |
- |
| DBMS_XSTREAM_UTL_IVK |
DBMS_XSTREAM_UTL_IVK |
- |
| CTXSYS.DRIENT |
DRIENT |
- |
| CTXSYS.DRISGP |
DRISGP |
- |
| CTXSYS.DRIXMD |
DRIXMD |
- |
| CTXSYS.DRVDML |
DRVDML |
- |
| CTXSYS.DRVPARX |
DRVPARX |
- |
| CTXSYS.DRVXMD |
DRVXMD |
- |
| CTXSYS.DRVXTAB |
DRVXTAB |
- |
| ORACLE_OCM.MGMT_DB_LL_METRICS |
MGMT_DB_LL_METRICS |
07-Jan-2012 |
| |
| Built-in Packages with new Functions and Procedures |
| New CONCAT_RESULT_COL, CONTROL_FILE_LIST, REDO_FILE_LIST, and REDO_GROUP_NUM_LIST objects |
CONFIG_UTIL |
- |
| New ADD_SDATA, REMOVE_SDATA, SET_SECTION_ATTRIBUTE, and UNSET_SECTION_ATTRIBUTE |
CTX_DDL |
28-Dec-2011 |
| New LOGFILEOVERWRITE procedure |
CTX_OUTPUT |
- |
| New OFFSET_INFO procedure |
CTX_REPORT |
- |
| New EXPORT_THESAURUS and IMPORT_THESAURUS procedures |
CTX_THES |
- |
| New HANDLE_COLLISIONS, RESET_CONFIGURATION, and SET_REPERROR_HANDLER procedures |
DBMS_APPLY_ADM_INTERNAL |
- |
| New IN_AW_CLEANUP procedure |
DBMS_AW |
10-Feb-2012 |
| New RMAN_USAGE function |
DBMS_BACKUP_RESTORE |
25-Dec-2011 |
| New IS_GOLDENGATE_CAPTURE function |
DBMS_CAPTURE_ADM_INTERNAL |
- |
| New GET_CSO_NAME function |
DBMS_CDC_ISUBSCRIBE |
- |
| New MOVEPATH, REMOUNTALL, REMOUNTSTORE, and UNMOUNTALL procedures |
DBMS_DBFS_CONTENT |
28-Dec-2011 |
| Seven new stored procedures |
DBMS_DBFS_CONTENT_ADMIN |
16-Jan-2012 |
| New CLEANUPORPHANS, MOVEPATH, RECREATEGETATTRVIEW, and REORGANIZEFS procedures |
DBMS_DBFS_SFS |
16-Jan-2012 |
| Thirteen new procedures |
DBMS_DBFS_SFS_ADMIN |
18-Jan-2012 |
| Many new functions and procedures |
DBMS_FUSE |
- |
| New CREATE_REJECT_SQL function |
DBMS_CUBE_LOG |
27-Dec-2011 |
| New GET_EXT_METADATA function |
DBMS_CUBE_UTIL |
- |
| New GRANT_REMOTE_ADMIN_ACCESS and REVOKE_REMOTE_ADMIN_ACCESS procedures |
DBMS_GOLDENGATE_AUTH |
13-Jan-2012 |
| New DATA_ONLY_PREREQ and SET_TABLE_SCN procedures |
DBMS_INTERNAL_LOGSTDBY |
- |
| New IS_SCHEDULER_CREATED_AGENT function |
DBMS_ISCHED |
- |
| New GETDEDUPSET function with two overloads |
DBMS_LOBUTIL |
25-Dec-2011 |
| New SET_PARAMETER and UNSET_PARAMETER procedures |
DBMS_LOGMNR_INTERNAL |
- |
| Many new functions and procedures |
DBMS_LOGREP_UTIL |
- |
| New GET_VAT_TABLE_NAME, IN_TSNUM, IS_XDB_TRANS and SET_VAT_TABLE_NAME objects |
DBMS_METADATA |
06-Feb-2012 |
| New MODIFY_VAT procedure |
DBMS_METADATA_INT |
- |
New BLOB2CLOB, HAS_TSTZ_COLS, HAS_TSTZ_ELEMENTS, GET_BASE_COL_NAME, GET_MARKER,
GET_XMLCOLSET, GET_XMLHIERARCHY, isXml, and IS_SCHEMANAME_EXISTS functions |
DBMS_METADATA_UTIL |
06-Feb-2012 |
| New EXPLAIN_REWRITE_SQLID procedure |
DBMS_MVIEW |
25-Dec-2011 |
| New SPLIT_SOURCE function and UPDATE_TYPES procedure |
DBMS_OBJECT_UTILS |
25-Dec-2011 |
| New ISSELFCONTAINED function |
DBMS_PLUGTS |
26-Dec-2011 |
| New DUMPPKGSTATE procedure |
DBMS_RCVMAN |
31-Dec-2011 |
| New IS_SCHEDULER_CREATED_AGENT function |
DBMS_SCHEDULER |
30-Dec-2011 |
| New EXPLAIN_REWRITE_SQLID procedure |
DBMS_SNAPSHOT |
25-Dec-2011 |
| New FETCH_NAME_USING_SIG_CAT_PID function |
DBMS_SPM_INTERNAL |
11-Jan-2012 |
| New GET_MV_ENQUE, GET_PART_COLS, GET_PREV_PART, and IS_PART_DEFAULT objects |
DBMS_STATS_INTERNAL |
- |
| New UPDATE_APPLY_PARALLELISM procedure |
DBMS_STREAMS_ADV_ADM_UTL |
- |
| New GET_LCR_CONTENT function |
DBMS_STREAMS_LCR_INT |
- |
| New IS_UNCOMMITTED_XOUT function |
DBMS_STREAMS_SM |
- |
| New GET_PROTECTED_CE_TAB_KEY, GET_PROTECTED_TSE_KEY and SET_PASSPHRASE procedures |
DBMS_TTS |
26-Dec-2011 |
| New GET_CPU_COUNT and SET_CPU_COUNT procedures and new GET_CAPABILITIES function |
DBMS_WLM |
25-Dec-2011 |
| New IMOVEXDB_TABLESPACE and REBUILDHIERARCHICALINDEX procedures |
DBMS_XDB_ADMIN |
07-Jan-2012 |
| New IMPORTSEQUENCE and SYSTEM_INFO_EXP procedures |
DBMS_XDBUTIL_INT |
13-Jan-2012 |
| New PROCESS_PENDING procedure |
DBMS_XMLINDEX |
- |
| New RELOAD_SXI_LEAF procedure |
DBMS_XMLINDEX0 |
- |
| New XPLNRW_EM_3GLT procedure |
DBMS_XRWMV |
- |
| New GET_OPTIONAL_PRIVILEGES funtion and UPDATE_XSERVER_CONNECT_USER procedure |
DBMS_XSTREAM_ADM_INTERNAL |
- |
| New ALTER_OUTBOUND, GET_LCR_CONTENT, and GRANT_CONNECT_USER_PRIVILEGE procedures |
DBMS_XSTREAM_ADM_UTL |
- |
| New TAB_INIT procedure |
HM_SQLTK_INTERNAL |
- |
| New DROP_SROS procedure |
INITJVMAUX |
- |
| New GET_OBFPWD function |
KUPF$FILE_INT |
- |
| New CHECK_ENCRYPTION_WALLET function |
KUPU$UTILITIES_INT |
- |
| New REMOTE_SAVE_COLSET procedure |
LOGMNR_DICT_CACHE |
- |
| New GET_EXPANDED_NEXTVERS_NP procedure |
LT_UTIL |
- |
| New EXPORT_MAPPING_VIEW_FUNC procedure |
LT_EXPORT_PKG |
- |
| |
| Built-in Packages with new Overloads |
| New Overload 3 for the FETCH_OBJNUMS function |
DBMS_METADATA |
06-Feb-2012 |
| New Overload 1 for the GETCOPYOFDATAFILE procedure (previous 1 becomes 2 and 2 becomes 3) |
DBMS_RCVMAN |
31-Dec-2011 |
| |
| Built-in Packages with Parameters Changes |
| New parameters for ADD_STOPCLASS and OPTIMIZE_INDEX |
CTX_DDL |
28-Dec-2011 |
| New SUMMARY and MASTER_ID parameters for seven separate procedures |
DBMS_AWR_REPORT_LAYOUT |
14-Jan-2012 |
| Many procedures with new parameters |
DBMS_DBFS_SFS |
16-Jan-2012 |
| New parameters for GRANT_ADMIN_PRIVILEGE and REVOKE_ADMIN_PRIVILEGE procedures |
DBMS_GOLDENGATE_AUTH |
13-Jan-2012 |
| New GLOBAL parameter for the CREATE_PIPE procedure |
DBMS_PIPE |
28-Dec-2011 |
| New parameters for procedure checkPluggable |
DBMS_PLUGTS |
26-Dec-2011 |
| New SUBMIT_REMOTE_EXTERNAL_JOB log_id parameter |
DBMS_SCHEDULER |
30-Dec-2011 |
| New ISSELFCONTAINED parameters |
DBMS_TTS |
26-Dec-2011 |
| New PLAN_NAME and DESCRIPTION parameters for the LOAD_PLANS_SET function |
DBMS_SPM_INTERNAL |
11-Jan-2012 |
| |
| Built-in Packages with new Constants, Exceptions, Types, and other significant changes |
| Nine new exception handlers |
DBMS_APPLY_ADM |
19-Jan-2012 |
| New Compression Level Added to DBMS_COMPRESSION for Pillar Axiom and Sun ZFSSA |
DBMS_COMPRESSION |
25-Dec-2011 |
| New REJECT_IDS and REJECT_SQL VARRAY data types |
DBMS_CUBE_LOG |
27-Dec-2011 |
| New bitmask defs for the flags field of dictionary table impcalloutreg$ and many new constants |
DBMS_DATAPUMP |
19-Jan-2012 |
| New parameters in DIR_ENTRY_T record data tpe |
DBMS_DBFS_SFS |
16-Jan-2012 |
| New MARKER constant |
DBMS_METADATA_UTIL |
06-Feb-2012 |
| New value for the RELEASE_VERSION constant |
DBMS_REGISTRY |
26-Dec-2011 |
| utlspadv.sql now drops the package if it is installed as either SYS or SYSTEM |
DBMS_SPADV |
25-Dec-2011 |
| New ENCRYPTED and OBFUSCATED constants |
DBMS_TTS |
26-Dec-2011 |
| New ERR_LRG_PCS constant |
DBMS_WLM |
25-Dec-2011 |
| Three new constants |
DBMS_XSTREAM_ADM |
19-Jan-2012 |
| Backport celsbern_bug-12584760 from st_rdbms_11.2.0 and new badseconds_num constant |
USER_LOCK |
25-Dec-2011 |