| 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 |
