New In Oracle Database 11gR2 Version 11.2.0.3
 
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
 
Related Topics
New in 11.2.0.1
New in 11.2.0.2
New in 12.1
 
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-2014 Daniel A. Morgan All Rights Reserved