New In Oracle Database 11gR2 Version 11.2.0.2
 
Description Link Last Modified
General
None Found So Far - -
 
Deprecated
DBMS_ADVISOR: Many procedures related to SQL Workloads (SQLWKLD) DBMS_ADVISOR 28-Sep-2010
Function IS_OBJECT_XDB_GENERATED Dropped DBMS_METADATA_UTIL 29-Oct-2010
 
SQL
TRUNCATE syntax enhancement TRUNCATE 26-Dec-2011
 
PL/SQL
New DBMS_FEATURE_DEFERRED_SEG_CRT procedure DBMS_FEATURE Procs 18-Jan-2011
 
XML
None Found So Far - -
 
New Built-in Packages
CTX_TREE (owned by CTXSYS) CTX_TREE  
DBMS_ADR DBMS_ADR 02-Oct-2010
DBMS_AUTO_SQLTUNE DBMS_AUTO_SQLTUNE 30-Oct-2010
DBMS_DNFS DBMS_DNFS 04-Oct-2010
DBMS_FINE_GRAIN_DEP DBMS_FINE_GRAIN_DEP 07-Oct-2010
DBMS_GOLDENGATE_AUTH DBMS_GOLDENGATE_AUTH 09-Oct-2010
DBMS_MGD_ID_UTL DBMS_MGD_ID_UTL 07-Feb-2011
DBMS_RULE_INTERNAL DBMS_RULE_INTERNAL  
DBMS_XSTREAM_ADM_INTERNAL DBMS_XSTREAM_ADM_INTERNAL  
DBMS_XSTREAM_AUTH DBMS_XSTREAM_AUTH  
DBMS_XSTREAM_GG DBMS_XSTREAM_GG  
DBMS_XSTREAM_GG_ADM DBMS_XSTREAM_GG_ADM  
DBMS_XSTREAM_UTL_IVK DBMS_XSTREAM_UTL_IVK  
MGMT_PREFERENCES MGMT_PREFERENCES  
 
Built-in Packages with new Functions and Procedures
New RESET_AUTO_OPTIMIZE_STATUS and STOP_OPTIMIZE procedures CTX_ADM -
Many New procedures and functions CTX_DDL 04-Feb-2011
New VALIDATE_INDEX procedure CTX_REPORT -
Four new procedures DBMS_AQ_INV -
New GET_CONNECT_IDENTIFIER and SWITCH_PRIMARY_BCT functions DBMS_BACKUP_RESTORE 30-Oct-2010
New SET_XOUT_PARAMS DBMS_CAPTURE_ADM_INTERNAL -
New VERIFY_CDC_NAME procedure DBMS_CDC_UTILITY 30-Oct-2010
New CREATE_EXPORT_OPTIONS, CREATE_IMPORT_OPTIONS, and UPGRADE_AW procedures DBMS_CUBE 30-Oct-2010
New INSTANCE_INFO_IMP_DS_11_2_0_2 procedure DBMS_CUBE_EXP -
New COMPLETE_OPLOG, START_OPLOG, WRITE_TO_OPLOG procedures DBMS_CUBE_LOG 31-Oct-2010
New GET_DIMENSION_SPECIAL_MEMBER function DBMS_CUBE_UTIL -
New IMPORT_PMML_MODEL procedure DBMS_DATA_MINING_INTERNAL -
New GETATTR_VIEW function and LISTCURSOR procedure DBMS_DBFS_CONTENT 24-Nov-2010
Four new procedures DBMS_DBFS_CONTENT_SPI -
Forty-eight new functions and procedures DBMS_DBFS_SFS 01-Nov-2010
Five new functions and procedures DBMS_DBFS_SFS_ADMIN -
New VALIDATE_ITEM procedure DBMS_EXPFIL_DR -
New VALIDATE_EXPR procedure DBMS_EXPFIL_UTL -
New SET_HAKAN_EVENT procedure DBMS_EXPORT_EXTENSION -
New FS_GETATTR_VIEW function DBMS_FUSE -
Six new procedures and functions DBMS_INTERNAL_LOGSTDBY -
New DROP_CHANGE_TABLE procedure DBMS_IPUBLISH -
New EVALUATE_RULESET, GET_NOTIFICATIONS, and GET_STEP_STATE_CF procedures DBMS_ISCHED -
New STEP_TABLE_POPULATED procedure DBMS_ISCHED_CHAIN_CONDITION -
New FETCH_OBJNUMS_NAMES and IS_ATTR_VALID_ON_10 functions DBMS_METADATA 20-Jan2011
New BEGIN_SQL_BLOCK and END_SQL_BLOCK procedures DBMS_RESOURCE_MANAGER 29-Nov-2010
New MARKHOT and UNMARKHOT procedures DBMS_SHARED_POOL 09-Oct-2010
New DROP_EMPTY_SEGMENTS and MATERIALIZE_DEFERRED_SEGMENTS procedures DBMS_SPACE_ADMIN 18-Nov-2010
New REPORT_COL_USAGE function and RESET_COL_USAGE procedure DBMS_STATS 06-Jan-2011
New COMPARE_SQLSET_REPORT, REUSE_REPLAY_FILTER_SET and SET_REPLAY_TIMEOUT procedures DBMS_WORKLOAD_REPLAY 28-Sep-2010
New UPDATE_OBJECT_INFO procedure DBMS_WORKLOAD_REPOSITORY 06-Nov-2010
Many new functions and procedures DBMS_XDBUTIL_INT 09-Feb-2011
New ENABLE_GG_XSTREAM_FOR_STREAMS procedure and IS_GG_XSTREAM_FOR_STREAMS function DBMS_XSTREAM_ADM 19-Jan-2012
Many new procedures DBMS_XSTREAM_ADM_UTL 24-Feb-2011
New AUTH and STARTTLS procedures UTL_SMTP 08-Oct-2010
New SHOW_STATS_HTML procedure UTL_SPADV 18-Oct-2010
New SECURE_CONNECTION procedure UTL_TCP 27-Sep-2010
New WINDOWS32 procedure UTL_XML 27-Oct-2010
 
Built-in Packages with new Overloads
New DECLARE_REWRITE_EQUIVALENCE overload DBMS_ADVANCED_REWRITE 22-Sep-2010
New overload 3 for BMRSTART and NETWORKFILETRANSFER DBMS_BACKUP_RESTORE 30-Oct-2010
New overloads 5 and 6 for IMPORT_XML DBMS_CUBE 30-Oct-2010
New overload for NORMALIZEPATH procedure DBMS_DBFS_CONTENT 24-Nov-2010
New overloads for GET_ENCODED_PKGVARS_FOR_CLIENT, GET_ENCODED_STACK_FOR_CLIENT, GET_VALUE, PRINT_BACKTRACE, and SHOW_BREAKPOINTS DBMS_DEBUG 19-Nov-2010
New CREATE_EXTENDED_STATS overload DBMS_STATS 06-Jan-2011
New PREPARE_REPLAY overload and new parameters for the original procedure DBMS_WORKLOAD_REPLAY 28-Sep-2010
 
Built-in Packages with Parameters Changes
New CLEANUP parameter for the REGISTER procedure DBMS_ALERT 22-Sep-2010
MODULE and ACTION parameters increased in size to 64 bytes DBMS_APPLICATION_INFO 02-Dec-2010
New DESTQ parameter for RECOVER_PROPAGATION procedure DBMS_AQADM 29-Oct-2010
New START_TIME parameter for the ALTER_CAPTURE and CREATE_CAPTURE procedures DBMS_CAPTURE_ADM 28-Sep-2010
New parameters for the BUILD, BUILD_SLAVE, and REFRESH_MVIEW procedures DBMS_CUBE 30-Oct-2010
New UseEstimate parameter for the SPACEUSAGE procedure DBMS_DBFS_CONTENT 24-Nov-2010
New parameter for the TRANSLATEDATAFILECOPYTAG procedure DBMS_RCVMAN 23-Nov-2010
New CREATE_PLAN_DIRECTIVE and UPDATE_PLAN_DIRECTIVE parameters DBMS_RESOURCE_MANAGER 29-Nov-2010
New Edition Enabled services DBMS_SERVICE 30-Sep-2010
Many new parameters for multiple functions and procedures DBMS_SQLDIAG 17-Feb-2011
New ORDER BY PARAMETER for the REPORT_ANALYSIS_TASK function and REMOTE_PROCESS_SQL proc DBMS_SQLPA 17-Feb-2011
New STAT_CATEORY parameters for EXPORT... and IMPORT... procedures, new CONTEXT parameter for GATHER_TABLE_STATS DBMS_STATS 06-Jan-2011
New START_CAPTURE parameters DBMS_WORKLOAD_CAPTURE 28-Sep-2010
New SCHEMAOID and IMPORT_OPTIONS parameters in registerSchema overload 2 DBMS_XMLSCHEMA 20-Feb-2011
New ADD_OUTBOUND and ALTER_OUTBOUND default and parameters DBMS_XSTREAM_ADM 24-Feb-2011
New WALLET_PATH and WALLET_PASSWORD parameters in OPEN_CONNECTION UTL_SMTP 08-Oct-2010
New WALLET_PATH and WALLET_PASSWORD parameters in OPEN_CONNECTION UTL_TCP 27-Sep-2010
 
Built-in Packages with new Constants, Exceptions, Types, and other significant changes
New EXPORT_ERRQ_ERROR exception DBMS_APPLY_ADM 18-Nov-2010
New parameters for SET_PARAMETER in Oracle docs DBMS_CAPTURE_ADM 28-Sep-2010
New COMP_RATIO_MINROWS and COMP_RATIO_ALLROWS constants DBMS_COMPRESSION 02-Mar-2011
New transform controlling the segment creation clause DBMS_DATAPUMP 19-Nov-2010
Now runs with AUTHID CURRENT_USER DBMS_RECTIFIER_DIFF 18-Nov-2010
New 11.2.0.2 related constants DBMS_REGISTRY 08-Nov-2010
New STATUS_CORR constant DBMS_RESULT_CACHE 09-Oct-2010
New constants and exceptions DBMS_SERVICE 30-Sep-2010
New DEFAULT_STAT_CATEGORY constant DBMS_STATS 06-Jan-2011
New IS_ORACLE_FORMS constant UTL_IDENT 06-Oct-2010
 
Related Topics
New in 11.2.0.1
New in 11.2.0.3
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