290/290

Index

A  B  C  D  E  F  G  H  I  J  K  L  M  N  O  P  Q  R  S  T  U  V  W  X 

---

A

ABORT procedure, 134

ABORT_GLOBAL_INSTANTIATION procedure, 34

ABORT_REDEF_TABLE procedure, 122

ABORT_SCHEMA_INSTANTIATION procedure, 34

ABORT_TABLE_INSTANTIATION procedure, 34

ABORTED_REQUEST_THRESHOLD procedure, 144

ACCEPT_SQL_PATCH Procedure, 152

ACCEPT_SQL_PLAN_BASELINE Procedure, 148

ACCEPT_SQL_PROFILE procedure, 154

ACLCHECKPRIVILEGES Function, 185

ACTIVE_INSTANCES Procedure, 174

ADD_CAPTURE Procedure, 178

ADD_COLORED_SQL Procedure, 179

ADD_COLUMN member procedure, 275

ADD_COLUMN procedure, 159, 204

ADD_COOKIES procedure, 252

ADD_FILE procedure, 68

ADD_FILTER Procedure, 177, 178

ADD_GLOBAL_PROPAGATION_RULES procedure, 159, 204

ADD_GLOBAL_RULES procedure, 159, 204

ADD_GROUPED_POLICY Procedure, 135

ADD_MESSAGE_PROPAGATION_RULE procedure, 159

ADD_MESSAGE_RULE procedure, 159

ADD_OUTBOUND procedure, 204

ADD_PAIR member procedure, 283

ADD_POLICY Procedure, 67, 121, 135, 171

ADD_POLICY_CONTEXT Procedure, 135

ADD_PRIVILEGE Procedure, 101

ADD_RULE procedure, 139

ADD_SCHEDULE_ORDERING Function, 178

ADD_SCHEMA_PROPAGATION_RULES procedure, 159, 204

ADD_SCHEMA_RULES procedure, 159, 204

ADD_SCHEME procedure, 96

ADD_SENSITIVE_COLUMN Procedure, 170

ADD_SENSITIVE_TYPE Procedure, 170

ADD_SQLSET_REFERENCE function, 154

ADD_SQLWKLD_REF Procedure, 19

ADD_SQLWKLD_STATEMENT Procedure, 19

ADD_STMT_HANDLER procedure, 23

ADD_STMT_TO_HANDLER procedure, 162

ADD_SUBSCRIBER Procedure, 97

ADD_SUBSET_OUTBOUND_RULES procedure, 204

ADD_SUBSET_PROPAGATION_RULES procedure, 159, 204

ADD_SUBSET_RULES procedure, 159, 204

ADD_TABLE_PROPAGATION_RULES procedure, 159, 204

ADD_TABLE_RULES procedure, 159, 204

ADD_TABLE_TO_APPLICATION Procedure, 71

ADD_TO_ILM Procedure, 79

ADD_WARNING_SETTING_CAT procedure, 175

ADD_WARNING_SETTING_NUM procedure, 175

ADD2MULTI procedure, 218

ADDATTR member procedure

of ANYTYPE TYPE, 270

ADDHTTPEXPIREMAPPING Procedure, 183

ADDINSTANCE member procedure

of ANYDATASET TYPE, 269

ADDMIMEMAPPING Procedure, 183

ADDREPOSITORYRESCONFIG Procedure, 130

ADDRESCONFIG Function, 130

ADDRESS function

of HTF package, 207

ADDRESS procedure

of HTP package, 208

ADDSCHEMALOCMAPPING Procedure, 183

ADDSERVLET Procedure, 183

ADDSERVLETMAPPING Procedure, 183

ADDSERVLETSECROLE Procedure, 183

ADDXDBNAMESPACE, 198

ADDXMLEXTENSION Procedure, 183

ADM_DROP_CHUNKS Procedure, 107

ADM_DROP_TASK Procedure, 107

ADM_GET_TASK_STATUS Procedure, 107

ADM_STOP_TASK Procedure, 107

ADMIN_TABLES procedure, 124

ADVISE_COMMIT procedure, 168

ADVISE_NOTHING procedure, 168

ADVISE_ROLLBACK procedure, 168

ADVISOR privilege, 42, 42

advisors

Oracle Streams, 160

aggregation management, 42

aggregation operators (OLAP), 42

ALLOCATE_UNIQUE procedure, 89

ALTER_AGENT Procedure, 97

ALTER_APPLY procedure, 23

ALTER_CAPTURE procedure, 34

ALTER_COMPILE procedure, 54

ALTER_EVALUATION_CONTEXT procedure, 139

ALTER_FILE procedure, 68

ALTER_FILE_GROUP procedure, 68

ALTER_GROUPED_POLICY Procedure, 135

ALTER_INBOUND procedure, 204

ALTER_JOB Procedure, 97

ALTER_MSGSYSTEM_LINK Procedure for TIB/Rendezvous, 97

ALTER_MSGSYSTEM_LINK Procedure for WebSphere MQ, 97

ALTER_OUTBOUND procedure, 204

ALTER_PARAM Procedure, 37

ALTER_POLICY Procedure, 121, 135, 171

ALTER_PROPAGATION procedure, 117

ALTER_PROPAGATION_SCHEDULE Procedure, 97

ALTER_REWRITE_EQUIVALENCE Procedure, 18

ALTER_RULE procedure, 139

ALTER_SENSITIVE_COLUMN Procedure, 170

ALTER_SQL_PATCH Procedure, 152

ALTER_SQL_PLAN_BASELINE Function, 148

ALTER_SQL_PLAN_DIRECTIVE Procedure, 147

ALTER_SQL_PROFILE procedure, 154

ALTER_STATS_HISTORY_RETENTION procedure, 155

ALTER_SUBSCRIBER Procedure, 97

ALTER_SYNC_CAPTURE procedure, 34

ALTER_TABLE_NOT_REFERENCEABLE procedure, 54

ALTER_TABLE_REFERENCEABLE procedure, 54

ALTER_VERSION procedure, 68

AMATCH function, 216

ANALYZE Function, 76

ANALYZE Procedure, 33

ANALYZE_CURRENT_PERFORMANCE procedure, 160

ANALYZE_DATABASE Procedure, 174

ANALYZE_DB Procedure, 17

ANALYZE_INST Procedure, 17

ANALYZE_PART_OBJECT Procedure, 174

ANALYZE_PARTIAL Procedure, 17

ANALYZE_SCHEMA Procedure, 174

ANCHOR function

of HTF package, 207

ANCHOR procedure

of HTP package, 208

ANCHOR2 function

of HTF package, 207

ANCHOR2 procedure

of HTP package, 208

anonymous PL/SQL blocks

dynamic SQL and, 149

AnyData datatype

queues

creating, 159, 204

removing, 159, 204

ANYDATA TYPE, 268

ANYDATASET TYPE, 269

ANYTYPE TYPE, 270

APEX_APPLICATION package, 3

APEX_APPLICATION package documentation, 3

APEX_CUSTOM_AUTH package, 2

APEX_CUSTOM_AUTH package documentation, 2

APEX_ITEM package, 4

APEX_ITEM package documentation, 4

APEX_UTIL package, 5

APPEND Procedures, 88

APPEND_HOST_ACE Procedure, 101

APPEND_HOST_ACL Procedure, 101

APPEND_WALLET_ACE Procedure, 101

APPEND_WALLET_ACL Procedure, 101

APPENDCHILD function, 191

APPENDDATA procedure, 191

APPENDRESCONFIG Procedure, 130

APPENDRESOURCEMETADATA Procedure, 185

APPLETCLOSE function

of HTF package, 207

APPLETCLOSE procedure

of HTP package, 208

APPLETOPEN function

of HTF package, 207

APPLETOPEN procedure

of HTP package, 208

apply process

altering, 23

apply user, 159

change handlers

setting, 23

conflict handlers

setting, 23

creating, 23, 159, 159, 159, 159, 159, 204, 204, 204, 204

DBMS_APPLY_ADM package, 23

DDL handler

setting, 23, 23

dropping, 23

enqueuing events, 23

error handlers

setting, 23

error queue

deleting errors, 23, 23

executing errors, 23, 23

getting error messages, 23

instantiation

global SCN, 23

schema SCN, 23

table SCN, 23

message handler

setting, 23, 23

parameters

allow_duplicate_rows, 23, 34, 34

apply_sequence_nextval, 23

commit_serialization, 23

compare_key_only, 23

compute_lcr_dep_on_arrival, 23

disable_on_error, 23

disable_on_limit, 23

eager_size, 23

enable_xstream_table_stats, 23

grouptransops, 23

handle_collisions, 23

ignore_transaction, 23

max_parallelism, 23

max_sga_size, 23

maximum_scn, 23

optimize_progress_table, 23

optimize_self_updates, 23

parallelism, 23

parallelism_interval, 23

preserve_encryption, 23

rtrim_on_implicit_conversion, 23

setting, 23

startup_seconds, 23

suppresstriggers, 23

time_limit, 23

trace_level, 23

transaction_limit, 23

txn_age_spill_threshold, 23

txn_lcr_spill_threshold, 23

precommit handler

setting, 23, 23

procedure DML handlers

setting, 23

rules

defining global, 159, 204

defining message, 159

defining schema, 159, 204

defining subset, 159, 204

defining table, 159, 204

for LCRs, 159

for user messages, 159

removing, 159, 204

specifying execution, 23

starting, 23

statement DML handlers

setting, 23, 23

stopping, 23

substitute key columns

setting, 23

apply user

DBMS_STREAMS_ADM package, 159

APPLY$_ENQUEUE, 23

APPLY$_EXECUTE, 23

AQ$_AGENT Type, 271

AQ$_AGENT_LIST_T Type, 271

AQ$_DESCRIPTOR Type, 271, 271

AQ$_NTFN_MSGID_ARRAY Type, 271

AQ$_POST_INFO Type, 271

AQ$_POST_INFO_LIST Type, 271

AQ$_PURGE_OPTIONS_T Type, 271

AQ$_RECIPIENT_LIST_T Type, 271

AQ$_REG_INFO Type, 271

AQ$_REG_INFO_LIST Type, 271

AQ$_SUBSCRIBER_LIST_T Type, 271

ARCHIVESTATENAME Function, 79

AREA function

of HTF package, 207

AREA procedure

of HTP package, 208

arrays

BIND_ARRAY procedure, 149

bulk DML using DBMS_SQL, 149

ASA_RECO_ROW Record Type, 145

ASA_RECO_ROW_TB Table Type, 145

ASA_RECOMMENDATIONS Function, 145

ASH_GLOBAL_REPORT_HTML Function, 179

ASH_GLOBAL_REPORT_TEXT Function, 179

ASH_REPORT_HTML Function, 179

ASH_REPORT_TEXT Function, 179

ASSIGN_ACL Procedure, 101

ASSIGN_WALLET_ACL Procedure, 101

ASSM_SEGMENT_VERIFY Procedure, 146

ASSM_TABLESPACE_VERIFY Procedure, 146

ASSOCIATE_POLICY Procedure, 171

ATTACH_SESSION procedure, 53

ATTACH_SIMPLE_TABLESPACE procedure, 164

ATTACH_TABLESPACES procedure, 164

AUTH Function and Procedure, 263

AUTHORIZE function, 213

AUTHORIZE_DAD Procedure, 65

AVAILABLE function, 265

AWR_BASELINE_METRIC_TYPE Object Type, 179

AWR_BASELINE_METRIC_TYPE_TABLE Table Type, 179

AWR_DIFF_REPORT_HTML Function, 179

AWR_DIFF_REPORT_TEXT Function, 179

AWR_GLOBAL_DIFF_REPORT_HTML Functions, 179

AWR_GLOBAL_DIFF_REPORT_TEXT Functions, 179, 179

AWR_GLOBAL_REPORT_HTML Functions, 179

AWR_GLOBAL_REPORT_TEXT Functions, 179

AWR_REPORT_HTML function, 179

AWR_REPORT_TEXT function, 179

AWR_SET_REPORT_THRESHOLDS Procedure, 179

AWR_SQL_REPORT_HTML Function, 179

AWR_SQL_REPORT_TEXT Function, 179

---

B

BACKTRACE_DEPTH Function, 247

BACKTRACE_LINE Function, 247

BACKTRACE_UNIT Function, 247

BASE function

of HTF package, 207

BASE procedure

of HTP package, 208

BASE64_DECODE function, 250

BASE64_ENCODE function, 250

BASEFONT function

of HTF package, 207

BASEFONT procedure

of HTP package, 208

BEGIN_OPERATION Function, 151

BEGIN_PREPARE Procedure, 62

BEGIN_REPLAY_SCHEDULE Procedure, 178

BEGIN_REQUEST function, 252

BEGIN_SQL_BLOCK Procedure, 131

BEGIN_UPGRADE Procedure, 62

BEGINCREATE static procedure

of ANYDATA TYPE, 268

of ANYDATASET TYPE, 269

of ANYTYPE TYPE, 270

BFILE_TABLE Table Type, 149

BGSOUND function

of HTF package, 207

BGSOUND procedure

of HTP package, 208

BIG function

of HTF package, 207

BIG procedure

of HTP package, 208

BINARY_DOUBLE_TABLE Table Type, 149

BINARY_FLOAT_TABLE Table Type, 149

BIND_ARRAY procedures, 149

BIND_INOUT_VARIABLE Procedure, 78

BIND_INOUT_VARIABLE_RAW Procedure, 78

BIND_OUT_VARIABLE Procedure, 78

BIND_OUT_VARIABLE_RAW Procedure, 78

BIND_VARIABLE Procedure, 78

BIND_VARIABLE procedures, 149

BIND_VARIABLE_RAW Procedure, 78

BIND_VARIABLES function, 219

BIT_AND function, 260

BIT_COMPLEMENT function, 260

BIT_OR function, 260

BIT_XOR function, 260

BLAS Level 1 (Vector-Vector Operations) Subprograms, 259

BLAS Level 2 (Matrix-Vector Operations) Subprograms, 259

BLAS Level 3 (Matrix-Matrix Operations) Subprograms, 259

BLAS_ASUM Functions, 259

BLAS_AXPY Procedures, 259

BLAS_COPY Procedures, 259

BLAS_DOT Functions, 259

BLAS_GBMV Procedures, 259

BLAS_GEMM Procedures, 259

BLAS_GEMV Procedures, 259

BLAS_GER Procedures, 259

BLAS_IAMAX Functions, 259

BLAS_NRM2 Functions, 259

BLAS_ROT Procedures, 259

BLAS_ROTG Procedures, 259

BLAS_SBMV Procedures, 259

BLAS_SCAL Procedure, 259

BLAS_SPMV Procedures, 259

BLAS_SPR Procedures, 259

BLAS_SPR2 Procedures, 259

BLAS_SWAP Procedure, 259

BLAS_SYMM Procedures, 259

BLAS_SYMV Procedures, 259

BLAS_SYR Procedures, 259

BLAS_SYR2 Procedures, 259

BLAS_SYRK Procedures, 259

BLAS_TBMV Procedures, 259

BLAS_TBSV Procedures, 259

BLAS_TPMV Procedures, 259

BLAS_TPSV Procedures, 259

BLAS_TRMM Procedures, 259

BLAS_TRMV Procedures, 259

BLAS_TRSM Procedures, 259

BLAS_TRSV Procedures, 259

BLOB_TABLE Table Type, 149

BLOCK_HEAT_MAP Function, 74

BLOCKQUOTECLOSE function

of HTF package, 207

BLOCKQUOTECLOSE procedure

of HTP package, 208, 208

BLOCKQUOTEOPEN function

of HTF package, 207

BLOCKQUOTEOPEN procedure

of HTP package, 208

BODYCLOSE function

of HTF package, 207

BODYCLOSE procedure

of HTP package, 208

BODYOPEN function

of HTF package, 207

BODYOPEN procedure

of HTP package, 208

BOLD function

of HTF package, 207

BOLD procedure

of HTP package, 208

BR function

of HTF package, 207

BR procedure

of HTP package, 208

BREAKPOINT_INFO Record Type, 53

BROKEN procedure, 84

BUILD procedure, 34, 42

BUILD_CHAIN_ROWS_TABLE procedure, 82

BUILD_EXCEPTIONS_TABLE procedure, 82

BUILD_PART_INDEX procedure, 109

BUILD_SAFE_REWRITE_EQUIVALENCE Procedure, 18

BYPASS Procedure, 133

---

C

CALENDARPRINT procedures, 219

CALIBRATE Function, 178

CALIBRATE_IO Procedure, 131

CAN_REDEF_TABLE procedure, 122

CANCEL_ANALYSIS_TASK Procedure, 153

CANCEL_DIAGNOSIS_TASK Procedure, 152

CANCEL_EVOLVE_TASK Procedure, 148

CANCEL_REPLAY Procedure, 178

CANCEL_TASK Procedure, 19

CANCEL_TUNING_TASK procedure, 154

CANONICALIZE Procedure, 174

capture process

altering, 34

building a Streams data dictionary, 34

capture user, 159

creating, 159, 159, 159, 159, 204, 204, 204, 204

DBMS_CAPTURE_ADM package, 34

instantiation

aborting database preparation, 34

aborting schema preparation, 34

aborting table preparation, 34

preparing a database for, 34

preparing a schema for, 34

preparing a table for, 34

parameters

disable_on_limit, 34

downstream_real_time_mine, 34

excludetag, 23, 34

excludetrans, 23, 34

excludeuser, 23, 34

excludeuserid, 23, 34

getapplops, 23, 34

ignore_transaction, 34

ignore_unsupported_table, 34

include_objects, 34

max_sga_size, 34

maximum_scn, 34

merge_threshold, 34

message_limit, 34

message_tracking_frequency, 34

parallelism, 34

setting, 34

skip_autofiltered_table_ddl, 34

startup_seconds, 34

time_limit, 34

trace_level, 34

write_alert_log, 34, 34

xout_client_exists, 34

rules, 159

defining global, 159, 204

defining schema, 159, 204

defining subset, 159, 204

defining table, 159, 204

removing, 159, 204

starting, 34

stopping, 34

CAPTURE_CURSOR_CACHE_SQLSET Procedure, 154

CAST_FROM_BINARY_DOUBLE function, 260

CAST_FROM_BINARY_FLOAT function, 260

CAST_FROM_BINARY_INTEGER function, 260

CAST_FROM_NUMBER function, 260

CAST_TO_BINARY_DOUBLE function, 260

CAST_TO_BINARY_FLOAT function, 260

CAST_TO_BINARY_INTEGER function, 260

CAST_TO_NUMBER function, 260

CAST_TO_NVARCHAR2 function, 260

CAST_TO_RAW function, 260

CAST_TO_VARCHAR2 function, 260

CB$ table prefix, 42

CELLSPRINT procedures, 219

CENTER function

of HTF package, 207

CENTER procedure

of HTP package, 208

CENTERCLOSE function

of HTF package, 207

CENTERCLOSE procedure

of HTP package, 208

CENTEROPEN function

of HTF package, 207

CENTEROPEN procedure

of HTP package, 208

CFG_GET Function, 183

CFG_REFRESH Procedure, 183

CFG_UPDATE Procedure, 183

change data capture

Oracle Streams

configuring, 159

CHANGE functions and procedures, 216

CHANGE procedure, 84

CHANGEOWNER Procedure, 185

CHANGEPRIVILEGES Function, 185

CHARARR Table Type, 106

CHECK_OBJECT procedure, 124

CHECK_PLUG_COMPATIBILITY Function, 110

CHECK_PRIVILEGE Function, 101

CHECK_PRIVILEGE_ACLID Function, 101

CHECKACCESS Function, 48, 49

CHECKIN function, 186

CHECKOUT procedure, 186

CHECKPRIVILEGES Function, 185

CHECKSPI Functions and Procedures, 48

CHECKSUM functions, 215

CHOOSE_DATE procedure, 219

CITE function

of HTF package, 207

CITE procedure

of HTP package, 208

CLEAN_AUDIT_TRAIL procedure, 29

CLEANUP_GATEWAY Procedure, 97

CLEANUP_GIDX Procedure, 108

CLEANUP_INSTANTIATION_SETUP procedure, 159

CLEANUP_ONLINE_OP Procedure, 108

CLEANUPUNUSEDBACKUPFILES Procedure, 50

CLEAR Procedure, 190

CLEAR_ALL_CONTEXT Procedure, 143

CLEAR_AUDIT_TRAIL_PROPERTY procedure, 29

CLEAR_CONTEXT Procedure, 143

CLEAR_COOKIES procedure, 252

CLEAR_HEAT_MAP_ALL Procedur, 80

CLEAR_HEAT_MAP_TABLE Procedure, 80

CLEAR_IDENTIFIER Procedure, 143

CLEAR_LAST_ARCHIVE_TIMESTAMP procedure, 29

CLEAR_PENDING_AREA procedure, 131

CLEAR_PLSQL_TRACE procedure, 167

CLEAR_USED procedure, 105

CLEARKEYCOLUMNLIST procedure, 196, 200

CLEARUPDATECOLUMNLIST procedure, 196, 200

CLIENT_ID_STAT_DISABLE procedure, 99

CLIENT_ID_STAT_ENABLE procedure, 99

CLIENT_ID_TRACE_DISABLE procedure, 99

CLIENT_ID_TRACE_ENABLE procedure, 99

CLOB_TABLE Table Type, 149

CLOB2FILE procedure, 203

CLONE_SIMPLE_TABLESPACE procedure, 164

CLONE_TABLESPACES procedure, 164

CLONEDB_RENAMEFILE Procedure, 61

CLONENODE function, 191

CLOSE Procedure, 88

CLOSE_ALL_CONNECTIONS procedure, 265

CLOSE_CONNECTION procedure, 265

CLOSE_CONNECTION Procedure, 263

CLOSE_CURSOR procedure, 149

CLOSE_CURSOR Procedure, 78

CLOSE_DATA Function and Procedure, 263

CLOSE_DATABASE_LINK Procedure, 143

CLOSE_ITERATOR procedure, 138

CLOSE_PERSISTENT_CONN procedure, 252

CLOSE_PERSISTENT_CONNS procedure, 252

CLOSECONTEXT procedure, 192, 195, 196, 200

COAD_ADVICE_REC type, 43

COAD_ADVICE_T type, 43

CODE function

of HTF package, 207

CODE procedure

of HTP package, 208

COLLECT_STATS procedure, 264

collections

table items, 149

COLUMN_VALUE procedure, 149

COLUMN_VALUE_LONG procedure, 149

COMMA_TO_TABLE Procedures, 174

COMMAND function and procedure, 263

COMMAND_REPLIES function, 263

COMMENT function

of HTF package, 207

COMMENT procedure

of HTP package, 208

COMMIT procedure, 168

COMMIT_COMMENT procedure, 168

COMMIT_FORCE procedure, 168

COMPARE function, 260

COMPARE Function, 35

COMPARE Functions, 88

COMPARE_CAPTURE_REPLAY_REPORT Function, 17

COMPARE_DATABASES Function, 17

COMPARE_INSTANCES Function, 17

COMPARE_OLD_VALUES procedure, 23

COMPARE_PERIOD_REPORT Procedure, 178

COMPARE_REPLAY_REPLAY_REPORT Function, 17

COMPARE_SQLSET_REPORT Function, 178

COMPARISON_TYPE type, 35

COMPATIBLE_10_1 function, 158, 275

COMPATIBLE_10_2 function, 158, 275

COMPATIBLE_11_1 function, 158

COMPATIBLE_11_2 function, 158

COMPATIBLE_12_1 function, 158

COMPATIBLE_9_2 function, 158, 275

COMPILE_FROM_REMOTE procedure, 87

COMPILE_SCHEMA Procedure, 174

COMPILESCHEMA procedure, 197

CONCAT function, 260

CONCATENATE_SUBPROGRAM Function, 247

CONFIGURE Procedure, 148

CONFIGURE_POOL Procedure, 37

CONFIGUREAUTOSYNC procedure, 188

conflicts

detection

stopping, 23

CONNECTION record type, 263

constants

DBMS_MGWMSG package, 98

CONTAINS_HOST Function, 102

CONTINUE function, 53

CONVERGE Procedure, 35

CONVERT function, 89, 192, 260

CONVERT_ANYDATA_TO_LCR_DDL function, 158

CONVERT_ANYDATA_TO_LCR_ROW function, 158

CONVERT_LCR_TO_XML function, 158

CONVERT_LONG_TO_LOB_CHUNK member procedure, 275

CONVERT_RAW_VALUE procedures, 155

CONVERT_RAW_VALUE_NVARCHAR procedure, 155

CONVERT_RAW_VALUE_ROWID procedure, 155

CONVERT_XML_TO_LCR function, 158

CONVERTTOBLOB procedure, 88

CONVERTTOCLOB Procedure, 88

COPIES function, 260

COPY Procedures, 88

COPY_DBFS_LINK Procedures, 88

COPY_FILE procedure, 69

COPY_FROM_DBFS_LINK, 88

COPY_TABLE_DEPENDENTS procedure, 122

COPY_TABLE_STATS Procedure, 155

COPYEVOLVE procedure, 197

CQ_NOTIFICATION$_DESCRIPTOR Object Type, 38

CQ_NOTIFICATION$_QUERY Object Type, 38

CQ_NOTIFICATION$_QUERY_ARRAY Object (Array) Type, 38

CQ_NOTIFICATION$_REG_INFO Object Type, 38

CQ_NOTIFICATION$_ROW Object Type, 38

CQ_NOTIFICATION$_TABLE Object Type, 38

CQ_NOTIFICATION$_TABLE_ARRAY Object (Array) Type, 38

CQ_NOTIFICATION_QUERYID Function, 38

CREATE ANY DIMENSION privilege, 42

CREATE ANY MATERIALIZED VIEW privilege, 42

CREATE DIMENSION privilege, 42

CREATE MATERIALIZED VIEW privilege, 42

CREATE PACKAGE BODY command, 1

CREATE PACKAGE command, 1

CREATE SESSION privilege, 42, 42

CREATE_ACL Procedure, 101

CREATE_AFFECTED_TABLE Procedure, 62

CREATE_AGENT Procedure, 97

CREATE_ALTER_TYPE_ERROR_TABLE Procedure, 174

CREATE_ANALYSIS_TASK Functions, 153

CREATE_APPLY procedure, 23

CREATE_BASELINE Function & Procedure, 179

CREATE_BASELINE_TEMPLATE Procedures, 179

CREATE_BIN_CAT procedure, 46

CREATE_BIN_NUM procedure, 46

CREATE_CAPTURE procedure

capture process

creating, 34

CREATE_CAPTURE Procedure, 115

CREATE_CATEGORY function, 96

CREATE_CATEGORY Procedure, 131

CREATE_CDB_PLAN Procedure, 131

CREATE_CDB_PLAN_DIRECTIVE Procedure, 131

CREATE_CHUNKS_BY_NUMBER_COL Procedure, 107

CREATE_CHUNKS_BY_ROWID Procedure, 107

CREATE_CHUNKS_BY_SQL Procedure, 107

CREATE_CLIP procedure, 46

CREATE_COL_REM procedure, 46

CREATE_COMPARISON Procedure, 35

CREATE_CONSUMER_GROUP procedure, 131

CREATE_CREDENTIAL Procedure, 39

CREATE_DAD Procedure, 65

CREATE_DIAGNOSIS_TASK Functions, 152

CREATE_ERROR_LOG Procedure, 66

CREATE_ERROR_TABLE Procedure, 62

CREATE_EVALUATION_CONTEXT procedure, 139

CREATE_EVOLVE_TASK Function, 148

CREATE_EXTENDED_STATS Function, 155

CREATE_FILE Procedure, 19

CREATE_FILE_GROUP procedure, 68

CREATE_FILTER_SET Procedure, 178

CREATE_INBOUND procedure, 204

CREATE_INDEX_COST procedure, 145

CREATE_JOB Procedure, 97

CREATE_MISS_CAT procedure, 46

CREATE_MISS_NUM procedure, 46

CREATE_MSGSYSTEM_LINK Procedure for TIB/Rendezvous, 97

CREATE_MSGSYSTEM_LINK Procedure for WebSphere MQ, 97

CREATE_MVIEW function, 42, 42

CREATE_NORM_LIN procedure, 46

CREATE_OBJECT Procedure, 19

CREATE_OBJECT_DEPENDENCY procedure, 23

CREATE_OR_REPLACE_VIEW procedure

of DBMS_HS_PARALLEL package, 77

CREATE_OUTBOUND procedure, 204

CREATE_OUTLINE procedure, 105

CREATE_PENDING_AREA procedure, 131

CREATE_PIPE function, 112

CREATE_PLAN procedure, 131

CREATE_PLAN_DIRECTIVE procedure, 131

CREATE_POLICY_GROUP Procedure, 135

CREATE_PROFILE Procedure, 150

CREATE_PROPAGATION procedure, 117

CREATE_PURGE_JOB procedure, 29

CREATE_REQUEST_CONTEXT Function, 252

CREATE_RULE procedure, 139

CREATE_RULE_SET procedure, 139

CREATE_SERVICE procedure, 142

CREATE_SIMPLE_PLAN procedure, 131

CREATE_SNAPSHOT function and procedure, 179

CREATE_SQL_PLAN_BASELINE Procedure, 154

CREATE_SQLSET procedure, 154

CREATE_SQLWKLD Procedure, 19

CREATE_STAT_TABLE procedure, 155

CREATE_STGTAB_BASELINE Procedure, 148

CREATE_STGTAB_DIRECTIVE Procedure, 147

CREATE_STGTAB_SQLPATCH Procedure, 152

CREATE_STGTAB_SQLPROF Procedure, 154

CREATE_STGTAB_SQLSET Procedure, 154

CREATE_STMT_HANDLER procedure, 162

CREATE_SYNC_CAPTURE procedure

synchronous capture

creating, 34

CREATE_TABLE_COST procedures, 145

CREATE_TABLE_COST_COLINFO Object Type, 145

CREATE_TABLE_TEMPLAGE procedure

of DBMS_HS_PARALLEL package, 77

CREATE_TASK Procedure, 107

CREATE_TASK Procedures, 19

CREATE_TEMP_HISTORY_TABLE Procedure, 71

CREATE_TRANSFORMATION procedure, 169

CREATE_TRIGGER_TABLE Procedure, 62

CREATE_TUNING_TASK functions, 154

CREATE_VERSION procedure, 68

CREATE_WRAPPED Procedure, 54

CREATEATTRIBUTE function, 191

CREATEBUCKET Procedure, 50

CREATECDATASECTION function, 191

CREATECOMMENT function, 191

CREATEDATASTOREPREF procedure, 188

CREATEDATEINDEX Procedure, 193

CREATEDIRECTORY Procedures, 48, 49

CREATEDOCUMENT function, 191

CREATEDOCUMENTFRAGMENT function, 191

CREATEELEMENT function, 191

CREATEENTITYREFERENCE function, 191

CREATEFILE Procedures, 48, 49

CREATEFILESYSTEM Procedure, 51

CREATEFILTERPREF procedure, 188

CREATEFOLDER Function, 185

CREATEINDEX procedure, 188

CREATELEXERPREF procedure, 188

CREATELINK Procedures, 48, 49

CREATENONCEKEY Procedure, 182, 189

CREATENONSCHEMABASEDXML function, 285

CREATENUMBERINDEX Procedure, 193

CREATEOIDPATH Function, 185

CREATEPREFERENCES procedure, 188

CREATEPROCESSINGINSTRUCTION function, 191

CREATEREFERENCE Procedures, 48, 49

CREATEREPOSITORYXMLINDEX Procedure, 182

CREATERESOURCE Functions, 185

CREATESCHEMABASEDXML function, 285

CREATESECTIONGROUPPREF procedure, 188

CREATESTOPLISTPREF procedure, 188

CREATESTORAGEPREF procedure, 188

CREATESTORE Procedure, 50, 51

CREATETEMPORARY Procedures, 88

CREATETEXTNODE function, 191

CREATEURI function, 273, 273, 273

CREATEWORLDLISTPREF procedure, 188

CREATEXML function, 285

creating

packages, 1

CTX_ADM package, 6

CTX_ADM package documentation, 6

CTX_ANL package, 7

CTX_ANL package documentation, 7

CTX_CLS package, 8

CTX_CLS package documentation, 8

CTX_DDL package, 9

CTX_DDL package documentation, 9

CTX_DOC package documentation, 10

CTX_ENTITY package, 11

CTX_ENTITY package documentation, 11

CTX_OUTPUT package documentation, 12

CTX_QUERY package documentation, 13

CTX_REPORT package documentation, 14

CTX_THES package documentation, 15

CTX_ULEXER package documentation, 16

cube aggregation, 42

Cube Build log, 44

Cube Dimension Compile log, 44

cube log verbosity levels, 44

cube logging targets, 44

cube logging types, 44

cube maintenance, 42

cube materialized views, 42

optimizing, 43

Cube Operations log, 44

cube refresh, 42

Cube Rejected Records Log, 44

CUBE_BUILD_LATEST view, 42

CUBE_BUILD_REPORT view, 42

CUBE_BUILD_REPORT_LATEST view, 42

CUBE_UPGRADE_INFO table, 42

cubes

optimizer statistics, 33

CURRENT_EDITION Function, 247

CURRENT_INSTANCE Function, 174

cursors

DBMS_SQL package, 149

CUSTOMIZE_ILM Procedure, 80

---

D

data dictionary

removing Streams information, 159

removing XStream information, 204

DATA function and procedure, 263

data mining

algorithms, 45

anomaly detection, 45

association rules, 45

attribute importance, 45

automated, 113

Automatic Data Preparation, 45

classification, 45

clustering, 45, 45

confusion matrix, 45

cost matrix, 45

creating a model, 45

data transformation, 45, 45, 45, 45

feature extraction, 45

lift, 45

mining functions, 45

PMML, 45

regression, 45, 45

ROC, 45

scoring, 45, 45

supervised, 45

transactional data, 45

transformations, 46

unsupervised, 45

DATA_BLOCK_ADDRESS_BLOCK Function, 174

DATA_BLOCK_ADDRESS_FILE Function, 174

database

locking

OWA_OPT_LOCK package, 215

database tables

creating for DBMS_TRACE, 167

DATABASE_TRACE_DISABLE Procedure, 99

DATABASE_TRACE_ENABLE Procedure, 99

datatypes

DBMS_DESCRIBE, 58

PL/SQL

numeric codes for, 58

DATE_TABLE Table Type, 149

DB_CONNECT_INFO Procedure, 97

DB_VERSION Procedure, 174

DBFS_LINK_GENERATE_PATH Functions, 88

DBLINK_ARRAY Table Type, 174

DBMS, 191

DBMS_ NETWORK_ACL_ADMIN package, 101, 102

DBMS_ALERT package, 20

DBMS_APPLICATION_INFO package, 22

DBMS_APPLY_ADM package, 23

DBMS_AQADM Constants, 25

DBMS_AQELM package, 26

DBMS_AQIN package, 27

DBMS_AUDIT_MGMT package, 29

CLEAN_AUDIT_TRAIL procedure, 29

CLEAR_AUDIT_TRAIL_PROPERTY procedure, 29

CLEAR_LAST_ARCHIVE_TIMESTAMP procedure, 29

CREATE_PURGE_JOB procedure, 29

DEINIT_CLEANUP procedure, 29

DROP_PURGE_JOB procedure, 29

GET_AUDIT_COMMIT_DELAY function, 29

INIT_CLEANUP procedure, 29

IS_CLEANUP_INITIALIZED function, 29

SET_AUDIT_TRAIL_LOCATION procedure, 29

SET_AUDIT_TRAIL_PROPERTY procedure, 29

SET_LAST_ARCHIVE_TIMESTAMP procedure, 29

SET_PURGE_JOB_INTERVAL procedure, 29

SET_PURGE_JOB_STATUS procedure, 29

DBMS_AUTO_TASK_ADMIN package, 32

DBMS_AW_STATS package, 33

DBMS_CAPTURE package, 271

DBMS_CAPTURE_ADM package, 34

DBMS_CHANGE_NOTIFICATION package, 38

DBMS_COMPARISON package, 35

constants, 35

data structures, 35

index columns, 35

lead index column, 35

requirements, 35

subprograms, 35

using, 35

views, 35

DBMS_CONNECTION_POOL package, 37

DBMS_CONTENT_CONTEXT_T Object Type, 272

DBMS_CSX_ADMIN package, 41

DBMS_CUBE package, 42

DBMS_CUBE_ADVISE package, 43

DBMS_CUBE_LOG package, 44

DBMS_DATA_MINING package, 45

ADD_COST_MATRIX procedure, 45

algorithms, 45

ALTER_REVERSE_EXPRESSION procedure, 45

APPLY procedure, 45

Automatic Data Preparation, 45

COMPUTE_CONFUSION_MATRIX procedure, 45

COMPUTE_LIFT procedure, 45

COMPUTE_ROC procedure, 45

CREATE_MODEL procedure, 45

data transformation, 45, 45, 45

datatypes, 45

DROP_MODEL procedure, 45

EXPORT_MODEL procedure, 45

GET_ASSOCIATION_RULES function, 45

GET_FREQUENT_ITEMSETS function, 45

GET_MODEL_COST_MATRIX function, 45

GET_MODEL_DETAILS_AI function, 45

GET_MODEL_DETAILS_EM function, 45

GET_MODEL_DETAILS_EM_COMP function, 45

GET_MODEL_DETAILS_EM_PROJ function, 45

GET_MODEL_DETAILS_GLM function, 45

GET_MODEL_DETAILS_GLOBAL function, 45

GET_MODEL_DETAILS_KM function, 45

GET_MODEL_DETAILS_NB function, 45

GET_MODEL_DETAILS_NMF function, 45

GET_MODEL_DETAILS_OC function, 45

GET_MODEL_DETAILS_SVM function, 45, 45

GET_MODEL_DETAILS_XML function, 45

GET_MODEL_TRANSFORMATIONS function, 45

GET_TRANSFORM_LIST procedure, 45

IMPORT_MODEL procedure, 45

overview, 45

PMML, 45

RANK_APPLY procedure, 45

REMOVE_COST_MATRIX procedure, 45

RENAME_MODEL procedure, 45

scoring, 45, 45, 45, 45, 45

security model, 45

settings

algorithm names, 45

decision tree, 45

GLM, 45

global, 45

k-Means, 45

mining functions, 45

mining models, 45

Naive Bayes, 45

NMF, 45

O-Cluster, 45

SVM, 45

subprograms, 45

transactional data, 45

DBMS_DATA_MINING_TRANSFORM

datatypes, 46

introduction, 46

package, 46

subprograms, 46

DBMS_DATAPUMP package, 47

ADD_FILE procedure, 47

ATTACH function, 47

DATA_FILTER procedure, 47

DETACH procedure, 47

GET_DUMPFILE_INFO procedure, 47

GET_STATUS procedure, 47

LOG_ENTRY procedure, 47

METADATA_FILTER procedure, 47

METADATA_REMAP procedure, 47

METADATA_TRANSFORM procedure, 47

OPEN function, 47

roles used by, 47

SET_PARALLEL procedure, 47

SET_PARAMETER procedure, 47

START_JOB procedure, 47

STOP_JOB procedure, 47

types used by, 47

WAIT_FOR_JOB procedure, 47

DBMS_DB_VERSION package, 52

DBMS_DBFS_CONTENT package, 48

DBMS_DBFS_CONTENT_LIST_ITEM_T Object Type, 272

DBMS_DBFS_CONTENT_LIST_ITEMS_T Table Type, 272

DBMS_DBFS_CONTENT_PROPERTIES_T Table Type, 272

DBMS_DBFS_CONTENT_PROPERTY_T Object Type, 272

DBMS_DBFS_CONTENT_RAW_T Table Type, 272

DBMS_DBFS_CONTENT_SPI package, 49

DBMS_DBFS_HS package, 50

DBMS_DBFS_SFS package, 51

DBMS_DDL package, 54

DBMS_DEBUG package, 53

DBMS_DEFER package documentation, 55

DBMS_DEFER_QUERY package documentation, 56

DBMS_DEFER_SYS package documentation, 57

DBMS_DESCRIBE package, 58

DBMS_DG package, 59

using, 59

DBMS_DG Package

INITIATE_FS_FAILOVER procedure, 59

DBMS_DIMENSION package, 60

DBMS_DISTRIBUTED_TRUST_ADMIN package, 63

DBMS_EDITIONS_UTILITIES package, 64, 64

DBMS_EPG package, 65, 65

DBMS_FGA package, 67

DBMS_FILE_GROUP package, 68

constants, 68

DBMS_FILE_TRANSFER package, 69

DBMS_FLASHBACK package, 70

DBMS_FREQUENT_ITEMSET package, 73

DBMS_GOLDENGATE_AUTH package, 72

DBMS_HPROF package, 76

DBMS_HS_PARALLEL package, 77

CREATE_OR_REPLACE_VIEW procedure, 77

CREATE_TABLE_TEMPLATE procedure, 77

DROP_VIEW procedure, 77

LOAD_TABLE procedure, 77

DBMS_HS_PASSTHROUGH package, 78

DBMS_IOT package, 82

DBMS_JAVA package documentation, 83

DBMS_JOB package, 84

DBMS_LDAP package documentation, 85

DBMS_LDAP_UTL package documentation, 86

DBMS_LIBCACHE package, 87

DBMS_LOB package, 88

DBMS_LOCK package, 89

DBMS_LOGMNR package, 90

ADD_LOGFILE procedure, 90

COLUMN_PRESENT function, 90

END_LOGMNR procedure, 90

MINE_VALUE function, 90

REMOVE_LOGFILE procedure, 90

START_LOGMNR procedure, 90

DBMS_LOGMNR_D package, 91

BUILD procedure, 91

SET_TABLESPACE procedure, 91

DBMS_LOGSTDBY package, 92

APPLY_SET procedure, 92

APPLY_UNSET procedure, 92

BUILD procedure, 92

INSTANTIATE_TABLE procedure, 92

MAP_PRIMARY_SCN function, 92

overview of managing SQL Apply, 92

PREPARE_FOR_NEW_PRIMARY procedure, 92

PURGE_SESSION procedure, 92

SET_TABLESPACE procedure, 92

SKIP procedure, 92

SKIP_ERROR procedure, 92

SKIP_TRANSACTION procedure, 92

UNSKIP procedure, 92

UNSKIP_ERROR procedure, 92

UNSKIP_TRANSACTION procedure, 92

using, 92

DBMS_METADATA package, 94

ADD_TRANSFORM function, 94

CLOSE procedure, 94

CONVERT functions and procedures, 94

GET_DDL function, 94

GET_QUERY function, 94

GET_XML function, 94

OPEN function, 94

OPENW function, 94

PUT function, 94

security, 94

SET_COUNT procedure, 94

SET_FILTER procedure, 94

SET_PARSE_ITEM procedure, 94

SET_REMAP_PARAM procedure, 94

SET_TRANSFORM_PARAM procedure, 94

DBMS_METADATA_DIFF package, 95, 95

ADD_DOCUMENT procedure, 95

FETCH_CLOB functions and procedures, 95

OPENC function, 95

DBMS_MGD_ID_UTL package, 96

ADD_SCHEME procedure, 96

CREATE_CATEGORY function, 96

EPC_TO_ORACLE_SCHEME function, 96

GET_CATEGORY_ID function, 96

GET_COMPONENTS function, 96

GET_ENCODINGS function, 96

GET_JAVA_LOGGING_LEVEL function, 96

GET_PLSQL_LOGGING_LEVEL function, 96

GET_SCHEMENAMES function, 96

GET_TDT_XML function, 96

GET_VALIDATOR function, 96

REFRESH_CATEGORY function, 96

REMOVE_CATEGORY procedure, 96

REMOVE_PROXY procedure, 96

REMOVE_SCHEME procedure, 96

SET_JAVA_LOGGING_LEVEL procedure, 96

SET_PLSQL_LOGGING_LEVEL procedure, 96

SET_PROXY procedure, 96

VALIDATE_SCHEME function, 96

DBMS_MGWADM package

summary of subprograms, 97

DBMS_MGWMSG package

constants, 98

summary of subprograms, 98

DBMS_MONITOR package

stastics tracing and gathering

DBMS_MONITOR package, 99

DBMS_MVIEW package

BEGIN_TABLE_REORGANIZATION procedure, 100

END_TABLE_REORGANIZATION procedure, 100

EXPLAIN_MVIEW procedure, 100

EXPLAIN_REWRITE procedure, 100

I_AM_A_REFRESH function, 100

PMARKER function, 100

PURGE_DIRECT_LOAD_LOG procedure, 100

PURGE_LOG procedure, 100

PURGE_MVIEW_FROM_LOG procedure, 100

REFRESH procedure, 100

REFRESH_ALL_MVIEWS procedure, 100

REFRESH_DEPENDENT procedure, 100

REGISTER_MVIEW procedure, 100

UNREGISTER_MVIEW procedure, 100

DBMS_ODCI package, 103

ESTIMATE_CPU_UNITS function, 103

methods, 103

DBMS_OFFLINE_OG package documentation, 104

DBMS_OUTLN package, 105

DBMS_OUTPUT package, 106

DBMS_PARALLEL_EXECUTE package, 107

DBMS_PCLXUTIL package, 109

DBMS_PIPE package, 112

DBMS_PREDICTIVE_ANALYTICS package, 113

EXPLAIN procedure, 113

PREDICT procedure, 113

PROFILE Procedure, 113

DBMS_PREPROCESSOR package, 114

DBMS_PROFILER package, 116

DBMS_PROPAGATION_ADM package, 117

DBMS_RANDOM package, 119

DBMS_RECTIFIER_DIFF package documentation, 120

DBMS_REDEFINITION package, 122

DBMS_REFRESH package documentation, 123

DBMS_REPAIR package, 124

DBMS_REPCAT package documentation, 125

DBMS_REPCAT_ADMIN package documentation, 126

DBMS_REPCAT_INSTANTIATE package documentation, 127

DBMS_REPCAT_RGT package documentation, 128

DBMS_REPUTIL package documentation, 129

DBMS_RESCONFIG package, 130

DBMS_RESOURCE_MANAGER package, 131

DBMS_RESOURCE_MANAGER_PRIVS package, 132

DBMS_RESULT_CACHE package, 133

DBMS_RESUMABLE package, 134

DBMS_RLS package, 135

DBMS_RLS.ADD_POLICY policy types

CONTEXT_SENSITIVE, 135

DYNAMIC, 135

SHARED_CONTEXT_SENSITIVE, 135

SHARED_STATIC, 135

STATIC, 135

DBMS_RLS.ENABLE_GROUPED_POLICY parameters

enable, 135

group_name, 135

object_name, 135

object_schema, 135

policy_name, 135

DBMS_RLS.REFRESH_POLICY parameters

object_name, 135

object_schema, 135

policy_name, 135

DBMS_ROWID package, 137

DBMS_RULE package, 138

DBMS_RULE_ADM package, 139

DBMS_SCHEDULER package, 140

ADD_EVENT_QUEUE_SUBSCRIBER Procedure, 140

ADD_GROUP_MEMBER Procedure, 140

ADD_JOB_EMAIL_NOTIFICATION Procedure, 140

ALTER_CHAIN Procedure, 140

ALTER_RUNNING_CHAIN Procedure, 140

CLOSE_WINDOW Procedure, 140

COPY_JOB Procedure, 140

CREATE_CHAIN Procedure, 140

CREATE_CREDENTIAL Procedure, 140

CREATE_DATABASE_DESTINATION Procedure, 140

CREATE_EVENT_SCHEDULE Procedure, 140

CREATE_FILE_WATCHER Procedure, 140

CREATE_GROUP Procedure, 140

CREATE_JOB Procedure, 140

CREATE_JOB_CLASS Procedure, 140

CREATE_JOBS Procedure, 140

CREATE_PROGRAM Procedure, 140

CREATE_SCHEDULE Procedure, 140

CREATE_WINDOW Procedure, 140

DEFINE_ANYDATA_ARGUMENT Procedure, 140

DEFINE_CHAIN_EVENT_STEP Procedure, 140

DEFINE_CHAIN_RULE Procedure, 140

DEFINE_CHAIN_STEP Procedure, 140

DEFINE_METADATA_ARGUMENT Procedure, 140

DEFINE_PROGRAM_ARGUMENT Procedure, 140

DISABLE Procedur, 140

DROP_AGENT_DESTINATION Procedure, 140

DROP_CHAIN Procedure, 140

DROP_CHAIN_RULE Procedure, 140

DROP_CHAIN_STEP Procedure, 140

DROP_CREDENTIAL Procedure, 140

DROP_DATABASE_DESTINATION Procedure, 140

DROP_FILE_WATCHER Procedure, 140

DROP_GROUP Procedure, 140

DROP_JOB Procedure, 140

DROP_JOB_CLASS Procedure, 140

DROP_PROGRAM Procedure, 140

DROP_PROGRAM_ARGUMENT Procedure, 140

DROP_SCHEDULE Procedure, 140

DROP_WINDOW Procedure, 140

ENABLE Procedure, 140

END_DETACHED_JOB_RUN Procedure, 140

EVALUATE_CALENDAR_STRING Procedure, 140

EVALUATE_RUNNING_CHAIN Procedure, 140

GENERATE_JOB_NAME Function, 140

GET_AGENT_INFO Function, 140

GET_AGENT_VERSION Function, 140

GET_ATTRIBUTE Procedure, 140

GET_FILE Procedure, 140

GET_SCHEDULER_ATTRIBUTE Procedure, 140

JOB DEFINITION constructor function, 140

JOB DEFINITION object type, 140

JOB_DEFINTION_ARRAY table type, 140

JOBARG constructor function, 140

JOBARG object type, 140

JOBARG_ARRAY table type, 140

JOBATTR constructor function, 140

JOBATTR object type, 140

JOBATTR_ARRAY table type, 140

OPEN_WINDOW Procedure, 140

PURGE_LOG Procedure, 140

PUT_FILE Procedure, 140

REMOVE_EVENT_QUEUE_SUBSCRIBER Procedure, 140

REMOVE_GROUP_MEMBER Procedure, 140

REMOVE_JOB_EMAIL_NOTIFICATION Procedure, 140

RESET_JOB_ARGUMENT_VALUE Procedure, 140

RUN_CHAIN Procedure, 140

RUN_JOB Procedure, 140

Scheduler Chain Condition Syntax, 140

SCHEDULER$_EVENT_INFO Object Type, 140

SCHEDULER$_STEP_TYPE object type, 140

SCHEDULER$_STEP_TYPE_LIST table type, 140

SCHEDULER_FILEWATCHER_REQUEST Object Type, 140

SCHEDULER_FILEWATCHER_RESULT Object Type, 140

SET_AGENT_REGISTRATION_PASS Procedure, 140

SET_ATTRIBUTE Procedure, 140

SET_ATTRIBUTE_NULL Procedure, 140, 140

SET_JOB_ANYDATA_VALUE Procedure, 140

SET_JOB_ARGUMENT_VALUE Procedure, 140, 140

SET_JOB_ATTRIBUTES Procedure, 140

SET_RESOURCE_CONSTRAINT Procedure, 140

SET_SCHEDULER_ATTRIBUTE Procedure, 140

STOP_JOB Procedure, 140

DBMS_SERVER_ALERT package, 141

DBMS_SERVICE package, 142

DBMS_SESSION package, 143

DBMS_SHARED_POOL package, 144

DBMS_SPACE package, 145

DBMS_SPACE_ADMIN package, 146

DBMS_SPM package, 148

DBMS_SQL package, 149

DBMS_SQLDIAG package, 152

DBMS_SQLTUNE package, 30, 30, 153, 154, 154

DBMS_STAT_FUNCS package, 156

DBMS_STATS package, 155

DBMS_STORAGE_MAP package, 157

DBMS_STREAMS package, 158

DBMS_STREAMS_ADM package, 159

apply user, 159

deprecated subprograms, 159

inbound server rules, 159

inbound servers, 159

outbound server rules, 159

DBMS_STREAMS_ADVISOR_ADM package, 160

constants, 160

operational notes, 160

subprograms, 160

using, 160

views, 160

DBMS_STREAMS_AUTH package, 161, 205

DBMS_STREAMS_HANDLER_ADM package, 162

DBMS_STREAMS_MESSAGING package, 163

DBMS_STREAMS_TABLESPACE package, 164

DBMS_TDB package, 166

DBMS_TDB.CHECK_DB Function, 166

DBMS_TDB.CHECK_DB procedure, 166

DBMS_TRACE package, 167

DBMS_TRANSACTION package, 168

DBMS_TRANSFORM package, 169

DBMS_TTS package, 172

DBMS_TYPES package, 173

DBMS_UTILITY package, 174

DBMS_WARNING package, 175

DBMS_WM package documentation, 176

DBMS_WORKLOAD_RECORD package, 177

DBMS_WORKLOAD_REPLAY package, 178

DBMS_WORKLOAD_REPOSITORY package, 179

DBMS_XA_XID Object Type, 180

DBMS_XA_XID_ARRAY Table Type, 180

DBMS_XBD_VERSION package, 186

DBMS_XDB Constants, 181

DBMS_XDB Overview, 181

DBMS_XDB package, 181

CONFIGUREAUTOSYNC procedure, 188

constants, 181

ConText synchronization settings, 188

CREATEDATASTOREPREF procedure, 188

CREATEFILTERPREF procedure, 188

CREATEINDEX procedure, 188

CREATELEXERPREF procedure, 188

CREATEPREFERENCES procedure, 188

CREATESECTIONGROUPPREF procedure, 188

CREATESTOPLISTPREF procedure, 188

CREATESTORAGEPREF procedure, 188

CREATEWORLDLISTPREF procedure, 188

DROPPREFERENCES procedure, 188

filtering settings, 188

general indexing settings, 188

methods, 181, 188

miscellaneous settings, 188

other index preference settings, 188

sectioning and section group settings, 188

stoplist settings, 188

SYNC settings, 188

DBMS_XDB_ADMIN package, 182

DBMS_XDB_VERSION package

CHECKIN function, 186

CHECKOUT procedure, 186

GETCONTENTSBLOBBYRESID function, 186

GETCONTENTSCLOBBYRESID function, 186

GETCONTENTSXMLBYRESID function, 186

GETPREDECESSORS function, 186

GETPREDSBYRESID function, 186

GETRESOURCEBYRESID function, 186

GETSUCCESSORS function, 186

GETSUCCSBYRESID function, 186

MAKEVERSIONED function, 186

UNCHECKOUT function, 186

DBMS_XDBRESOURCE package, 187

DBMS_XDBZ package

DISABLE_HIERARCHY procedure, 189

ENABLE_HIERARCHY procedure, 189

GET_ACLOID function, 189

GET_USERID function, 189

IS_HIERARCHY_ENABLED function, 189

PURGELDAPCACHE function, 189

DBMS_XMLDOM Constants, 191

DBMS_XMLDOM package, 191

APPENDDATA procedure, 191

CREATEATTRIBUTE function, 191

CREATECDATASECTION function, 191

CREATECOMMENT function, 191

CREATEDOCUMENT function, 191

CREATEDOCUMENTFRAGMENT, 191

CREATEELEMENT function, 191

CREATEENTITYREFERENCE function, 191

CREATEPROCESSINGINSTRUCTION function, 191

CREATETEXTNODE function, 191

DELETEDATA procedure, 191

description, 191

exceptions, 191

FINDENTITY function, 191

FINDNOTATION function, 191

FREEDOCFRAG procedure, 191

FREEDOCUMENT procedure, 191

GETATTRIBUTE function, 191

GETATTRIBUTENODE function, 191

GETBUBLICID function, 191

GETCHARSET function, 191

GETCHILDRENBYTAGNAME function, 191

GETDATA function, 191

GETDOCTYPE function, 191

GETDOCUMENTELEMENT function, 191

GETELEMENTSBYTAGNAME function, 191, 191

GETENTITIES function, 191

GETEXPANDEDNAME function, 191, 191

GETIMPLEMENTATION function, 191

GETLENGTH function, 191, 191, 191

GETNAME function, 191, 191

GETNAMEDITEM function, 191

GETNAMESPACE function, 191, 191

GETNAMESPACE procedure, 191

GETNEXTSIBLING function, 191

GETNODENAME function, 191

GETNODETYPE function, 191

GETNODEVALUE function, 191

GETNOTATIONNAME function, 191

GETNOTATIONS function, 191

GETOWNERDOCUMENT function, 191

GETOWNERELEMENT function, 191

GETPARENTNODE function, 191

GETPREFIX function, 191

GETPREVIOUSSIBLING function, 191

GETPUBLICID function, 191, 191

GETQUALIFIEDNAME function, 191, 191

GETSCHEMANODE function, 191

GETSPECIFIED function, 191

GETSTANDALONE function, 191

GETSYSTEMID function, 191, 191, 191

GETTAGNAME function, 191

GETTARGET function, 191

GETVALUE function, 191

GETVERSION function, 191

GETXMLTYPE function, 191

HASATTRIBUTE function, 191

HASATTRIBUTES function, 191

HASCHILDNODES function, 191

HASFEATURE function, 191

IMPORTNODE function, 191

INSERTBEFORE function, 191

INSERTDATA procedure, 191

ISNULL function, 191

MAKEATTR function, 191

MAKECDATASECTION function, 191

MAKECHARACTERDATA function, 191

MAKECOMMENT function, 191

MAKEDOCUMENT function, 191

MAKEDOCUMENTFRAGMENT function, 191

MAKEDOCUMENTTYPE function, 191

MAKEELEMENT function, 191

MAKEENTITY function, 191

MAKEENTITYREFERENCE function, 191

MAKENODE function, 191, 191, 191, 191

MAKENOTATION function, 191

MAKEPROCESSINGINSTRUCTION function, 191

MAKETEXT function, 191

methods

APPENDCHILD function, 191

APPENDDATA procedure, 191

CLONENODE function, 191

CREATEATTRIBUTE function, 191

CREATECDATASECTION function, 191

CREATECOMMENT function, 191

CREATEDOCUMENT function, 191

CREATEDOCUMENTFRAGMENT function, 191

CREATEELEMENT function, 191

CREATEENTITYREFERENCE function, 191

CREATEPROCESSINGINSTRUCTION function, 191

CREATETEXTNODE function, 191

DELETEDATA procedure, 191

DOMAttr interface, 191

DOMCDataSection interface, 191

DOMCharacterData interface, 191

DOMComment interface, 191

DOMDocument interface, 191

DOMDocumentFragment interface, 191, 191

DOMDocumentType interface, 191, 191

DOMElement interface, 191, 191

DOMEntity interface, 191, 191

DOMEntityReference interface, 191

DOMImplementation interface, 191

DOMNamedNodeMap interface, 191

DOMNodeAPPENDCHILD function, 191

DOMNodeCLONENODE function, 191

DOMNodeGETATTRIBUTES function, 191

DOMNodeGETCHILDNODES function, 191

DOMNodeGETEXPANDEDNAME procedure, 191

DOMNodeGETFIRSTCHILD function, 191

DOMNodeGETLASTCHILD function, 191

DOMNodeGETLOCALNAME procedure, 191

DOMNodeList interface, 191

DOMNotation interface, 191

DOMProcessingInstruction interface, 191

DOMText interface, 191, 191

FINDENTITY function, 191

FINDNOTATION function, 191

FREEDOCFRAG procedure, 191

FREEDOCUMENT procedure, 191

FREEELEMENT procedure, 191

FREENODE procedure, 191, 191, 191

FREENODELIST Procedure, 191

GETATTRIBUTE function, 191

GETATTRIBUTENODE function, 191

GETATTRIBUTES function, 191

GETBUBLICID function, 191

GETCHARSET function, 191

GETCHILDNODES function, 191

GETCHILDRENBYTAGNAME function, 191

GETDATA function, 191

GETDOCTYPE function, 191

GETDOCUMENTELEMENT function, 191

GETELEMENTSBYTAGNAME function, 191, 191

GETENTITIES function, 191

GETEXPANDEDNAME function, 191, 191

GETEXPANDEDNAME procedure, 191

GETFIRSTCHILD function, 191

GETIMPLEMENTATION function, 191

GETLASTCHILD function, 191

GETLENGTH function, 191, 191, 191

GETLOCALNAME procedure, 191

GETNAME function, 191, 191

GETNAMEDITEM function, 191

GETNAMESPACE function, 191, 191

GETNAMESPACE procedure, 191

GETNEXTSIBLING function, 191

GETNODENAME function, 191

GETNODETYPE function, 191

GETNODEVALUE function, 191

GETNOTATIONNAME function, 191

GETNOTATIONS function, 191

GETOWNERDOCUMENT function, 191

GETOWNERELEMENT function, 191

GETPARENTNODE function, 191

GETPREFIX function, 191

GETPREVIOUSSIBLING function, 191

GETPUBLICID function, 191, 191

GETQUALIFIEDNAME function, 191, 191

GETSCHEMANODE function, 191

GETSPECIFIED function, 191

GETSTANDALONE function, 191

GETSYSTEMID function, 191, 191, 191

GETTAGNAME function, 191

GETTARGET function, 191

GETVALUE function, 191

GETVERSION function, 191

GETXMLTYPE function, 191

HASATTRIBUTE function, 191

HASATTRIBUTES function, 191

HASCHILDNODES function, 191

HASFEATURE function, 191

IMPORTNODE function, 191

INSERTBEFORE function, 191

INSERTDATA procedure, 191

ISNULL function, 191

MAKEATTR function, 191

MAKECDATASECTION function, 191

MAKECHARACTERDATA function, 191

MAKECOMMENT function, 191

MAKEDOCUMENT function, 191

MAKEDOCUMENTFRAGMENT function, 191

MAKEDOCUMENTTYPE function, 191

MAKEELEMENT function, 191

MAKEENTITY function, 191

MAKEENTITYREFERENCE function, 191

MAKENODE function, 191, 191, 191, 191

MAKENOTATION function, 191

MAKEPROCESSINGINSTRUCTION function, 191

MAKETEXT function, 191

NEWDOMDOCUMENT function, 191

NORMALIZE procedure, 191

REMOVEATTRIBUTE procedure, 191

REMOVEATTRIBUTENODE function, 191

REMOVENAMEDITEM function, 191

REPLACECHILD function, 191

REPLACEDATA procedure, 191

RESOLVENAMESPACEPREFIX function, 191

SETATTRIBUTE procedure, 191

SETATTRIBUTENODE function, 191

SETCHARSET procedure, 191

SETDATA procedure, 191

SETNAMEDITEM function, 191

SETNODEVALUE procedure, 191

SETPREFIX procedure, 191

SETSTANDALONE procedure, 191

SETVALUE procedure, 191

SETVERSION procedure, 191

SPLITTEXT function, 191

SUBSTRINGDATA function, 191

WRITETOBUFFER procedure, 191

WRITETOCLOB procedure, 191

WRITETOFILE procedure, 191

NEWDOMDOCUMENT function, 191

NORMALIZE procedure, 191

REMOVEATTRIBUTE procedure, 191

REMOVEATTRIBUTENODE function, 191

REMOVENAMEDITEM function, 191

REPLACECHILD function, 191

REPLACEDATA procedure, 191

RESOLVENAMESPACEPREFIX function, 191

SETATTRIBUTE procedure, 191

SETATTRIBUTENODE function, 191

SETCHARSET procedure, 191

SETDATA procedure, 191

SETNAMEDITEM function, 191

SETNODEVALUE procedure, 191

SETPREFIX procedure, 191

SETSTANDALONE procedure, 191

SETVALUE procedure, 191

SETVERSION procedure, 191

SPLITTEXT function, 191

SUBSTRINGDATA function, 191

types, 70, 191

WRITETOBUFFER procedure, 191

WRITETOCLOB procedure, 191

WRITETOFILE procedure, 191

DBMS_XMLGEN package, 192

CLOSECONTEXT procedure, 192

CONVERT function, 192

GETNUMROWSPROCESSED Function, 192

GETXML function, 192

GETXMLTYPE function, 192

NEWCONTEXT function, 192

RESTARTQUERY procedure, 192

SETCONVERTSPECIALCHARS procedure, 192

SETMAXROWS procedure, 192

SETROWSETTAG procedure, 192

SETROWTAG procedure, 192

SETSKIPROWS procedure, 192

USEITEMTAGSFORCOLL procedure, 192

USENULLATTRIBUTEINDICATOR procedure, 192

DBMS_XMLINDEX package, 193

DBMS_XMLPARSER package, 194

FREEPARSER procedure, 194

GETDOCTYPE function, 194

GETDOCUMENT function, 194

GETRELEASEVERSION function, 194

GETVALIDATIONMODE function, 194

NEWPARSER function, 194

PARSE function, 194, 194

PARSE procedure, 194

PARSEBUFFER procedure, 194

PARSECLOB procedure, 194

PARSEDTD procedure, 194

PARSEDTDBUFFER procedure, 194

PARSEDTDCLOB procedure, 194

SETBASEDIR procedure, 194

SETDOCTYPE procedure, 194

SETERRORLOG procedure, 194

SETPRESERVEWHITESPACE procedure, 194

SETVALIDATIONMODE procedure, 194

SHOWWARNINGS procedure, 194

DBMS_XMLQUERY package, 195

CLOSECONTEXT procedure, 195

constants, 195

GETDTD function, 195

GETDTD procedure, 195

GETEXCEPTIONCONTENT procedure, 195

GETNUMROWSPROCESSED procedure, 195

GETVERSION procedure, 195

GETXML function, 195

GETXML procedure, 195

NEWCONTEXT function, 195

PROPAGATEORIGINALEXCEPTION procedure, 195

REMOVEXSLTPARAM procedure, 195

SETBINDVALUE procedure, 195

SETCOLLIDATTRNAME procedure, 195

SETDATAHEADER procedure, 195

SETDATEFORMAT procedure, 195

SETENCODINGTAG procedure, 195

SETERRORTAG procedure, 195

SETMAXROWS procedure, 195

SETMETAHEADER procedure, 195

SETRAISEEXCEPTION procedure, 195

SETRAISENOROWSEXCEPTION procedure, 195

SETROWIDATTRNAME procedure, 195

SETROWIDATTRVALUE procedure, 195

SETROWSETTAG procedure, 195

SETROWTAG procedure, 195

SETSKIPROWS procedure, 195

SETSQLTOXMLNAMEESCAPING procedure, 195

SETSTYLESHEETHEADER procedure, 195

SETTAGCASE procedure, 195

SETXSLT procedure, 195

SETXSLTPARAM procedure, 195

types, 195

USENULLATTRIBUTEINDICATOR procedure, 195

USETYPEFORCOLLELEMTAG procedure, 195

DBMS_XMLSAVE package, 196

CLEARKEYCOLUMNLIST procedure, 196

CLEARUPDATECOLUMNLIST procedure, 196

CLOSECONTEXT procedure, 196

constants, 196

DELETEXML function, 196

GETEXCEPTIONCONTENT procedure, 196

INSERTXML function, 196

NEWCONTEXT function, 196

PROPAGATEORIGINALEXCEPTION procedure, 196

REMOVEXSLTPARAM procedure, 196

SETBATCHSIZE procedure, 196

SETCOMMITBATCH procedure, 196

SETDATEFORMAT procedure, 196

SETIGNORECASE procedure, 196

SETKEYCOLUMN procedure, 196

SETPRESERVEWHITESPACE procedure, 196

SETROWTAG procedure, 196

SETSQLTOXMLNAMEESCAPING procedure, 196

SETUPDATECOLUMN procedure, 196

SETXSLT procedure, 196

SETXSLTPARAM procedure, 196

UPDATEXML function, 196

DBMS_XMLSCHEMA Constants, 197

DBMS_XMLSCHEMA Operational Notes, 197

DBMS_XMLSCHEMA package, 197

DBMS_XMLSCHEMA Views, 197

DBMS_XMLSTORE package, 200

CLEARKEYCOLUMNLIST procedure, 200

CLEARUPDATECOLUMNLIST procedure, 200

CLOSECONTEXT procedure, 200

DELETEXML function, 200

INSERTXML function, 200

NEWCONTEXT function, 200

SETKEYCOLUMN procedure, 200

SETROWTAG procedure, 200

SETUPDATECOLUMN procedure, 200

types, 200

UPDATEXML function, 200

DBMS_XMLTRANSLATIONS package, 201

DBMS_XPLAN package, 202

DBMS_XSLPROCESSOR package

CLOB2FILE procedure, 203

FREEPROCESSOR procedure, 203

FREESTYLESHEET procedure, 203

NEWPROCESSOR function, 203

NEWSTYLESHEET function, 203

PROCESSXSL function, 203

READ2CLOB function, 203

REMOVEPARAM procedure, 203

RESETPARAMS procedure, 203

SELECTNODES function, 203

SELECTSINGLENODE function, 203

SETERRORLOG procedure, 203

SETPARAM procedure, 203

SHOWWARNINGS procedure, 203

TRANSFORMNODE function, 203

VALUEOF procedure, 203

DBMS_XSLPROCESSOR Package, 203, 203

DBMS_XSTREAM_ADM package, 204

security, 204

DBMSOUTPUT_LINESARRAY Object Type, 106

DBUriType, 273

DBURITYPE function, 273

DBUriType subtype, 273

CREATEURI function, 273

DBURITYPE function, 273

GETBLOB function, 273

GETCLOB function, 273

GETCONTENTTYPE function, 273

GETEXTERNALURL function, 273

GETURL function, 273

GETXML function, 273

methods, 273

DEAUTHORIZE_DAD Procedure, 65

DEBUG_EXPTOC package, 206

DEBUG_ON procedure, 53

DECLARE_REWRITE_EQUIVALENCE Procedures, 18

DECODEFEATURES Function, 48

DEFAULT_NAME function, 44

DEFINE_ARRAY procedure, 149

DEFINE_COLUMN procedure, 149

DEFINE_COLUMN_CHAR Procedure, 149

DEFINE_COLUMN_LONG procedure, 149

DEFINE_COLUMN_RAW Procedure, 149

DEFINE_COLUMN_ROWID Procedure, 149

DEINIT_CLEANUP procedure, 29

DELETE Procedure, 17

DELETE_ALL_ERRORS procedure, 23

DELETE_BREAKPOINT function, 53

DELETE_CAPTURE_INFO Procedure, 177

DELETE_CATEGORY Procedure, 131

DELETE_CDB_PLAN Procedure, 131

DELETE_CDB_PLAN_DIRECTIVE Procedure, 131

DELETE_COLUMN member procedure, 275

DELETE_COLUMN procedure, 159, 204

DELETE_COLUMN_STATS pocedure, 155

DELETE_CONSUMER_GROUP procedure, 131

DELETE_DAD_ATTRIBUTE Procedure, 65, 65

DELETE_DATABASE_PREFS Procedure, 155

DELETE_DATABASE_STATS procedure, 155

DELETE_DICTIONARY_STATS procedure, 155

DELETE_ERROR procedure, 23

DELETE_FILTER Procedure, 177, 178

DELETE_FINDING_DIRECTIVE Procedure, 17

DELETE_FIXED_OBJECTS_STATS procedure, 155

DELETE_INDEX_STATS procedure, 155

DELETE_OBJECT procedure, 262

DELETE_OER_BREAKPOINT function, 53

DELETE_PARAMETER_DIRECTIVE Procedure, 17

DELETE_PENDING_STATS Procedure, 155

DELETE_PLAN procedure, 131

DELETE_PLAN_CASCADE procedure, 131

DELETE_PLAN_DIRECTIVE procedure, 131

DELETE_POLICY_GROUP Procedure, 135

DELETE_PRIVILEGE Procedure, 101

DELETE_PROCESSING_RATE Procedure, 155

DELETE_REPLAY_INFO Procedure, 178

DELETE_SCHEMA_PREFS Procedure, 155

DELETE_SCHEMA_STATS Procedure, 155

DELETE_SEGMENT_DIRECTIVE Procedure, 17

DELETE_SERVICE procedure, 142

DELETE_SQL_DIRECTIVE Procedure, 17

DELETE_SQLSET procedure, 154

DELETE_SQLWKLD Procedure, 19

DELETE_SQLWKLD_REF Procedure, 19

DELETE_SQLWKLD_STATEMENT Procedure, 19

DELETE_SYSTEM_STATS procedure, 155

DELETE_TABLE_PREFS Procedure, 155

DELETE_TABLE_STATS procedure, 155

DELETE_TASK Procedure, 19

DELETECONTENT Procedure, 48, 49

DELETEDATA procedure, 191

DELETEDIRECTORY Procedure, 48, 49

DELETEFILE Procedure, 48, 49

DELETEHTTPEXPIREMAPPING Procedure, 183

DELETEMIMEMAPPING Procedure, 183

DELETEREPOSITORYRESCONFIG Procedure, 130

DELETERESCONFIG Procedure, 130

DELETERESOURCE Procedure, 185

DELETERESOURCEMETADATA Procedures, 185

DELETESCHEMA procedure, 197

DELETESCHEMALOCMAPPING Procedure, 183

DELETESERVLET Procedure, 183

DELETESERVLETMAPPING Procedure, 183

DELETESERVLETSECROLE Procedure, 183

DELETEXML function, 196, 200

DELETEXMLEXTENSION Procedure, 183

DEQUEUE procedure, 163

DEQUEUE_ARRAY Function, 24

DEQUEUE_OPTIONS_T Type, 271

DEREGISTER Procedure, 38

DEREGISTER_ERROR_TRANSLATION Procedure, 150

DEREGISTER_SQL_TRANSLATION Procedure, 150

DEREGSTORECOMMAND Function, 50

DERIVE_FROM_MVIEW function, 42

DESC_REC2 Record Type, 149

DESC_REC3 Record Type, 149

DESC_RESC Record Type, 149

DESC_TAB Table Type, 149

DESC_TAB2 Table Type, 149

DESC_TAB3 Table Type, 149

DESCRIBE Procedure, 110

DESCRIBE_COLUMNS procedure, 149

DESCRIBE_COLUMNS2 procedure, 149

DESCRIBE_COLUMNS3 Procedure, 149

DESCRIBE_DIMENSION procedure, 60

DESCRIBE_PROCEDURE procedure, 58

DESCRIBE_STACK procedure, 46

DESTROY_REQUEST_CONTEXT Procedure, 252, 252

DETACH_SESSION procedure, 53

DETACH_SIMPLE_TABLESPACE procedure, 164

DETACH_TABLESPACES procedure, 164

DFN function

of HTF package, 207

DFN procedure

of HTP package, 208

DIFF_PLAN Function, 202

DIFF_TABLE_STATS_IN_HISTORY Function, 155

DIFF_TABLE_STATS_IN_PENDING Function, 155

DIFF_TABLE_STATS_IN_STATTAB Function, 155

dimension maintenance (cube), 42

dimensions

optimizer statistics, 33

DIRECTORY_OBJECT_SET type, 164

DIRLISTCLOSE function

of HTF package, 207

DIRLISTCLOSE procedure

of HTP package, 208

DIRLISTOPEN function

of HTF package, 207

DIRLISTOPEN procedure

of HTP package, 208

DISABLE procedure, 44

of DBMS_FLASHBACK package, 70

of DBMS_OUTPUT package, 106

of OWA_CACHE package, 211

DISABLE Procedures, 32

DISABLE_APPLICATION Procedure, 71

DISABLE_ASOF_VALID_TIME Procedure, 71

DISABLE_BREAKPOINT function, 53

DISABLE_CAPTURE Procedure, 115

DISABLE_CREDENTIAL Procedure, 39

DISABLE_GROUPED_POLICY Procedure, 135

DISABLE_HIERARCHY procedure, 189

DISABLE_ILM Procedure, 80

DISABLE_JOB Procedure, 97

DISABLE_POLICY Procedure, 121

DISABLE_PROPAGATION_SCHEDULE Procedure, 97

DISABLE_PROTECTION_COLUMN Procedure, 171

DISABLE_PROTECTION_SOURCE Procedure, 171

DISABLE_PROTECTION_TYPE Procedure, 171

DISABLEDEFAULTTABLECREATION Procedure, 198

DISABLEINDEXESANDCONSTRAINTS Procedure, 199

DISABLEMAINTAINDOM Procedure, 198

DISABLETRANSLATION Procedure, 201

DISASSOCIATE_FBA Procedure, 71

DISCONNECT_SESSION procedure, 142

DISPLAY function, 202

DISPLAY_AWR function, 202

DISPLAY_CURSOR function, 202

DISPLAY_PLAN Function, 202

DISPLAY_SQL_PLAN_BASELINE Function, 202

DISPLAY_SQLSET Function, 202

DIST_TXN_SYNC Procedure, 180

DIV function

of HTF package, 207

DIV procedure

of HTP package, 208

DLISTCLOSE function

of HTF package, 207

DLISTCLOSE procedure

of HTP package, 208

DLISTDEF function

of HTF package, 207

DLISTDEF procedure

of HTP package, 208

DLISTOPEN function

of HTF package, 207

DLISTOPEN procedure

of HTP package, 208

DLISTTERM function

of HTF package, 207

DLISTTERM procedure

of HTP package, 208

DOMAIN_LEVEL Function, 102

DOMAINS Function, 102

DOMAttr methods, 191

DOMCDataSection methods, 191

DOMCharacterData methods, 191

DOMComment methods, 191

DOMDocument methods, 191

DOMDocumentType methods, 191, 191

DOMEntity methods, 191

DOMNamedNodeMap methods, 191

DOMText methods, 191

DOWNGRADE procedure, 172

DOWNLOAD_FILE procedures, 267

DROFILESYSTEM Procedures, 51

DROP_ACL Procedure, 101

DROP_ALL function, 157

DROP_ANALYSIS_TASK Procedure, 153

DROP_APPLICATION Procedure, 71

DROP_APPLY procedure, 23

DROP_BASELINE procedure, 179

DROP_BY_CAT procedure, 105

DROP_CAPTURE procedure

capture process

dropping, 34

DROP_CAPTURE Procedure, 115

DROP_CHUNKS Procedure, 107

DROP_COMPARISON Procedure, 35

DROP_CREDENTIAL Procedure, 39

DROP_DAD Procedure, 65

DROP_DIAGNOSIS_TASK Procedure, 152

DROP_EMPTY_SEGMENTS Procedure, 146

DROP_EVALUATION_CONTEXT procedure, 139

DROP_EVOLVE_TASK Procedure, 148

DROP_EXTENDED_STATS Procedure, 155

DROP_FILE function, 157

DROP_FILE_GROUP procedure, 68

DROP_GROUPED_POLICY Procedure, 135

DROP_INBOUND procedure, 204

DROP_MVIEW procedure, 42, 42

DROP_OBJECT_DEPENDENCY procedure, 23

DROP_OLD_UNIFIED_AUDIT_TABLES Procedure, 29

DROP_OUTBOUND procedure, 204

DROP_POLICY Procedure, 121, 135, 171

DROP_POLICY_CONTEXT Procedure, 135

DROP_PROFILE Procedure, 150

DROP_PROPAGATION procedure, 117

DROP_PURGE_JOB procedure, 29

DROP_REWRITE_EQUIVALENCE Procedure, 18

DROP_RULE procedure, 139

DROP_RULE_SET procedure, 139

DROP_SENSITIVE_COLUMN Procedure, 170

DROP_SENSITIVE_TYPE Procedure, 170

DROP_SENSITIVE_TYPE_SOURCE Procedure, 170

DROP_SNAPSHOT_RANGE procedure, 179

DROP_SQL_PATCH Function & Procedure, 152

DROP_SQL_PLAN_BASELINE, 148

DROP_SQL_PLAN_DIRECTIVE Procedure, 147

DROP_SQL_PROFILE procedure, 154

DROP_SQLSET procedure, 154

DROP_STAT_TABLE procedure, 155

DROP_STMT_HANDLER procedure, 162

DROP_TASK Procedure, 107

DROP_TRANSFORMATION procedure, 169

DROP_TUNING_TASK procedure, 154

DROP_UNUSED procedure, 105

DROP_VERSION procedure, 68

DROP_VIEW procedure

of DBMS_HS_PARALLEL package, 77

DROPPARAMETER Procedure, 193

DROPPREFERENCES procedure, 188

DROPREPOSITORYXMLINDEX Procedure, 182

DROPSTORE Procedure, 50

DUMP_ORPHAN_KEYS procedure, 124

dynamic SQL

anonymous blocks and, 149

DBMS_SQL functions, using, 149

execution flow in, 149

DYNAMIC_DEPTH Function, 247

---

E

EDIT_DISTANCE Function, 258

EDIT_DISTANCE_SIMILARITY Function, 258

EHLO function and procedure, 263

EM function

of HTF package, 207

EM procedure

of HTP package, 208

e-mail from PL/SQL (email), 265

EMPHASIS function

of HTF package, 207

EMPHASIS procedure

of HTP package, 208

ENABLE procedure, 44, 106

ENABLE Procedures, 32

ENABLE_APPLICATION Procedure, 71

ENABLE_AT_SYSTEM_CHANGE_NUMBER procedure, 70

ENABLE_AT_TIME procedure, 70

ENABLE_AT_VALID_TIME Procedure, 71

ENABLE_BREAKPOINT function, 53

ENABLE_CAPTURE Procedure, 115

ENABLE_CREDENTIAL Procedure, 39

ENABLE_ERROR_TRANSLATION Procedure, 150

ENABLE_GG_XSTREAM_FOR_STREAMS procedure, 204

ENABLE_GROUPED_POLICY Procedure, 135

ENABLE_HIERARCHY procedure, 189

ENABLE_ILM Procedure, 80

ENABLE_JOB Procedure, 97

ENABLE_POLICY Procedure, 121, 135

ENABLE_PROPAGATION_SCHEDULE Procedure, 97

ENABLE_PROTECTION_COLUMN Procedure, 171

ENABLE_PROTECTION_SOURCE Procedure, 171

ENABLE_PROTECTION_TYPE Procedure, 171

ENABLE_SQL_TRANSLATION Procedure, 150

ENABLEDEFAULTTABLECREATION Procedure, 198

ENABLEDIGESTAUTHENTICATION Procedure, 183

ENABLEINDEXESANDCONSTRAINTS Procedure, 199

ENABLEMAINTAINDOM Procedure, 198

ENABLETRANSLATION Procedure, 201

ENCODING_DEFAULT Function, 184

ENCODING_ISOLATIN1 Function, 184

ENCODING_UTF8 Function, 184

ENCODING_WIN1252 Function, 184

END_OPERATION Procedure, 151

END_PREPARE Procedure, 62

END_REPLAY_SCHEDULE Procedure, 178

END_REQUEST procedure, 252

END_RESPONSE procedure, 252

END_SQL_BLOCK Procedure, 131

END_UPGRADE Procedure, 62

ENDCREATE member procedure

of ANYDATA TYPE, 268

of ANYDATASET TYPE, 269

of ANYTYPE TYPE, 270

ENQUEUE procedure, 163

ENQUEUE_ARRAY Function, 24

ENQUEUE_OPTIONS_T Type, 271

ENQUOTE_LITERAL Function, 28

ENQUOTE_NAME Function, 28

EPC_TO_ORACLE_SCHEME function, 96

EQUALS_HOST Function, 102

ERASE Procedures, 88

error queue

deleting errors, 23, 23

executing errors, 23, 23

getting error messages, 23

ERROR_DEPTH Function, 247

ERROR_MSG Function, 247

ERROR_NUMBER Function, 247

ESCAPE function, 266

ESCAPE_SC function

of HTF package, 207

ESCAPE_SC procedure

of HTP package, 208

ESCAPE_URL function

of HTF package, 207

ESCAPEURI function, 273

ESTIMATE_CPU_UNITS function, 103

ESTIMATE_MVIEW_SIZE Procedure, 100

ETINSTANCE member function

of ANYDATASET TYPE, 269

EVALUATE procedure, 138

EVOLVE_SQL_PLAN_BASELINE Function, 148

EXACT_TEXT_SIGNATURES procedure, 105

EXCHANGEPOSTPROC Procedure, 199

EXCHANGEPREPROC Procedure, 199

EXEC_DDL_STATEMENT Procedure, 174

EXECUTE function, 149

EXECUTE member procedure, 275, 275

EXECUTE procedure, 53

EXECUTE_ALL_ERRORS procedure, 23

EXECUTE_ANALYSIS_TASK, 153

EXECUTE_AND_FETCH function, 149

EXECUTE_DIAGNOSIS_TASK Procedure, 152

EXECUTE_ERROR procedure, 23

EXECUTE_EVOLVE_TASK Function, 148

EXECUTE_ILM Procedure, 79

EXECUTE_ILM_TASK Procedur, 79

EXECUTE_IMMEDIATE Procedure, 78

EXECUTE_NON_QUERY Function, 78

EXECUTE_TASK Procedure, 19

EXECUTE_TUNING_TASK Function & Procedure, 30, 154

execution flow

in dynamic SQL, 149

EXISTSNODE function, 285

EXISTSRESOURCE Function, 185

EXPAND_MESSAGE function, 141

EXPAND_SQL_TEXT Procedure, 174

EXPLAIN_SQL_TESTCASE Function, 152

EXPONENTIAL_DIST_FIT procedure, 156

EXPORT_AWR Procedure, 177, 178

EXPORT_COLUMN_STATS procedure, 155

EXPORT_DATABASE_PREFS Procedure, 155

EXPORT_DATABASE_STATS procedure, 155

EXPORT_DICTIONARY_STATS procedure, 155

EXPORT_FIXED_OBJECTS_STATS procedure, 155

EXPORT_INDEX_STATS procedure, 155

EXPORT_PENDING_STATS Procedure, 155

EXPORT_PROFILE Procedure, 150

EXPORT_SCHEMA_PREFS Procedure, 155

EXPORT_SCHEMA_STATS procedure, 155

EXPORT_SQL_TESTCASE Procedures, 152

EXPORT_SQL_TESTCASE_DIR_BY_INC Function, 152

EXPORT_SQL_TESTCASE_DIR_BY_TXT Function, 152

EXPORT_SYSTEM_STATS procedure, 155

EXPORT_TABLE_PREFS Procedure, 155

EXPORT_TABLE_STATS procedure, 155

EXPORT_XML procedure, 42, 42

EXPORT_XML_TO_FILE procedure, 42

EXTEND_MAPPINGS Procedure, 71

EXTENT_HEAT_MAP Function, 74

EXTRACT function, 285

EXTRACTXLIFF Function & Procedure, 201

---

F

FCLOSE procedure, 251

FCLOSE_ALL procedure, 251

FCOPY procedure, 251

FEATURE_OPTIONS Table Type, 171

FEATURE_T Record Type, 48

FEATURENAME Function, 48

FEATURES_T Table Type, 48

FETCH_ROW Function, 78

FETCH_ROWS function, 149

FFLUSH procedure, 251

FGETATTR procedure, 251

FGETPOS function, 251

FI_HORIZONTAL function, 73

FI_TRANSACTIONAL function, 73

file groups, 68

adding files, 68

altering, 68

altering files, 68

altering versions, 68

creating, 68

creating versions, 68

dropping, 68

dropping versions, 68

granting object privileges, 68

granting system privileges, 68

purging, 68

removing files, 68

revoking object privileges, 68

revoking system privileges, 68

FILE type, 164

FILE_SET type, 164

FILECLOSE Procedure, 88

FILECLOSEALL Procedure, 88

FILEEXISTS Function, 88

FILEGETNAME Procedure, 88

FILEISOPEN Function, 88

FILEOPEN Procedure, 88

FILETYPE Record Type, 251

FIND_AFFECTED_TABLE Procedure, 62

FINDENTITY function, 191

FINDNOTATION function, 191

fine-grained access control

DBMS_RLS package, 135

FINISH_CAPTURE Procedure, 177

FINISH_REDEF_TABLE procedure, 122

FINISH_REPORT_CAPTURE Procedure, 31

FIX_CORRUPT_BLOCKS procedure, 124

FLUSH Function & Procedure, 133

FLUSH procedure, 44, 265

FLUSH_DATA function and procedure, 116

FLUSH_DATABASE_MONITORING_INFO procedure, 155

FLUSH_SQL_PLAN_DIRECTIVE Procedure, 147

FLUSH_UNIFIED_AUDIT_TRAIL, 29

FLUSHCACHE Procedure, 50

FONTCLOSE function

of HTF package, 207

FONTCLOSE procedure

of HTP package, 208

FONTOPEN function

of HTF package, 207

FONTOPEN procedure

of HTP package, 208

FOPEN function, 251

FOPEN_NCHAR function, 251

FORCE parameter

and job-to-instance affinity, 84

FORMAT function, 282

FORMAT_CALL_STACK Function, 174

FORMAT_CELL function

of HTF package, 207

FORMAT_ERROR_BACKTRACE Function, 174

FORMAT_ERROR_STACK Function, 174

FORMCHECKBOX function

of HTF package, 207

FORMCHECKBOX procedure

of HTP package, 208

FORMCLOSE function

of HTF package, 207, 207

FORMCLOSE procedure

of HTP package, 208

FORMFILE function

of HTF package, 207

FORMFILE procedure

of HTP package, 208, 208

FORMHIDDEN function

of HTF package, 207

FORMHIDDEN procedure

of HTP package, 208

FORMIMAGE function

of HTF package, 207

FORMIMAGE procedure

of HTP package, 208

FORMOPEN function

of HTF package, 207

FORMOPEN procedure

of HTP package, 208

FORMPASSWORD function

of HTF package, 207

FORMPASSWORD procedure

of HTP package, 208

FORMRADIO function

of HTF package, 207

FORMRADIO procedure

of HTP package, 208

FORMRESET function

of HTF package, 207

FORMRESET procedure

of HTP package, 208

FORMSELECTCLOSE function

of HTF package, 207

FORMSELECTCLOSE procedure

of HTP package, 208

FORMSELECTOPEN function

of HTF package, 207

FORMSELECTOPEN procedure

of HTP package, 208

FORMSELECTOPTION function

of HTF package, 207

FORMSELECTOPTION procedure

of HTP package, 208

FORMSUBMIT function

of HTF package, 207

FORMSUBMIT procedure

of HTP package, 208

FORMTEXT function

of HTF package, 207

FORMTEXT procedure

of HTP package, 208

FORMTEXTAREA function

of HTF package, 207

FORMTEXTAREA procedure

of HTP package, 208

FORMTEXTAREA2 function

of HTF package, 207

FORMTEXTAREA2 procedure

of HTP package, 208

FORMTEXTAREACLOSE function

of HTF package, 207

FORMTEXTAREACLOSE procedure

of HTP package, 208

FORMTEXTAREAOPEN function

of HTF package, 207

FORMTEXTAREAOPEN procedure

of HTP package, 208

FORMTEXTAREAOPEN2 function

of HTF package, 207

FORMTEXTAREAOPEN2 procedure

of HTP package, 208

FRAGMENT_DELETE Procedure, 88

FRAGMENT_INSERT Function, 88

FRAGMENT_MOVE Procedure, 88

FRAGMENT_REPLACE Procedure, 88

FRAME function

of HTF package, 207

FRAME procedure

of HTP package, 208

FRAMESETCLOSE function

of HTF package, 207

FRAMESETCLOSE procedure

of HTP package, 208

FRAMESETOPEN function

of HTF package, 207

FRAMESETOPEN procedure

of HTP package, 208

FREE_BLOCKS procedure, 145

FREE_UNUSED_USER_MEMORY Procedure, 143

FREEDOCFRAG procedure, 191

FREEDOCUMENT procedure, 191

FREENODE procedure, 191, 191

FREEPARSER procedure, 194

FREEPROCESSOR procedure, 203

FREERESOURCE Procedure, 187

FREESTYLESHEET procedure, 203

FREETEMPORARY Procedures, 88

FREMOVE procedure, 251, 251

FRENAME procedure, 251

FSEEK procedure, 251

---

G

GATHER_DATABASE_STATS procedures, 155

GATHER_DICTIONARY_STATS procedure, 155

GATHER_FIXED_OBJECTS_STATS procedure, 155

GATHER_INDEX_STATS Procedure, 155

GATHER_PROCESSING_RATE Procedure, 155

GATHER_SCHEMA_STATS procedures, 155

GATHER_SYSTEM_STATS procedure, 155

GATHER_TABLE_STATS procedure, 155

GENERATE_CAPTURE_SUBSET Procedure, 178

GENERATE_RESULT Procedure, 115

GENERATE_STATS procedure, 155

GENERATE_TASK_NAME Function, 107

GENERATESCHEMA Function, 197

GENERATESCHEMAS function, 197

GET function

of OWA_COOKIE package, 212

GET* member functions

of ANYDATA TYPE, 268

of ANYDATASET TYPE, 269

GET_ AUDIT_TRAIL_PROPERTY_VALUE Function, 29

GET_ACLOID function, 189

GET_ALL procedure, 212

GET_ALL_DAD_ATTRIBUTES Procedure, 65

GET_ALL_DAD_MAPPINGS Procedure, 65

GET_ALL_GLOBAL_ATTRIBUTES Procedure, 65

GET_ALL_NAMES member function, 283

GET_ASH_QUERY Function, 17

GET_AUDIT_COMMIT_DELAY function, 29

GET_AUTHENTICATION procedure, 252

GET_BASE_TABLE_NAME member function, 275

GET_BASE_TABLE_OWNER member function, 275

GET_BODY_CHARSET procedure, 252

GET_CAPTURE_INFO Function, 177

GET_CATEGORY function, 175

GET_CATEGORY_ID function, 96

GET_CGI_ENV function, 219

GET_CLIENT_ATTRIBUTES Procedure, 32

GET_CLIENT_HOSTNAME function, 217

GET_CLIENT_IP function, 217

GET_COLUMN_STATS procedures, 155

GET_COMMAND_TYPE member function, 275

GET_COMMIT_SCN member function, 275

GET_COMMIT_SCN_FROM_POSITION static function, 275

GET_COMMIT_TIME member function, 275

GET_COMMON_TIME_ZONES Function, 253

GET_COMPATIBLE member function, 275

GET_COMPONENT function, 282

GET_COMPONENTS function, 96

GET_COMPRESSION_RATIO Procedure, 36

GET_COMPRESSION_TYPE Function, 36

GET_COOKIE_COUNT function, 252

GET_COOKIE_SUPPORT procedure, 252

GET_COOKIES function, 252

GET_CPU_TIME Function, 174

GET_CURRENT_SCHEMA member function, 275

GET_DAD_ATTRIBUTE Function, 65

GET_DAD_LIST Procedure, 65

GET_DBFS_LINK Functions, 88

GET_DBFS_LINK_STATE Procedure, 88

GET_DEFAULT_ISO_CURRENCY Function, 253

GET_DEFAULT_LINGUISTIC_SORT Function, 253

GET_DEPENDENCY Procedure, 174

GET_DETAILED_EXCP_SUPPORT procedure, 252

GET_DETAILED_SQLCODE function, 252

GET_DETAILED_SQLERRM function, 252

GET_DIVERGING_STATEMENT Function, 178

GET_EDITION_NAME member function, 275

GET_ENCODINGS function, 96

GET_ENDIANNESS Function, 174

GET_ERROR_MESSAGE function, 23

GET_ETAG function, 211

GET_EXPRESSION function, 46

GET_EXTRA_ATTRIBUTE member function, 275

GET_FILE procedure, 69

GET_FIX_CONTROL Function, 152

GET_FOLLOW_REDIRECT procedure, 252

GET_GLOBAL_ATTRIBUTE Function, 65

GET_HASH_VALUE Function, 174

GET_HEADER procedure, 252

GET_HEADER_BY_NAME procedure, 252

GET_HEADER_COUNT function, 252

GET_HOST_ADDRESS function, 254

GET_HOST_NAME function, 254

GET_INDEX_STATS procedures, 155

GET_INDEXES function, 53

GET_INFORMATION function, 158

GET_JAVA_LOGGING_LEVEL function, 96

GET_LAST_ARCHIVE_TIMESTAMP Function, 29

GET_LEVEL function, 211

GET_LINE function, 265

GET_LINE procedure, 106, 251

GET_LINE_MAP function, 53

GET_LINE_NCHAR Function, 265

GET_LINE_NCHAR procedure, 251

GET_LINES procedure, 106

GET_LOB_INFORMATION member function, 275

GET_LOB_OFFSET member function, 275

GET_LOB_OPERATION_SIZE member procedure, 275

GET_LOCAL_LINGUISTIC_SORTS Function, 253

GET_LOG procedure, 44

GET_LOG_SPEC function, 44

GET_LOGON_USER member function, 275

GET_LONG_INFORMATION member function, 275

GET_LTXID_OUTCOME Procedure, 21

GET_MAX_STREAMS_POOL Procedure, 25

GET_MESSAGE_TRACKING function, 159, 204

GET_MIN_STREAMS_POOL Procedure, 25

GET_MORE_SOURCE procedure, 53

GET_NEXT_HIT function, 138

GET_NEXT_RESULT Procedures, 149

GET_NUMBER_COL_CHUNK Procedure, 107

GET_OBJECT_NAME member function, 275

GET_OBJECT_OWNER member function, 275

GET_OBJECT_TYPE member function, 275

GET_OPATCH_BUGS Function, 118

GET_OPATCH_COUNT Function, 118

GET_OPATCH_DATA Function, 118

GET_OPATCH_FILES Function, 118

GET_OPATCH_INSTALL_INFO Function, 118

GET_OPATCH_LIST Function, 118

GET_OPATCH_LSINVENTORY, 118

GET_OPATCH_OLAYS Function, 118

GET_OPATCH_PREQS Function, 118

GET_OPATCH_XSLT, 118

GET_OWA_SERVICE_PATH function, 219

GET_P1_RESOURCES Procedure, 32

GET_PACKAGE_MEMORY_UTILIZATION Procedure, 143

GET_PARAM function, 155

GET_PARAMETER function, 44

GET_PARAMETER_VALUE Function, 174

GET_PASSWORD function, 217

GET_PENDING_ACTIVITY, 118

GET_PERSISTENT_CONN_COUNT function, 252

GET_PERSISTENT_CONN_SUPPORT procedure, 252

GET_PERSISTENT_CONNS procedure, 252

GET_PLSQL_LOGGING_LEVEL function, 96

GET_PLSQL_TRACE_LEVEL function, 167

GET_POSITION member function, 275, 275

GET_POST_PROCESSED_SOURCE Functions, 114

GET_PREFS Function, 147, 155

GET_PROCEDURE function, 219

GET_PROXY procedure, 252

GET_RAW function, 251, 265

GET_REC_ATTRIBUTES Procedure, 19

GET_REPLAY_DIRECTORY Function, 178

GET_REPLAY_INFO Function, 178

GET_REPLAY_TIMEOUT Procedure, 178

GET_REPORT Function, 17

GET_RESPONSE function, 252

GET_RESPONSE_ERROR_CHECK procedure, 252

GET_ROW_TEXT member procedure, 275

GET_ROWID function, 215

GET_ROWID_CHUNK Procedure, 107

GET_RUN_REPORT Function, 75

GET_RUNTIME_INFO function, 53

GET_SCHEME_NAMES function, 96

GET_SCN member function, 275

GET_SCN_FROM_POSITION static function, 275

GET_SCN_MAPPING procedure, 159

GET_SESSION_TIMEOUT function, 134

GET_SOURCE_DATABASE_NAME member function, 275

GET_SOURCE_TIME member function, 275

GET_SQL Function, 152

GET_SQL_HASH Function, 174

GET_SQLPATCH_STATUS, 118

GET_STATS_HISTORY_AVAILABILITY function, 155

GET_STATS_HISTORY_RETENTION function, 155

GET_STREAMS_NAME function, 158

GET_STREAMS_TYPE function, 158

GET_SYS_CONTEXT Function, 71

GET_SYSTEM_STATS procedure, 155

GET_TABLE_STATS procedure, 155

GET_TAG function, 158, 159, 204

GET_TAG member function, 275

GET_TASK_REPORT Procedure, 19

GET_TASK_SCRIPT Procedure, 19

GET_TDT_XML function, 96

GET_TEXT function, 265

GET_TEXT_NCHAR Function, 265

GET_THREAD_NUMBER member function, 275

GET_THRESHOLD procedure, 141

GET_TIME Function, 174

GET_TIMEOUT function, 134

GET_TIMEOUT_BEHAVIOUR function, 53

GET_TRANSACTION_ID member function, 275

GET_TRANSFER_TIMEOUT procedure, 252

GET_TZ_TRANSITIONS Procedure, 174

GET_USER_ID function, 217

GET_USERID function, 189

GET_VALIDATOR function, 96

GET_VALUE function, 53

GET_VALUE member function, 275, 283

GET_VALUE Procedure, 78

GET_VALUE_RAW Procedure, 78

GET_VALUES member function, 275

GET_VERSION procedure, 116

GET_WARNING_SETTING_CAT function, 175

GET_WARNING_SETTING_NUM function, 175

GET_WARNING_SETTING_STRING function, 175

GET_WATERMARK Procedure, 25

GET_WHERE_CLAUSE member procedure, 275

GET_X function, 214

GET_XML_INFORMATION member function, 275

GET_Y function, 214

GETACL Function, 187

GETACLDOCFROMRES Function, 187

GETACLDOCUMENT Function, 185

GETAPPLICATIONDATA Function, 190

GETATTRELEMINFO member function

of ANYTYPE TYPE, 270

GETATTRIBUTE function, 191

GETATTRIBUTENODE function, 191

GETATTRIBUTES function, 191

GETAUTHOR Function, 187

GETBASEDOCUMENT Function, 201

GETBLOB function, 273, 273, 273, 273

GETBLOBVAL function, 285

GETBUBLICID function, 191

GETCHARACTERSET Function, 187

GETCHARSET Function, 191

GETCHILDNODES function, 191

GETCHILDOID Function, 190

GETCHILDRENBYTAGNAME function, 191

GETCHUNKSIZE Functions, 88

GETCLOB function, 273, 273, 273, 273

GETCLOBVAL function, 285

GETCOMMENT Function, 187

GETCONTENTBLOB Function, 185, 187

GETCONTENTCLOB Function, 185, 187

GETCONTENTREF Function, 187

GETCONTENTSBLOBBYRESID function, 186

GETCONTENTSCLOBBYRESID function, 186, 186

GETCONTENTSXMLBYRESID function, 186

GETCONTENTTYPE function, 273, 273, 273, 273

GETCONTENTTYPE Function, 187

GETCONTENTTYPE Functions, 88

GETCONTENTVARCHAR2 Function, 185, 187

GETCONTENTXML Function, 187

GETCONTENTXMLREF Function, 185

GETCONTENTXMLTYPE Function, 185

GETCOUNT member function

of ANYDATASET TYPE, 269

GETCREATIONDATE Function, 187

GETCREATOR Function, 187

GETCURRENTUSER Function, 190

GETCUSTOMMETADATA Function, 187

GETDATA function, 191

GETDCHARSET function, 191

GETDEFAULTACL Procedure, 48

GETDEFAULTASOF Procedure, 48

GETDEFAULTOWNER Procedure, 48

GETDEFAULTPRINCIPAL Procedure, 48

GETDISPLAYNAME Function, 187

GETDOCTYPE function, 191, 194

GETDOCUMENT function, 194

GETDOCUMENTELEMENT function, 191

GETDTD function, 195

GETDTD procedure, 195

GETELEMENTSBYTAGNAME function, 191, 191

GETENTITIES function, 191

GETEVENT Function, 190

GETEXCEPTIONCONTENT procedure, 195, 196

GETEXPANDEDNAME function, 191, 191

GETEXPANDEDNAME procedure, 191

GETEXTERNALURL function, 273, 273, 273, 273

GETFEATURES Function, 49

GETFEATURESBYMOUNT Function, 48

GETFEATURESBYNAME Function, 48

GETFEATURESBYPATH Function, 48

GETFIRST Function, 190

GETFIRSTCHILD function, 191

GETFTPPORT Function, 183

GETHANDLERLIST Function, 190

GETHTTPCONFIGREALM Function, 183

GETHTTPPORT Function, 183

GETIMPLEMENTATION function, 191

GETINFO member function

of ANYTYPE TYPE, 270

GETINTERFACE Function, 190

GETLANGUAGE Function, 187, 190, 190

GETLASTCHILD function, 191

GETLASTMODIFIER Function, 187

GETLENGTH function, 191, 191, 191

GETLENGTH Functions, 88

GETLINK Function, 190

GETLINKNAME Function, 190

GETLISTENERENDPOINT Procedure, 183

GETLISTENERS Function, 130

GETLOCK Function, 190

GETLOCKTOKEN Procedure, 185

GETMODIFICATIONDATE Function, 187

GETNAME function, 191, 191

GETNAME Function, 190

GETNAMEDITEM function, 191

GETNAMESPACE function, 191, 191

GETNAMESPACE procedure, 191

GETNEXTSIBLING function, 191

GETNODENAME function, 191

GETNODETYPE function, 191

GETNODEVALUE function, 191

GETNODEVALUEASBINARYSTREAM Function & Procedure, 191

GETNODEVALUEASCHARACTERSTREAM Function & Procedure, 191

GETNOTATIONNAME function, 191

GETNOTATIONS function, 191

GETNUMBERVAL function, 285

GETNUMROWSPROCESSED function, 192

GETNUMROWSPROCESSED procedure, 195

GETOLDRESOURCE Function, 190

GETOPENACCESSMODE Function, 190

GETOPENDENYMODE Function, 190

GETOPTIONS Functions, 88

GETOUTPUTSTREAM Function, 190

GETOWNER Function, 187

GETOWNERDOCUMENT function, 191

GETOWNERELEMENT function, 191

GETPARAMETER Function, 190

GETPARENT Function, 190

GETPARENTNAME Function, 190

GETPARENTNODE function, 191

GETPARENTOID Function, 190

GETPARENTPATH Function, 190

GETPAT procedure, 216

GETPATH Function, 190

GETPATH Procedures, 48, 49

GETPATHBYMOUNTID Function, 48

GETPATHBYREPOSID Function, 49

GETPATHBYSTOREID Function, 48

GETPATHNOWAIT Procedure, 49

GETPATHNOWAIT Procedures, 48

GETPERSISTENT static function

of ANYTYPE TYPE, 270

GETPREDECESSORS function, 186

GETPREDSBYRESID function, 186

GETPREFIX function, 191

GETPREVIOUSSIBLING function, 191

GETPRIVILEGES Function, 185

GETPUBLICID function, 191, 191

GETQUALIFIEDNAME function, 191, 191

GETREFCOUNT Function, 187

GETRELEASEVERSION function, 194

GETREPOSITORYRESCONFIG Function, 130

GETREPOSITORYRESCONFIGPATHS Function, 130

GETRESCONFIG Function, 130

GETRESCONFIGPATHS Function, 130

GETRESOID Function, 185

GETRESOURCE Function, 190

GETRESOURCEBYRESID function, 186

GETROOTELEMENT function, 285

GETRUL function, 273

GETSCHEMA Function, 190

GETSCHEMAANNOTATIONS Function, 198

GETSCHEMANODE function, 191

GETSCHEMAURL function, 285

GETSIDXDEFFROMVIEW Function, 198

GETSOURCE Function, 190

GETSPECIFIED function, 191

GETSTANDALONE function, 191

GETSTATS Procedure, 48

GETSTOREBYMOUNT Function, 48

GETSTOREBYNAME Function, 48

GETSTOREBYPATH Function, 48

GETSTOREID Function, 49

GETSTOREPROPERTY Function, 50

GETSTRINGVAL function, 285

GETSUCCESSORS function, 186

GETSUCCSBYRESID function, 186

GETSYSTEMID function, 191, 191, 191

GETTAGNAME function, 191

GETTARGET function, 191

GETTDEFAULTCONTEXT Procedure, 48

GETTOKENTABLEINFO Procedure & Function, 41

GETTOKENTABLEINFOBYTABLESPACE Procedure, 41

GETTRACE Function, 48

GETTYPE member function

of ANYDATA TYPE, 268

of ANYDATASET TYPE, 269

GETTYPENAME member function

of ANYDATA TYPE, 268

of ANYDATASET TYPE, 269

GETUPDATEBYTECOUNT Function, 190

GETUPDATEBYTEOFFSET Function, 190

GETURL function, 273, 273, 273, 273

GETVALIDATIONMODE function, 194

GETVALUE function, 191

GETVERSION function, 191

GETVERSION Function, 48, 49

GETVERSION procedure, 195

GETVERSIONID Function, 187

GETXDB_TABLESPACE Function, 185

GETXDBEVENT Function, 190

GETXML function, 192, 195, 273, 273, 273, 273

GETXML procedure, 195

GETXMLTYPE function, 191, 192

GoldenGate

privileges, 72

GoldenGate administrator, 72

GRANT_ADMIN_PRIVILEGE procedure, 72, 161, 205

GRANT_OBJECT_PRIVILEGE procedure, 139

GRANT_REMOTE_ADMIN_ACCESS procedure, 161, 205

GRANT_SWITCH_CONSUMER_GROUP procedure, 132

GRANT_SYSTEM_PRIVILEGE procedure, 68, 132, 139

GRANTING_OBJECT_PRIVILEGE procedure, 68

---

H

HASACLCHANGED Function, 187

HASATTRIBUTE function, 191

HASAUTHORCHANGED Function, 187

HASBLOBCONTENT Function, 185

HASCHANGED Function, 187

HASCHARACTERSETCHANGED Function, 187

HASCHARCONTENT Function, 185

HASCHILDNODES function, 191

HASCOMMENTCHANGED Function, 187

HASCONTENTCHANGED Function, 187

HASCONTENTTYPECHANGED Function, 187

HASCREATIONDATECHANGED Function, 187

HASCREATORCHANGED Function, 187

HASCUSTOMMETADATACHANGED Function, 187

HASDISPLAYNAMECHANGED Function, 187

HASFEATURE function, 191

HASLANGUAGECHANGED Function, 187

HASLASTMODIFIERCHANGED Function, 187

HASMODIFICATIONDATECHANGED Function, 187

HASOWNERCHANGED Function, 187

HASREFCOUNTCHANGED Function, 187

HASVERSIONIDCHANGED Function, 187

HASXMLCONTENT Function, 185

HASXMLREFERENCE Function, 185

HEADCLOSE function

of HTF package, 207

HEADCLOSE procedure

of HTP package, 208

HEADER function

of HTF package, 207

HEADER procedure

of HTP package, 208

HEADOPEN function

of HTF package, 207

HEADOPEN procedure

of HTP package, 208

HELO function and procedure, 263

HELP function, 263

HR function

of HTF package, 207

HR procedure

of HTP package, 208

HTF package, 207

HTML tags

applet tags

functions, 207

procedures, 208

atags tags

procedures, 208

character formatting tags

functions, 207

procedures, 208

form tags

functions, 207

procedures, 208

frame tags

functions, 207

procedures, 208

list tags

functions, 207

procedures, 208

paragraph formatting tags

functions, 207

procedures, 208

table tags

functions, 207

HTMLCLOSE function

of HTF package, 207

HTMLCLOSE procedure

of HTP package, 208

HTMLDB_UTIL package documentation, 5

HTMLOPEN function

of HTF package, 207

HTMLOPEN procedure

of HTP package, 208

HTP package, 208

HTTP_HEADER_CLOSE procedure, 219

HttpUriType, 273

HTTPURITYPE function, 273

HttpUriType subtype, 273

CREATEURI function, 273

GETBLOB function, 273

GETCLOB function, 273

GETCONTENTTYPE function, 273

GETEXTERNALURL function, 273

GETRUL function, 273

GETXML function, 273

HTTPURITYPE function, 273

methods, 273

---

I

IMG function

of HTF package, 207

IMG procedure

of HTP package, 208

IMG2 procedure

of HTP package, 208

IMPLEMENT_EVOLVE_TASK Procedure, 148

IMPLEMENT_TASK Procedure, 19

IMPLEMENT_TUNING_TASK Function, 154

IMPORT_AWR Function, 178

IMPORT_AWR Procedure, 177

IMPORT_COLUMN_STATS procedure, 155

IMPORT_DATABASE_PREFS Procedure, 155

IMPORT_DATABASE_STATS procedure, 155

IMPORT_DICTIONARY_STATS procedure, 155

IMPORT_DISCOVERY_RESULT Procedure, 170

IMPORT_FIXED_OBJECTS_STATS procedure, 155

IMPORT_HISTORY Procedure, 71

IMPORT_INDEX_STATS procedure, 155

IMPORT_PROFILE Procedure, 150

IMPORT_SCHEMA_PREFS Procedure, 155

IMPORT_SCHEMA_STATS procedure, 155

IMPORT_SENSITIVE_TYPES Procedure, 170

IMPORT_SQL_TESTCASE Procedures, 152

IMPORT_SQLWKLD_SCHEMA Procedure, 19

IMPORT_SQLWKLD_SQLCACHE Procedure, 19

IMPORT_SQLWKLD_STS Procedure, 19

IMPORT_SQLWKLD_SUMADV Procedure, 19

IMPORT_SQLWKLD_USER Procedure, 19

IMPORT_SYSTEM_STATS procedure, 155

IMPORT_TABLE_PREFS Procedure, 155

IMPORT_TABLE_STATS procedure, 155

IMPORT_XML procedure, 42, 42

IMPORTNODE function, 191

inbound servers

DBMS_STREAMS_ADM package, 159

rules, 159

INCIDENTID_2_SQL Procedure, 152

INCLUDE_EXTRA_ATTRIBUTES procedure, 34

INDEX_TABLE_TYPE Table Type, 174

INDEXXMLREFERENCES Procedure, 199

INIT_CLEANUP procedure, 29

INITFS Procedure, 51

INITIALIZE function, 53

INITIALIZE procedure, 119

INITIALIZE_CONSOLIDATED_REPLAY Procedure, 178

INITIALIZE_CUBE_UPGRADE procedure, 42, 42, 42

INITIALIZE_REPLAY Procedure, 178

INPLACEEVOLVE Procedure, 197

INSERT_AUTOBIN_NUM_EQWIDTH procedure, 46

INSERT_BIN_CAT_FREQ procedure, 46

INSERT_BIN_NUM_EQWIDTH procedure, 46

INSERT_BIN_NUM_QTILE procedure, 46

INSERT_BIN_SUPER procedure, 46

INSERT_CLIP_TRIM_TAIL procedure, 46

INSERT_CLIP_WINSOR_TAIL procedure, 46

INSERT_FINDING_DIRECTIVE Procedure, 17

INSERT_MISS_CAT_MODE procedure, 46

INSERT_MISS_NUM_MEAN procedure, 46

INSERT_NORM_LIN_MINMAX procedure, 46

INSERT_NORM_LIN_SCALE procedure, 46

INSERT_NORM_LIN_ZSCORE procedure, 46

INSERT_PARAMETER_DIRECTIVE Procedure, 17

INSERT_SEGMENT_DIRECTIVE Procedure, 17

INSERT_SQL_DIRECTIVE Procedure, 17

INSERTBEFORE function, 191

INSERTDATA procedure, 191

INSERTXML function, 196, 200

INSTALLDEFAULTWALLET Function, 182

INSTANCE procedure, 84

INSTANCE_RECORD Record Type, 174

INSTANCE_TABLE Table Type, 174

instantiation

aborting database preparation, 34

aborting schema preparation, 34

aborting table preparation, 34

global SCN, 23

preparing a database for, 34

preparing a schema for, 34

preparing a table for, 34, 34

schema SCN, 23

table SCN, 23

INSTR Functions, 88

INTEGER_ARRAY Table Type, 143

INTERNAL_VERSION_CHECK function, 116

internet addressing

using UTL_INADDR, 254

INTERRUPT_ANALYSIS_TASK Procedure, 153

INTERRUPT_DIAGNOSIS_TASK Procedure, 152

INTERRUPT_EVOLVE_TASK Procedure, 148

INTERRUPT_TASK Procedure, 19

INTERRUPT_TUNING_TASK procedure, 154

INTERVAL procedure, 84

INTERVAL_DAY_TO_SECOND_TABLE, 149

INTERVAL_YEAR_TO_MONTH_TABLE Table Type, 149

INVALIDATE Functions & Procedures, 133

INVALIDATE Procedure, 174

INVALIDATE_OBJECT Functions & Procedures, 133

IS_BIT_SET Function, 174

IS_CLEANUP_INITIALIZED function, 29

IS_CLUSTER_DATABASE Function, 174

IS_FAST Procedure, 138

IS_GG_XSTREAM_FOR_STREAMS function, 204

IS_HIERARCHY_ENABLED function, 189

IS_LOCATOR function, 248

IS_NULL_TAG member function, 275

IS_OPEN function, 149, 251

IS_PATCH_INSTALLED Function, 118

IS_REPLAY_PAUSED Procedure, 178

IS_ROLE_ENABLED Function, 143

IS_SESSION_ALIVE Function, 143

IS_TRIGGER_FIRE_ONCE function, 54

ISFOLDER Function, 185, 187

ISFRAGMENT function, 285

ISINDEX function

of HTF package, 207

ISINDEX procedure

of HTP package, 208

ISNULL function, 191

ISNULL Function, 187, 190

ISOPEN function, 249

ISOPEN Functions, 88

ISSCHEMABASED function, 285

ISSCHEMAVALID function, 285

ISSCHEMAVALIDATED function, 285

ISTEMPORARY Functions, 88

ITALIC function

of HTF package, 207

ITALIC procedure

of HTP package, 208

ITEM Functions, 191

---

J

JARO_WINKLER Function, 258

JARO_WINKLER_SIMILARITY Function, 258

---

K

KBD function

of HTF package, 207

KBD procedure

of HTP package, 208

KEEP Procedure, 144

KEEP_COLUMNS member procedure, 275

KEEP_COLUMNS procedure, 159, 204

KEYBOARD function

of HTF package, 207

KEYBOARD procedure

of HTP package, 208

---

L

LAPACK Driver Routines (Linear Equations) Subprograms, 259

LAPACK Driver Routines (LLS and Eigenvalue Problems), 259

LAPACK_GBSV Procedures, 259

LAPACK_GEES Procedures, 259

LAPACK_GEEV Procedures, 259

LAPACK_GELS Procedures, 259

LAPACK_GESDD Procedures, 259

LAPACK_GESV Procedures, 259

LAPACK_GESVD Procedures, 259

LAPACK_GTSV Procedures, 259

LAPACK_PBSV Procedures, 259

LAPACK_POSV Procedures, 259

LAPACK_PPSV Procedures, 259

LAPACK_PTSV Procedures, 259

LAPACK_SBEV Procedures, 259

LAPACK_SBEVD Procedures, 259

LAPACK_SPEV Procedures, 259

LAPACK_SPEVD Procedures, 259

LAPACK_SPSV Procedures, 259

LAPACK_STEV Procedures, 259

LAPACK_STEVD Procedures, 259

LAPACK_SYEV Procedures, 259

LAPACK_SYEVD Procedures, 259

LAPACK_SYSV Procedures, 259

LAST_ERROR_POSITION function, 149

LAST_ROW_COUNT function, 149

LAST_ROW_ID function, 149

LAST_SQL_FUNCTION_CODE function, 149

LCR$_DDL_RECORD type, 275

LCR$_ROW_LIST type, 275

LCR$_ROW_RECORD type, 275

LCR$_ROW_UNIT type, 275

GET_LOB_INFORMATION member function, 275

GET_LOB_OPERATION_SIZE member procedure, 275

GET_LONG_INFORMATION member function, 275

GET_POSITION member function, 275

GET_ROOT_NAME member function, 275

GET_ROW_TEXT member procedure, 275

GET_WHERE_CLAUSE member procedure, 275

SET_LOB_INFORMATION member procedure, 275

SET_LOB_OPERATION_SIZE member procedure, 275

LCR_TO_XML Function, 98

LENGTH function, 260

LEXICAL_DEPTH Function, 247

LINE function

of HTF package, 207

LINE procedure

of HTP package, 208

LINK Procedures, 185

LINKREL function

of HTF package, 207

LINKREL procedure

of HTP package, 208

LINKREV function

of HTF package, 207

LINKREV procedure

of HTP package, 208

LIST Function, 48, 49

LIST_CONTEXT Procedures, 143

LISTALLCONTENT Function, 48

LISTALLPROPERTIES Function, 48

LISTHEADER function

of HTF package, 207

LISTHEADER procedure

of HTP package, 208

LISTINGCLOSE function

of HTF package, 207

LISTINGCLOSE procedure

of HTP package, 208

LISTINGOPEN function

of HTF package, 207

LISTINGOPEN procedure

of HTP package, 208

LISTITEM function

of HTF package, 207

LISTITEM procedure

of HTP package, 208

LISTMOUNTS Function, 48

LISTPRINT procedure, 219

LISTSTORES Function, 48

LNAME_ARRAY Table Type, 143, 174

LOAD_PLANS_FROM_CURSOR_CACHE Functions, 148

LOAD_PLANS_FROM_SQLSET Function, 148

LOAD_SQLSET procedure, 154

LOAD_SQLSET_FROM_TCB Function, 152

LOAD_TABLE procedure

of DBMS_HS_PARALLEL package, 77

LOADBLOBFROMFILE Procedure, 88

LOADCLOBFROMFILE Procedure, 88

LOADFROMFILE Procedure, 88

LOBs

DBMS_LOB package, 88

LOCAL_TRANSACTION_ID function, 168

LOCK_DOWN_APPLICATION Procedure, 71

LOCK_MAP procedure, 157

LOCK_OBJECT procedure, 262

LOCK_PARTITION_STATS Procedure, 155

LOCK_SCHEMA_STATS procedure, 155

LOCK_TABLE_STATS procedure, 155

LOCKPATH Procedure, 48, 49

LOCKRESOURCE Function, 185

log apply services

managing initialization parameters for logical standby databases, 92

logical change records (LCRs)

DDL LCRs, 275

getting base table name, 275

getting base table owner, 275

getting current schema, 275

getting edition name, 275

getting logon user name, 275

getting object type, 275

setting base table name, 275

setting base table owner, 275

setting current schema, 275

setting DDL text, 275

setting logon user, 275

setting object type, 275

determining if tag is NULL, 275

executing, 275, 275

extra attributes

excluding, 34

including, 34

GET_THREAD_NUMBER member function, 275

getting command type, 275

getting commit SCN, 275

getting commit SCN from position, 275

getting commit time, 275

getting compatibility information, 275

getting extra attributes, 275

getting LCR creation time, 275

getting object name, 275

getting object owner, 275

getting SCN, 275

getting SCN from position, 275

getting source database name, 275

getting tag, 275

getting transaction identifier, 275

LCR$_DDL_RECORD type, 275

LCR$_ROW_LIST type, 275

LCR$_ROW_RECORD type, 275

LCR$_ROW_UNIT type, 275

row LCRs, 275

adding value to column, 275

converting LONG to LOB, 275

deleting value to column, 275

getting column value, 275

getting list of column values, 275

getting LOB offset, 275

getting XML information, 275

keeping columns, 275

renaming column, 275

setting column value, 275

setting list of column values, 275

setting LOB offset, 275

setting XML information, 275

setting command type, 275

setting extra attributes, 275

setting object name, 275

setting object owner, 275, 275

setting source database name, 275

setting tag, 275

types, 275

logical standby databases

managing with DBMS_LOGSTDBY package, 92

logs

Cube Build, 44

Cube Dimension Compile, 44

Cube Operations, 44

Cube Rejected Records, 44

LZ_COMPRESS functions and procedures, 249

LZ_COMPRESS_ADD procedure, 249

LZ_COMPRESS_CLOSE procedure, 249

LZ_COMPRESS_OPEN function, 249

LZ_UNCOMPRESS functions and procedures, 249

LZ_UNCOMPRESS_CLOSE procedure, 249

LZ_UNCOMPRESS_EXTRACT procedure, 249

LZ_UNCOMPRESS_OPEN function, 249

---

M

MAIL function and procedure, 263

MAILTO function

of HTF package, 207

MAILTO procedure

of HTP package, 208

MAINTAIN_CHANGE_TABLE procedure, 159

MAINTAIN_GLOBAL procedure, 159

MAINTAIN_SCHEMAS procedure, 159

MAINTAIN_SIMPLE_TABLESPACE procedure, 159

MAINTAIN_SIMPLE_TTS procedure, 159

MAINTAIN_TABLES procedure, 159

MAINTAIN_TABLESPACES procedure, 159

MAINTAIN_TTS procedure, 159

MAKE_DATA_BLOCK_ADDRESS Function, 174

MAKEATTR function, 191

MAKECDATASECTION function, 191

MAKECHARACTERDATA function, 191

MAKECOMMENT function, 191

MAKEDOCUMENT function, 191

MAKEDOCUMENT Function, 187

MAKEDOCUMENTFRAGMENT function, 191

MAKEDOCUMENTTYPE function, 191

MAKEELEMENT function, 191

MAKEENTITY function, 191

MAKEENTITYREFERENCE function, 191

MAKENODE function, 191, 191, 191, 191

MAKENOTATION function, 191

MAKEPROCESSINGINSTRUCTION function, 191

MAKETEXT function, 191

MAKEVERSIONED function, 186

MAP_ALL function, 157

MAP_DAD Procedure, 65

MAP_ELEMENT function, 157

MAP_FILE function, 157

MAP_OBJECT function, 157

MAPCLOSE function

of HTF package, 207

MAPCLOSE procedure

of HTP package, 208

MAPOPEN function

of HTF package, 207

MAPOPEN procedure

of HTP package, 208

MARK_RECOMMENDATION Procedure, 19

MARKHOT Procedure, 144

MATCH function, 216

MATERIALIZE_DEFERRED_SEGMENTS Procedure, 146

materialized view logs

master table

purging, 100, 100, 100

materialized views

comparing, 35

converting from table- to cube-organized, 42

optimizing cube organized, 43

refreshing, 100, 100, 100

materialized views (cube organized), 42

MEMORY_REPORT Procedure, 133

MENULISTCLOSE function

of HTF package, 207

MENULISTCLOSE procedure

of HTP package, 208

MENULISTOPEN function

of HTF package, 207

MENULISTOPEN procedure

of HTP package, 208

merge streams, 159, 159, 204, 204

MERGE_COL_USAGE Procedure, 155

MERGE_STREAMS procedure, 159, 204

MERGE_STREAMS_JOB procedure, 159, 204

MERGEXLIFF Functions, 201

MESSAGE_PROPERTIES_ARRAY_T Type, 271

MESSAGE_PROPERTIES_T Type, 271

messaging client

messaging client user, 159

rules

for LCRs, 159

for user messages, 159

META function

of HTF package, 207

META procedure

of HTP package, 208

MG2 function

of HTF package, 207

MGD_ID constructor function, 282

MGD_ID object type, 282

FORMAT function, 282

GET_COMPONENT function, 282

MGD_ID constructor function, 282

TO_STRING function, 282

TRANSLATE function, 282

MGD_ID object types, 282

MGD_ID_COMPONENT object type, 282

MGD_ID_COMPONENT_VARRAY object type, 282

MIGRATE_STORED_OUTLINE Function, 148

MIME_HEADER procedure, 219

MIMEHEADER_DECODE function, 250

MIMEHEADER_ENCODE function, 250

model transparency, 46

MODIFY_BASELINE_WINDOW_SIZE Procedure, 179

MODIFY_PACKAGE_STATE Procedure, 143

MODIFY_SERVICE Procedure, 142

MODIFY_SNAPSHOT_SETTINGS procedure, 179

MODIFY_TRANSFORMATION procedure, 169

MODIFYPARAMETER Procedure, 193

MOUNT_T Record Type, 48

MOUNTS_T Table Type, 48

MOUNTSTORE Procedure, 48

MOVE_TO_DBFS_LINK Procedures, 88

MOVEXDB_TABLESPACE Procedure, 182

MSGID_ARRAY_T Type, 271

MV_CUBE_ADVICE function, 43

---

N

NAME_ARRAY Table Type, 174

NAME_RESOLVE Procedure, 174

NAME_TOKENIZE Procedure, 174

NAMELIST Table Type, 148

NAMESPACE function, 285

NAMESPACE_ACL Function, 184

NAMESPACE_METADATA Function, 184

NAMESPACE_ORACLE Function, 184

NAMESPACE_RESOURCE Function, 184

NAMESPACE_RESOURCE_CONFIG Function, 184

NAMESPACE_RESOURCE_EVENT Function, 184

NAMESPACE_XDBSCHEMA Function, 184

NAMESPACE_XMLDIFF Function, 184

NAMESPACE_XMLINSTANCE Functio, 184

NAMESPACE_XMLSCHEMA Function, 184

NAMESPACEIDTABLE Procedure, 41

NEW_LINE procedure, 106, 251

NEW_ROW_LIST function and procedure, 218

NEWCONTEXT function, 192, 195, 196, 200

NEWCONTEXTFROMHIERARCHY Function, 192

NEWDOMDOCUMENT function, 191

NEWPARSER function, 194

NEWPROCESSOR function, 203

NEWSTYLESHEET function, 203

NEXT_DATE procedure, 84

NEXT_ITEM_TYPE function, 112

NL function

of HTF package, 207

NL procedure

of HTP package, 208

NOBR function

of HTF package, 207

NOBR procedure

of HTP package, 208

NOFRAMESCLOSE function

of HTF package, 207

NOFRAMESCLOSE procedure

of HTP package, 208

NOFRAMESOPEN function

of HTF package, 207

NOFRAMESOPEN procedure

of HTP package, 208

NOOP function and procedure, 263

NOOP Functions, 28

NORMAL function, 119

NORMAL_DIST_FIT procedure, 156

NORMALIZE procedure, 191

NORMALIZEPATH Functions, 48

NSPREFIX_ACL_ACL Function, 184

NSPREFIX_RESCONFIG_RC Function, 184

NSPREFIX_RESOURCE_R Function, 184

NSPREFIX_XDB_XDB Function, 184

NSPREFIX_XMLDIFF_XD Function, 184

NSPREFIX_XMLINSTANCE_XSI Function, 184

NSPREFIX_XMLSCHEMA_XSD Functio, 184

NUMBER_ARRAY Table Type, 174

NUMBER_TABLE Table Type, 149

NVARRAY_ADD Procedure, 98

NVARRAY_FIND_NAME Function, 98

NVARRAY_FIND_NAME_TYPE Function, 98

NVARRAY_GET Function, 98

NVARRAY_GET_BOOLEAN, 98

NVARRAY_GET_BYTE, 98

NVARRAY_GET_DATE Function, 98

NVARRAY_GET_DOUBLE Function, 98

NVARRAY_GET_FLOAT Function, 98

NVARRAY_GET_INTEGER, 98

NVARRAY_GET_LONG Function, 98

NVARRAY_GET_RAW Function, 98

NVARRAY_GET_SHORT, 98

NVARRAY_GET_TEXT Function, 98

---

O

OBJECT_DEPENDENT_SEGMENTS function, 145

OBJECT_GROWTH_TREND function, 145

OBJECT_HEAT_MAP Procedure, 74

ogical change records (LCRs)

tracking, 159, 159, 204

OLAP aggregation operators, 42

OLAP logs

Cube Build, 44

Cube Dimension Compile, 44

Cube Operations, 44

Cube Rejected Records, 44

OLAP metadata

upgrading OLAP 10g to OLAP 12c, 42

OLAP PL/SQL packages

DBMS_AW_STATS, 33

DBMS_CUBE, 42

DBMS_CUBE_ADVISE, 43

DBMS_CUBE_LOG, 44

OLAP templates

validation, 42

writing to XML files, 42

OLAP_DBA role, 42

OLAP_USER role, 42, 42

OLD_CURRENT_SCHEMA Function, 174

OLD_CURRENT_USER Function, 174

OLISTCLOSE function

of HTF package, 207

OLISTCLOSE procedure

of HTP package, 208

OLISTOPEN function

of HTF package, 207

OLISTOPEN procedure

of HTP package, 208

ONLINE_INDEX_CLEAN Function, 124

OPEN Procedures, 88

OPEN_CONNECTION function, 265

OPEN_CONNECTION functions, 263

OPEN_CURSOR function, 149

OPEN_CURSOR Function, 78

OPEN_DATA function and procedure, 263

OPEN_WINDOW Procedure

OPEN_WINDOW Procedure, 140

optimizer statistics, 33

OR REPLACE clause

for creating packages, 1

Oracle Data Mining, 45

Oracle Streams

administrator

granting privileges, 161

revoking privileges, 161

advisors, 160

change data capture

configuring, 159

compatibility, 158, 158, 158, 158, 158, 158, 275

creating queues, 159

data dictionary

removing information, 159

messaging

notification, 159

privileges, 161

replication

configuring, 159, 159, 159, 159, 159, 159, 159, 159

Oracle XStream

creating queues, 204

data dictionary

removing information, 204

Oracle-supplied types

logical change record (LCR) types, 275

rule types, 283

ORD_DICOM package documentation, 209

ORD_DICOM_ADMIN package documentation, 210

outbound servers

rules, 159

OVERLAY function, 260

OVERRIDE_PRIORITY Procedures, 32

OWA_CACHE package, 211

OWA_COOKIE package, 212

OWA_CUSTOM package, 213

OWA_IMAGE package, 214

OWA_OPT_LOCK package, 215

OWA_PATTERN package, 216

OWA_SEC package, 217

OWA_TEXT package, 218

OWA_UTIL package, 219

OWNER Function, 247

---

P

PACK_MESSAGE procedures, 112

PACK_STGTAB_BASELINE Function, 148

PACK_STGTAB_DIRECTIVE Function, 147

PACK_STGTAB_SQLPATCH Procedure, 152

PACK_STGTAB_SQLPROF Procedure, 154

PACK_STGTAB_SQLSET Procedure, 154

package

DBMS_ODCI, 103

DBMS_XDB, 181

DBMS_XMLDOM, 191

DBMS_XMLGEN, 192

DBMS_XMLPARSER, 194

DBMS_XMLQUERY, 195

DBMS_XMLSAVE, 196

DBMS_XMLSCHEMA, 197

UriFactory, 273

Package - UriFactory, 273

package overview, 1

package variables

i_am_a_refresh, 100

packages

creating, 1

DBMS_MGD_ID_UTL, 96

referencing, 1

where documented, 1

PARA function

of HTF package, 207

PARA procedure

of HTP package, 208

PARAGRAPH function

of HTF package, 207

PARAGRAPH procedure

of HTP package, 208

PARAM function

of HTF package, 207

PARAM procedure

of HTP package, 208

PARSE procedure, 149, 194

PARSE Procedure, 78

PARSEBUFFER procedure, 194

PARSECLOB procedure, 194

PARSEDTD procedure, 194

PARSEDTDBUFFER procedure, 194

PARSEDTDCLOB procedure, 194

PATCH_CONFLICT_DETECTION Function, 118

PATCHREPOSITORYRESCONFIGLIST Procedure, 130

PATH_ITEM_T Record Type, 48

PATH_ITEMS_T Table Type, 48

PATHIDTABLE Function, 41

PAUSE_PROFILER function and procedure, 116

PAUSE_REPLAY Procedure, 178

PIECEWISE member procedure

of ANYDATA TYPE, 268

of ANYDATASET TYPE, 269

PING procedure, 53

PLAINTEXT function

of HTF package, 207

PLAINTEXT procedure

of HTP package, 208

plan stability, 105

PL/SQL

datatypes, 58

numeric codes for, 58

functions

DBMS_MGWADM package subprograms, 97

DBMS_MGWMSG package subprograms, 98

procedures

DBMS_MGWADM package subprograms, 97

DBMS_MGWMSG package subprograms, 98

PL/SQL package

DBMS_HS_PARALLEL, 77

PLSQL_TRACE_VERSION procedure, 167

pointer to

CTX_ADM package, 6

CTX_ANL package, 7

point-in-time recovery

Oracle Streams, 159

POISSON_DIST_FIT procedure, 156

POLICY_CONDITION Table Type, 171

POPULATE Procedure, 81

POPULATE_DIVERGENCE Procedure, 178

PORT_STRING Function, 174

POST_INSTANTIATION_SETUP procedure, 159

PRE_INSTANTIATION_SETUP procedure, 159

PRECLOSE function

of HTF package, 207

PRECLOSE procedure

of HTP package, 208

predictive analytics, 113

PREOPEN function

of HTF package, 207

PREOPEN procedure

of HTP package, 208

PREPARE Procedure, 178

PREPARE_COLUMN_VALUES procedures, 155, 155

PREPARE_COLUMN_VALUES_NVARCHAR2 procedure, 155

PREPARE_COLUMN_VALUES_ROWID procedure, 155

PREPARE_CONSOLIDATED_REPLAY Procedure, 178

PREPARE_GLOBAL_INSTANTIATION procedure, 34

PREPARE_SCHEMA_INSTANTIATION procedure, 34

PREPARE_SYNC_INSTANTIATION function, 34

PREPARE_TABLE_INSTANTIATION procedure, 34

PREVIEW_ILM Procedure, 79

PRINT function

of HTF package, 207

PRINT procedure

of HTP package, 208

PRINT_BACKTRACE procedure, 53

PRINT_CGI_ENV procedure, 219

PRINT_INSTANTIATIONS procedure, 53

PRINT_MULTI procedure, 218

PRINT_POST_PROCESSED_SOURCE Procedure, 114

PRINT_ROW_LIST procedure, 218

PRINTS procedure

of HTP package, 208

PRINTWARNINGS Procedur, 198

privileges

GoldenGate administrator, 72, 72

Oracle Streams administrator, 161, 161

XStream administrator, 205, 205

PRN function

of HTF package, 207

PRN procedure

of HTP package, 208

PROBE_VERSION procedure, 53

PROCESS_CAPTURE Procedure, 178

PROCESS_PENDING Procedure, 193

PROCESSLINKS Procedure, 185

PROCESSXSL function, 203

PROGRAM_INFO Record Type, 53

PROP_ITEM_T Record Type, 48

PROP_ITEMS_T Table Type, 48

PROPAGATEORIGINALEXCEPTION procedure, 195, 196

propagations

altering, 117

creating, 117, 159, 159, 159, 159, 159, 204, 204, 204, 204

DBMS_PROPAGATION_ADM package, 117

dropping, 117

propagation user, 159

rules

defining global, 159, 204

defining message, 159

defining schema, 159, 204

defining subset, 159, 204

defining table, 159, 204

for LCRs, 159

for user messages, 159

starting, 117

stopping, 117

PROPANY Functions, 48

PROPERTIES_T Table Type, 48

PROPERTIESH2T Function, 48

PROPERTIEST2H Function, 48

PROPERTY_T Record Type, 48

PROPNUMBER Function, 48

PROPRAW Function, 48

PROPTIMESTAMP Function, 48

PROPVARCHAR2 Function, 48

PS procedure

of HTP package, 208

PUBLISH_PENDING_STATS Procedure, 155

PULL_SIMPLE_TABLESPACE procedure, 164

PULL_TABLESPACES procedure, 164

PURGE procedure, 112

PURGE Procedure, 144

PURGE_COMPARISON Procedure, 35

PURGE_CONTEXT Procedure, 71

PURGE_FILE_GROUP procedure, 68

PURGE_LOST_DB_ENTRY procedure, 168

PURGE_MIXED procedure, 168

PURGE_PROCESSED_CHUNKS Procedure, 107

PURGE_QUEUE_TABLE Procedure, 25

PURGE_SOURCE_CATALOG procedure, 159, 204

PURGE_SQL_DETAILS Procedure, 179

PURGE_STATS procedure, 155

PURGEALL Procedure, 48, 49

PURGELDAPCACHE function, 189

PURGEPATH Procedure, 48, 49

PURGERESOURCEMETADATA Procedure, 185

PURGESCHEMA Procedure, 197

PUT procedure, 251

PUT procedures, 106

PUT_FILE procedure, 69

PUT_LINE Procedure, 251

PUT_LINE procedures, 106

PUT_LINE_NCHAR procedure, 251

PUT_NCHAR procedure, 251

PUT_RAW function, 251

PUTF procedure, 251

PUTF_NCHAR procedure, 251

PUTPATH Procedures, 48, 49

---

Q

QNAMEIDTABLE Function, 41

QUALIFIED_SQL_NAME Function, 28

queues

AnyData

creating, 159, 204

removing, 159, 204

QUICK_TUNE Procedure, 19

QUIT function and procedure, 263

QUOTED_PRINTABLE_DECODE function, 250

QUOTED_PRINTABLE_ENCODE function, 250

---

R

RANDOM procedure, 119

RCPT function, 263

RE$ATTRIBUTE_VALUE type, 283

RE$ATTRIBUTE_VALUE_LIST type, 283

RE$COLUMN_VALUE type, 283, 283

RE$COLUMN_VALUE_LIST type, 283

RE$NAME_ARRAY type, 283

RE$NV_ARRAY type, 283

RE$NV_LIST type, 283

ADD_PAIR member procedure, 283

GET_ALL_NAMES member function, 283

GET_VALUE member function, 283

REMOVE_PAIR member procedure, 283

RE$RULE_HIT type, 283

RE$RULE_HIT_LIST type, 283

RE$TABLE_ALIAS type, 283

RE$TABLE_ALIAS_LIST type, 283

RE$TABLE_VALUE type, 283

RE$TABLE_VALUE_LIST type, 283

RE$VARIABLE_TYPE type, 283

RE$VARIABLE_TYPE_LIST type, 283

RE$VARIABLE_VALUE type, 283

RE$VARIABLE_VALUE_LIST type, 283

READ Procedures, 88

READ_CLIENT_INFO procedure, 22

READ_LINE function, 265

READ_LINE procedure

of UTL_HTTP, 252

READ_MODULE procedure, 22

READ_ONLY procedure, 168

READ_RAW function, 265

READ_RAW procedure

of UTL_HTTP, 252

READ_TEXT function, 265

READ_TEXT procedure

of UTL_HTTP, 252

READ_WRITE procedure, 168

READ2CLOB function, 203

REAL_TIME_ADDM_REPORT Function, 17

Real-time SQL Monitoring Subprograms, 154

REASSOCIATE_FBA Procedure, 71

REBUILD_FREELISTS procedure, 124

REBUILDHIERARCHICALINDEX Procedure, 182

RECEIVE_MESSAGE function, 112

RECHECK Function, 35

RECOMP_PARALLEL procedure, 261

RECOMP_SERIAL procedure, 261

RECONFIGCACHE Procedure, 50

RECOVER_OPERATION procedure, 204

REDEF_TABLE Procedure, 122

REDIRECT_URL procedure, 219

refresh

materialized views, 100, 100, 100

REFRESH_CATEGORY function, 96

REFRESH_GROUPED_POLICY Procedure, 135

REFRESH_MVIEW procedure, 42, 42

REFRESH_POLICY Procedure, 135

REGISTER Procedure, 20

REGISTER_APPLICATION Procedure, 71

REGISTER_DEPENDENT_OBJECT procedure, 122

REGISTER_ERROR_TRANSLATION Procedure, 150

REGISTER_FOREIGN_QUEUE Procedure, 97

REGISTER_SQL_TRANSLATION Procedure, 150

REGISTERPARAMETER Procedure, 193

REGISTERSCHEMA procedure, 197

REGISTERSTORE Procedure, 48

REGISTERSTORECOMMAND Procedur, 50

REGISTERURI procedure, 197

REGISTERURLHANDLER procedure, 273

RELEASE function, 89

REMAP_CONNECTION Procedure, 178

REMAP_STAT_TABLE Procedure, 155

REMAP_STGTAB_SQLPROF Procedure, 154

REMAP_STGTAB_SQLSET Procedure, 154

REMOVE procedure

of DBMS_ALERT package, 20

of DBMS_JOB package, 84

of OWA_COOKIE package, 212

REMOVE Procedure, 190

REMOVE_AGENT Procedure, 97

REMOVE_CAPTURE Procedure, 178

REMOVE_CATEGORY procedure, 96

REMOVE_COLORED_SQL Procedure, 179

REMOVE_DISCOVERY_RESULT Procedure, 170

REMOVE_FILE procedure, 68

REMOVE_FROM_ILM Procedure, 79

REMOVE_HOST_ACE Procedure, 101

REMOVE_JOB Procedure, 97

REMOVE_MSGSYSTEM_LINK Procedure, 97

REMOVE_OPTION Procedure, 97

REMOVE_PAIR member procedure, 283

REMOVE_PIPE function, 112

REMOVE_PROXY procedure, 96

REMOVE_QUEUE procedure, 159, 204

REMOVE_RULE procedure, 139, 159, 204

REMOVE_SCHEDULE_ORDERING Procedure, 178

REMOVE_SCHEME procedure, 96

REMOVE_SQLSET_REFERENCE procedure, 154

REMOVE_STMT_FROM_HANDLER procedure, 162

REMOVE_STMT_HANDLER procedure, 23

REMOVE_STREAMS_CONFIGURATION procedure, 159

REMOVE_SUBSCRIBER Procedure, 97

REMOVE_SUBSET_OUTBOUND_RULES procedure, 204

REMOVE_TABLE_FROM_APPLICATION, 71

REMOVE_WALLET_ACE Procedure, 101

REMOVE_XSTREAM_CONFIGURATION procedure, 204

REMOVEALL procedure, 20

REMOVEANYSTORAGE Procedure, 198

REMOVEATTRIBUTE procedure, 191

REMOVEATTRIBUTENODE function, 191

REMOVEDEFAULTTABLE Procedure, 198

REMOVEMAINTAINDOM Procedure, 198

REMOVENAMEDITEM function, 191

REMOVEOUTOFLINE Procedure, 198

REMOVEPARAM procedure, 203

REMOVESQLCOLLTYPE Procedure, 198

REMOVESQLNAME Procedure, 198

REMOVESQLTYPE Procedure, 198

REMOVESQLTYPEMAPPING Procedure, 198

REMOVETABLEPROPS Procedure, 198

REMOVETIMESTAMPWITHTIMEZONE Procedure, 198

REMOVEXSLTPARAM procedure, 195, 196

RENAME_BASELINE Procedure, 179

RENAME_COLUMN member procedure, 275

RENAME_COLUMN procedure, 159, 204

RENAME_SCHEMA procedure, 159, 204

RENAME_TABLE procedure, 159, 204

RENAMECOLLECTIONTABLE Procedure, 199

RENAMEPATH Procedure, 49

RENAMEPATH Procedures, 48

RENAMERESOURCE Procedure, 185

REPLACECHILD function, 191

REPLACEDATA procedure, 191

REPLAY_SQL_TESTCASE Procedure, 152

replication

Oracle Streams

configuring, 159, 159, 159, 159, 159, 159, 159, 159

split and merge, 159, 159, 159, 204, 204, 204

REPLY, REPLIES record types, 263

REPOPULATE Procedure, 81

REPORT Function, 177, 178

REPORT_ANALYSIS_TASK Function, 153

REPORT_AUTO_EVOLVE_TASK Function, 148

REPORT_AUTO_TUNING_TASK Function, 154

REPORT_COL_USAGE Procedure, 155

REPORT_DIAGNOSIS_TASK Function, 152

REPORT_EVOLVE_TASK Function, 148

REPORT_GATHER_AUTO_STATS Function, 155

REPORT_GATHER_DATABASE_STATS Functions, 155

REPORT_GATHER_DICTIONARY_STATS Functions, 155

REPORT_GATHER_FIXED_OBJ_STATS Function, 155

REPORT_GATHER_SCHEMA_STATS Functions, 155

REPORT_GATHER_TABLE_STATS Function, 155

REPORT_PERFHUB Procedure, 111

REPORT_REPOSITORY_DETAIL Function, 31

REPORT_REPOSITORY_DETAIL_XML Function, 31

REPORT_REPOSITORY_LIST_XML Procedure, 31

REPORT_SESSION Function, 111

REPORT_SINGLE_STATS_OPERATION Function, 155

REPORT_SQL_DETAIL Function, 154

REPORT_SQL_MONITOR Function, 151, 154

REPORT_SQL_MONITOR_LIST Function, 151, 154

REPORT_STATS_OPERATIONS Function, 155

REPORT_TUNING_TASK function, 30, 154

REQUEST function, 89, 252

REQUEST_PIECES function, 252

RESET_ANALYSIS_TASK Procedure, 153

RESET_BUFFER procedure, 112

RESET_DIAGNOSIS_TASK Procedure, 152

RESET_EVOLVE_TASK Procedure, 148

RESET_GLOBAL_PREFS_DEFAULTS Procedure, 155

RESET_JOB Procedure, 97

RESET_PACKAGE Procedure, 143

RESET_PARAM_DEFAULTS Procedure, 155

RESET_SQLWKLD Procedure, 19

RESET_SUBSCRIBER Procedure, 97

RESET_TASK Procedure, 19

RESET_TUNING_TASK procedure, 154

RESETPARAMS procedure, 203

RESOLVENAMESPACEPREFIX function, 191

RESTARTQUERY procedure, 192

RESTORE function, 157

RESTORE_DATBASE_STATS procedure, 155

RESTORE_DEFAULTS Procedure, 37

RESTORE_DICTIONARY_STATS procedure, 155

RESTORE_FIXED_OBJECTS_STATS procedure, 155

RESTORE_SCHEMA_STATS procedure, 155

RESTORE_SYSTEM_STATS procedure, 155

RESTORE_TABLE_STATS procedure, 155

RESTOREALL Procedure, 48, 49

RESTOREPATH Procedure, 48, 49

RESUME_ANALYSIS_TASK Procedure, 153

RESUME_DIAGNOSIS_TASK Procedure, 152

RESUME_EVOLVE_TASK Procedure, 148

RESUME_PROFILER function and procedure, 116

RESUME_REPLAY Procedure, 178

RESUME_TASK Procedure, 107

RESUME_TUNING_TASK Procedure, 154

RETURN_RESULT Procedures, 149

REUSE_REPLAY_FILTER_SET Procedure, 178

REVERSE function, 260

REVOKE_ADMIN_PRIVILEGE procedure, 72, 161, 205

REVOKE_OBJECT_PRIVILEGE procedure, 68, 139

REVOKE_REMOTE_ADMIN_ACCESS procedure, 161, 205

REVOKE_SWITCH_CONSUMER_GROUP procedure, 132

REVOKE_SYSTEM_PRIVILEGE procedure, 68, 132, 139

ROLLBACK procedure, 168

ROLLBACK_FORCE procedure, 168

ROLLBACK_SAVEPOINT procedure, 168

row migration, 159, 159, 204, 204

ROWID datatype

extended format, 137

ROWID_BLOCK_NUMBER function, 137

ROWID_CREATE function, 137

ROWID_INFO procedure, 137

ROWID_OBJECT function, 137

ROWID_RELATIVE_FNO function, 137

ROWID_ROW_NUMBER function, 137

ROWID_TO_ABSOLUTE_FNO function, 137

ROWID_TO_EXTENDED function, 137

ROWID_TO_RESTRICTED function, 137

ROWID_TYPE function, 137

ROWID_VERIFY function, 137

rule sets

adding rules to, 139

creating, 139

dropping, 139

removing rules from, 139

rule-based transformations

setting, 159

rules

action contexts

adding name-value pairs, 283

getting name-value pairs, 283

getting value for name, 283

removing name-value pairs, 283

transformations, 159

altering, 139

creating, 139

DBMS_RULE package, 138

DBMS_RULE_ADM package, 139

dropping, 139

evaluation, 138

iterators, 138, 138

evaluation contexts

altering, 139

creating, 139

dropping, 139

fast evaluation, 138

inbound servers, 159

object privileges

granting, 139

revoking, 139

outbound servers, 159

propagations

removing, 159, 204

RE$ATTRIBUTE_VALUE type, 283

RE$ATTRIBUTE_VALUE_LIST type, 283

RE$COLUMN_VALUE type, 283, 283

RE$COLUMN_VALUE_LIST type, 283

RE$NAME_ARRAY type, 283

RE$NV_ARRAY type, 283

RE$NV_LIST type, 283

RE$RULE_HIT type, 283

RE$RULE_HIT_LIST type, 283

RE$TABLE_ALIAS type, 283

RE$TABLE_ALIAS_LIST type, 283

RE$TABLE_VALUE type, 283

RE$TABLE_VALUE_LIST type, 283

RE$VARIABLE_TYPE type, 283

RE$VARIABLE_TYPE_LIST type, 283

RE$VARIABLE_VALUE type, 283

RE$VARIABLE_VALUE_LIST type, 283

subset

defining, 159, 159, 204, 204

system privileges

granting, 139

revoking, 139

system-created, 159

global apply, 159, 204

global capture, 159, 204

global propagation, 159, 204

global schema, 159, 204

message, 159, 159

message propagation, 159

removing, 159, 204

schema capture, 159, 204

schema propagation, 159, 204

subset apply, 159, 204

subset capture, 159, 204

subset propagation, 159, 204

table apply, 159, 204

table capture, 159, 204

table propagation, 159, 204

types, 283

RUN procedure, 84

RUN_CHECK Procedure, 75

RUN_TASK Procedure, 107

RUNTIME_INFO Record Type, 53

---

S

S function

of HTF package, 207

S procedure

of HTP package, 208

SAM (SQL Aggregation Management), 42

SAMPLE function

of HTF package, 207

SAMPLE procedure

of HTP package, 208

SAVE function, 157

SAVE Procedure, 187

SAVEPOINT procedure, 168

SCHEDULE_PROPAGATION Procedure, 25, 97

SCHEMA_NAME Function, 28

SCHEMAELEM_RES_ACL Function, 184

SCHEMAELEM_RESCONTENT_BINARY Function, 184

SCHEMAELEM_RESCONTENT_TEXT Function, 184

SCHEMAURL_ACL Function, 184

SCHEMAURL_RESOURCE Function, 184

SCHEMAURL_XDBSCHEMA Function, 184

SCHEMAVALIDATE procedure, 285

SCOPEXMLREFERENCES Procedure, 199

SCRIPT function

of HTF package, 207

SCRIPT procedure

of HTP package, 208

SCRIPT_TUNING_TASK Function, 154

SDO_CS package documentation, 220

SDO_CSW_PROCESS package documentation, 221

SDO_GCDR package documentation, 222

SDO_GEOM package documentation, 223

SDO_GEOR package documentation, 224

SDO_GEOR_ADMIN package documentation, 225

SDO_GEOR_UTL package documentation, 228

SDO_LRS package documentation, 229

SDO_MIGRATE package documentation, 230

SDO_NET package documentation, 231

SDO_OLS package documentation, 232

SDO_PC_PKG package documentation, 233

SDO_SAM package documentation, 234

SDO_TIN_PKG package documentation, 235

SDO_TOPO package documentation, 236

SDO_TOPO_MAP package documentation, 237

SDO_TUNE package documentation, 238

SDO_UTIL package documentation, 239

SDO_WFS_LOCK package documentation, 240

SDO_WFS_PROCESS package documentation, 241

SEARCH Function, 49

SECURE_CONNECTION Procedure, 265

security

XStream, 204

SEED procedures, 119

SEED_COL_USAGE Procedures, 155

SEGMENT_CORRUPT procedure, 146

SEGMENT_DROP_CORRUPT procedure, 146

SEGMENT_DUMP procedure, 146

SEGMENT_FIX_STATUS procedure, 124

SEGMENT_HEAT_MAP Procedure, 74

SEGMENT_VERIFY procedure, 146

SELECT_BASELINE_METRIC Function, 179

SELECT_CURSOR_CACHE Function, 154

SELECT_OBJECT procedure, 262

SELECT_SQL_TRACE Function, 154

SELECT_SQLSET function, 154, 154, 154, 154

SELECT_WORKLOAD_REPOSITORY functions, 154

SELECTNODES function, 203

SELECTSINGLENODE function, 203

SELF_CHECK procedure, 53

SEM_APIS package documentation, 242

SEM_PERF package documentation, 244

SEM_RDFSA package documentation, 245, 246

SEND procedure, 212, 257

SEND_ATTACH_RAW procedure, 257

SEND_ATTACH_VARCHAR2 procedure, 257

SEND_MESSAGE function, 112

SENDCOMMAND Procedures, 50

SERV_MOD_ACT_STAT_DISABLE procedure, 99

SERV_MOD_ACT_STAT_ENABLE procedure, 99

SERV_MOD_ACT_TRACE_DISABLE procedure, 99

SERV_MOD_ACT_TRACE_ENABLE procedure, 99

SESSION _TRACE_DISABLE Procedure, 143

SESSION _TRACE_ENABLE Procedur, 143

SESSION_TRACE_DISABLE procedure, 99

SESSION_TRACE_ENABLE procedure, 99

SET* member procedures

of ANYDATA TYPE, 268

of ANYDATASET TYPE, 269

SET_ACTION procedure, 22

SET_ADVANCED_PARAMETER Procedure, 178

SET_ANALYSIS_DEFAULT_PARAMETER Procedures, 153

SET_ANALYSIS_TASK_PARAMETER Procedure, 153

SET_ATTRIBUTE Procedure, 150

SET_AUDIT_TRAIL_LOCATION procedure, 29

SET_AUDIT_TRAIL_PROPERTY procedure, 29

SET_AUTHENTICATION procedure, 252

SET_AUTHENTICATION_FROM_WALLET Procedure, 252

SET_AUTHORIZATION procedure, 217

SET_AUTO_TUNING_TASK_PARAMETER Procedures, 30

SET_BASE_TABLE_NAME member procedure, 275

SET_BASE_TABLE_OWNER member procedure, 275

SET_BODY_CHARSET procedures, 252, 252

SET_BREAKPOINT function, 53

SET_CHANGE_HANDLER procedure, 23

SET_CHUNK_STATUS Procedure, 107

SET_CLIENT_INFO procedure, 22

SET_CLIENT_SERVICE Procedure, 32

SET_CNS_EXCEPTION_LOG procedure, 43

SET_COLUMN_STATS procedures, 155

SET_COMMAND_TYPE member procedure, 275

SET_CONSUMER_GROUP_MAPPING procedure, 131

SET_CONSUMER_GROUP_MAPPING_PRI procedure, 131

SET_CONTEXT Procedure, 143

SET_CONTEXT_LEVEL Procedure, 71

SET_COOKIE_SUPPORT procedures, 252

SET_CURRENT_OPINST Procedure, 118

SET_CURRENT_SCHEMA member procedure, 275

SET_DAD_ATTRIBUTE Procedure, 65

SET_DATABASE_PREFS Procedure, 155

SET_DBFS_LINK Procedures, 88

SET_DDL_TEXT member procedure, 275

SET_DEFAULT_SQLWKLD_PARAMETER Procedure, 19

SET_DEFAULT_TASK_PARAMETER Procedures, 19

SET_DEFAULTS procedure, 20

SET_DETAILED_EXCP_SUPPORT procedure, 252

SET_DIAGNOSIS_TASK_PARAMETER Procedure, 152

SET_DML_HANDLER procedure, 23

SET_EDITION_DEFERRED Procedure, 143

SET_EDITIONING_VIEWS_READ_ONLY Procedure, 64

SET_ENQUEUE_DESTINATION procedure, 23

SET_EVOLVE_TASK_PARAMETER Function, 148

SET_EXECUTE procedure, 23

SET_EXPRESSION procedure, 46

SET_EXTRA_ATTRIBUTE member procedure, 275

SET_FOLLOW_REDIRECT procedures, 252

SET_GLOBAL_ATTRIBUTE Procedure, 65

SET_GLOBAL_INSTANTIATION procedure, 23

SET_GLOBAL_PREFS Procedure, 155

SET_HEADER procedure, 252

SET_HEAT_MAP_ALL Procedure, 80

SET_HEAT_MAP_START Procedure, 80

SET_HEAT_MAP_TABLE Procedure, 80

SET_HOST_ACL Procedure, 101

SET_IDENTIFIER, 143

SET_INDEX_STATS procedures, 155

SET_INITIAL_CONSUMER_GROUP procedure, 131

SET_JAVA_LOGGING_LEVEL procedure, 96

SET_KEY_COLUMNS procedure, 23

SET_LAST_ARCHIVE_TIMESTAMP procedure, 29

SET_LOB_INFORMATION member procedure, 275

SET_LOB_OFFSET member procedure, 275

SET_LOB_OPERATION_SIZE member procedure, 275

SET_LOG_LEVEL Procedure, 97

SET_LOG_SPEC procedure, 44

SET_LOGON_USER member procedure, 275

SET_MAILHOST Procedure, 26

SET_MAILPORT Procedure, 26

SET_MAX_STREAMS_POOL Procedure, 25

SET_MESSAGE_NOTIFICATION procedure, 159

SET_MESSAGE_TRACKING procedure, 159

SET_MIN_STREAMS_POOL Procedure, 25

SET_MODULE procedure, 22

SET_NLS Procedure, 143

SET_NULL_COLUMN_VALUES_TO_EXPR Procedure, 64

SET_OBJECT_NAME member procedure, 275

SET_OBJECT_OWNER member procedure, 275, 275

SET_OBJECT_TYPE member procedure, 275

SET_OER_BREAKPOINT function, 53

SET_OPTION Procedure, 97

SET_P1_RESOURCES Procedure, 32

SET_PARAM procedure, 155

SET_PARAMETER procedure, 34, 44, 204

apply process, 23

SET_PERSISTENT_CONN_SUPPORT procedure, 252

SET_PLSQL_LOGGING_LEVEL procedure, 96

SET_PLSQL_TRACE procedure, 167

SET_PREFS Procedure, 147

SET_PROCESSING_RATE Procedure, 155

SET_PROTECTION_REALM procedure, 217

SET_PROXY procedure, 96, 252

SET_PURGE_JOB_INTERVAL procedure, 29

SET_PURGE_JOB_STATUS procedure, 29

SET_REPLAY_DIRECTORY Procedure, 178

SET_REPLAY_TIMEOUT Procedure, 178

SET_RESPONSE_ERROR_CHECK procedure, 252

SET_ROLE Procedure, 143

SET_ROWID_THRESHOLD Procedure, 38

SET_RULE_TRANSFORM_FUNCTION procedure, 159

SET_SCHEMA_INSTANTIATION procedure, 23

SET_SCHEMA_PREFS Procedure, 155

SET_SENDFROM Procedure, 26

SET_SESSION_LONGOPS procedure, 22

SET_SESSION_TIMEOUT procedure, 134

SET_SOURCE_DATABASE_NAME member procedure, 275

SET_SQL_TRACE Procedure, 143

SET_SQLWKLD_PARAMETER Procedure, 19

SET_SYSTEM_STATS procedure, 155

SET_TABLE_INSTANTIATION procedure, 23

SET_TABLE_PREFS Procedure, 155

SET_TABLE_STATS procedure, 155

SET_TAG member procedure, 275

SET_TAG procedure, 158, 159, 204

SET_TASK_PARAMETER Procedure, 19

SET_THRESHOLD procedure, 141

SET_TIMEOUT function, 53

SET_TIMEOUT procedure, 134

SET_TIMEOUT_BEHAVIOUR procedure, 53

SET_TRANSFER_TIMEOUT procedure, 252

SET_TRANSFORM procedure, 46

SET_TRIGGER_FIRING_PROPERTY procedure, 54

SET_TUNING_TASK_PARAMETER Function, 154

SET_UP_QUEUE procedure, 159, 204

SET_UPDATE_CONFLICT_HANDLER procedure, 23

SET_USER_MAPPING Procedure, 178

SET_VALUE function, 53

SET_VALUE member procedure, 275

SET_VALUE_DEPENDENCY procedure, 23

SET_VALUES member procedure, 275

SET_WALLET procedure, 252

SET_WALLET_ACL Procedure, 101

SET_WARNING_SETTING_STRING procedure, 175

SET_WATERMARK Procedure, 25

SET_XML_INFORMATION member procedure, 275

SETACL Procedure, 185, 187

SETANYSTORAGE Procedure, 198

SETATTRIBUTE procedure, 191

SETATTRIBUTENODE function, 191

SETAUTHOR Procedure, 187

SETBASEDIR procedure, 194

SETBATCHSIZE procedure, 196

SETBINDVALUE procedure, 195

SETCHARACTERSET Procedure, 187

SETCHARSET Procedure, 191

SETCOLLIDATTRNAME procedure, 195

SETCOMMENT Procedure, 187

SETCOMMITBATCH procedure, 196

SETCONTENT Procedures, 187

SETCONTENTTYPE Procedure, 88, 187

SETCONVERTSPECIALCHARS procedure, 192

SETCUSTOMMETADATA Procedure, 187

SETDATA procedure, 191

SETDATAHEADER procedure, 195

SETDATEFORMAT procedure, 195, 196

SETDCHARSET procedure, 191

SETDEFAULTACL Procedure, 48

SETDEFAULTASOF Procedur, 48

SETDEFAULTCONTEXT Procedure, 48

SETDEFAULTOWNER Procedure, 48

SETDEFAULTPRINCIPAL Procedure, 48

SETDEFAULTTABLE Procedure, 198

SETDISPLAYNAME Procedure, 187

SETDOCTYPE procedure, 194

SETDOCTYPE Procedure, 191

SETDVERSION procedure, 191

SETENCODINGTAG procedure, 195

SETERRORLOG procedure, 194, 203

SETERRORTAG procedure, 195

SETFTPPORT Procedure, 183

SETHTTPCONFIGREALM Procedure, 183

SETHTTPPORT Procedure, 183

SETHTTPSPORT Procedure, 183

SETIGNORECASE procedure, 196

SETINFO member procedure

of ANYTYPE TYPE, 270

SETKEYCOLUMN procedure, 196, 200

SETLANGUAGE Procedure, 187

SETLISTENERENDPOINT Procedure, 183

SETLISTENERLOCALACCESS Procedure, 183

SETMAXROWS procedure, 192, 195

SETMETAHEADER procedure, 195

SETNAMEDITEM function, 191

SETNODEVALUE procedure, 191

SETNODEVALUEASBINARYSTREAM Function & Procedure, 191

SETNODEVALUEASCHARACTERSTREAM Function & Procedure, 191

SETOPTIONS Procedure, 88

SETOUTOFLINE Procedure, 198

SETOWNER Procedure, 187

SETPARAM procedure, 203

SETPATH Procedure, 49

SETPATH Procedures, 48

SETPREFIX procedure, 191

SETPRESERVEWHITESPACE procedure, 194, 196

SETRAISEEXCEPTION procedure, 195

SETRAISENOROWSEXCEPTION procedure, 195

SETRENDERPATH Procedure, 190

SETRENDERSTREAM Procedure, 190

SETROWIDATTRNAME procedure, 195

SETROWIDATTRVALUE procedure, 195

SETROWSETTAG procedure, 192, 195

SETROWTAG procedure, 195, 196, 200

SETSCHEMAANNOTATATIONS Procedure, 198

SETSCHEMAVALIDATED procedure, 285

SETSKIPROWS procedure, 192, 195

SETSOURCELANG Function, 201

SETSQLCOLLTYPE Procedure, 198

SETSQLNAME Procedure, 198

SETSQLTOXMLNAMEESCAPING procedure, 195, 196

SETSQLTYPE Procedure, 198

SETSQLTYPEMAPPING Procedure, 198

SETSTANDALONE procedure, 191

SETSTATS Procedure, 48

SETSTOREPROPERTY Procedure, 50

SETSTYLESHEETHEADER procedure, 195

SETTABLEPROPS Procedure, 198

SETTAGCASE procedure, 195

SETTIMESTAMPWITHTIMEZONE Procedure, 198

SETTRACE Procedure, 48

SETUPDATECOLUMN procedure, 196, 200

SETVALIDATIONMODE procedure, 194

SETVALUE procedure, 191

SETXSLT procedure, 195, 196

SETXSLTPARAM procedure, 195, 196

SHOW_BREAKPOINTS procedures, 53

SHOW_EXTENDED_STATS_NAME Function, 155

SHOW_FRAME_SOURCE procedure, 53

SHOW_SOURCE procedures, 53

SHOW_STATS procedure, 264

SHOW_STATS_HTML procedure, 264

SHOWPAGE procedure, 219

SHOWSOURCE procedure, 219

SHOWWARNINGS procedure, 194, 203

SHUTDOWN Procedure, 97

SIGNAL procedure, 20

SIGNATURE procedure, 219

SIMPLE_SQL_NAME Function, 28

SIZES procedure, 144

SKIP_CORRUPT_BLOCKS procedure, 124

SLEEP procedure, 89

SMALL function

of HTF package, 207

SMALL procedure

of HTP package, 208

snapshot. See DBMS_MVIEW, 100

SOURCE_LINES_T Table Type, 114

SPACE_ERROR_INFO function, 134

SPACE_USAGE procedure, 145

SPACEUSAGE Procedure, 48, 49

split streams, 159, 204

SPLIT_STREAMS procedure, 159, 204

SPLITPATH Procedure, 185

SPLITTEXT function, 191

SQL Apply

managing logical standby databases, 92

managing with DBMS_LOGSTDBY package, 92

SQL generation, 275, 275

SQL Performance Reporting Subprograms, 154

SQL*Plus

creating a sequence, 1

SQL_HASH Function, 150

SQL_ID Function, 150

SQL_OBJECT_NAME Function, 28

SQLID_TO_SQLHASH Function, 174

SQLSET_ROW Object Type, 154

SQLTEXT_TO_SIGNATURE Function, 154

STACK_BIN_CAT procedure, 46

STACK_BIN_NUM procedure, 46

STACK_CLIP procedure, 46

STACK_COL_REM procedure, 46

STACK_MISS_CAT procedure, 46

STACK_MISS_NUM procedure, 46

STACK_NORM_LIN procedure, 46

staging

queues

creating, 159, 204

removing, 159, 204

START__CONSOLIDATED_REPLAY Procedure, 178

START_APPLY procedure, 23

START_CAPTURE procedure, 34

START_CAPTURE Procedure, 177

START_OUTBOUND procedure, 204, 204

START_POOL Procedure, 37

START_PROFILER functions and procedures, 116

START_PROFILING Procedure, 76

START_PROPAGATION procedure, 117

START_REDEF_TABLE procedure, 122

START_REPLAY Procedure, 178

START_REPORT_CAPTURE Procedure, 31

START_SERVICE procedure, 142

STARTTLS Function and Procedure, 263

STARTUP Procedure, 97

STARTUP_EXTPROC_AGENT procedure, 206

STATUS Function, 133

STATUS_LINE procedure, 219

STEP_ID function, 168

STOP_APPLY procedure, 23

STOP_CAPTURE procedure, 34

STOP_ILM Procedure, 79

STOP_POOL Procedure, 37

STOP_PROFILER function and procedure, 116

STOP_PROFILING Procedure, 76

STOP_PROPAGATION procedure, 117

STOP_SERVICE procedure, 142

STOP_TASK Procedure, 107

STORE_T Record Type, 48

STORE_VALUES procedure, 215

stored outlines

DBMS_OUTLN, 105

OUTLN_PKG package, 105

STOREPUSH Procedure, 50

STREAM2MULTI procedure, 218

Streams

removing configuration, 159

STREAMS$_TRANSFORM_FUNCTION, 159

STRIKE function

of HTF package, 207

STRIKE procedure

of HTP package, 208

STRING function, 119

STRING_TO_RAW Function, 253

STRONG function

of HTF package, 207

STRONG procedure

of HTP package, 208

STYLE function

of HTF package, 207

STYLE procedure

of HTP package, 208

SUB procedure

of HTP package, 208

SUBMIT procedure, 84

SUBMIT_PENDING_AREA procedure, 131

SUBPROGRAM Function, 247

SUBSTR function, 260

SUBSTR Functions, 88

SUBSTRINGDATA function, 191

Summary of DBMS_AQELM Subprograms, 26

Summary of DBMS_DIMENSION Subprograms, 60

Summary of DBMS_ERRLOG Subprograms, 66

Summary of DBMS_MVIEW Subprograms, 100

Summary of DBMS_XDBZ Subprograms, 189

Summary of DBMS_XMLDOM Subprograms, 191

Summary of DBMS_XMLSCHEMA Subprograms, 197

Summary of UTL_LMS Subprograms, 256

SUMMARY procedure, 156

SUP function

of HTF package, 207

SUP procedure

of HTP package, 208

SWITCH_CONSUMER_GROUP_FOR_SESS procedure, 131

SWITCH_CONSUMER_GROUP_FOR_USER procedure, 131

SWITCH_CURRENT_CONSUMER_GROUP Procedure, 143

SWITCH_PLAN procedure, 131

SYNC_INTERIM_TABLE procedure, 122

SYNCHRONIZE function, 53

synchronous capture

altering, 34

instantiation

preparing a table for, 34

rules, 159

SYNCINDEX Procedure, 193

synonyms

comparing, 35

SYS.MGW_MQSERIES_PROPERTIES Object Type, 97

SYS.MGW_PROPERTIES Object Type, 97

SYS.MGW_PROPERTY Object Type, 97

SYS.MGW_TIBRV_PROPERTIES Object Type, 97

---

T

TABLE_CREATE procedure, 44

TABLE_TO_COMMA Procedures, 174

TABLECAPTION function

of HTF package, 207

TABLECAPTION procedure

of HTP package, 208

TABLECLOSE function

of HTF package, 207

TABLECLOSE procedure

of HTP package, 208

TABLEDATA function

of HTF package, 207

TABLEDATA procedure

of HTP package, 208

TABLEHEADER function

of HTF package, 207

TABLEHEADER procedure

of HTP package, 208

TABLEOPEN function

of HTF package, 207

TABLEOPEN procedure

of HTP package, 208

TABLEPRINT function, 219

TABLEROWCLOSE function

of HTF package, 207

TABLEROWCLOSE procedure

of HTP package, 208

TABLEROWOPEN function

of HTF package, 207

TABLEROWOPEN procedure

of HTP package, 208

tables

comparing, 35

table items as arrays, 149

tablespace repositories

attaching tablespaces, 164

cloning tablespaces, 164

detaching tablespaces, 164

TABLESPACE_FIX_BITMAPS procedure, 146

TABLESPACE_FIX_SEGMENT_STATES procedure, 146

TABLESPACE_HEAT_MAP Procedure, 74

TABLESPACE_MIGRATE_FROM_LOCAL procedure, 146

TABLESPACE_MIGRATE_TO_LOCAL procedure, 146

TABLESPACE_REBUILD_BITMAPS procedure, 146

TABLESPACE_REBUILD_QUOTAS procedure, 146

TABLESPACE_RELOCATE_BITMAPS procedure, 146

TABLESPACE_SET type, 164

TABLESPACE_VERIFY procedure, 146

tags

GET_TAG function, 158, 159, 204

SET_TAG procedure, 158, 159, 204

TARGET_FILE function, 44

TARGET_LOB function, 44

TARGET_PROGRAM_RUNNING procedure, 53

TARGET_TABLE function, 44

TARGET_TRACE function, 44

TELETYPE function

of HTF package, 207

TELETYPE procedure

of HTP package, 208

TERMINATE procedure, 119

TEXT_DECODE function, 250

TEXT_ENCODE function, 250

The DBMS_XDB_REPOS package, 185

TIME_TABLE Table Type, 149

TIME_WITH_TIME_ZONE_TABLE Table Type, 149

TIMESTAMP_TABLE Table Type, 149

TIMESTAMP_WITH_LTZ_TABLE Table Type, 149

TIMESTAMP_WITH_TIME_ZONE_TABLE Table Type, 149

TITLE function

of HTF package, 207, 207

TITLE procedure

of HTP package, 208

TO_CURSOR_NUMBER Function, 149

TO_REFCURSOR Function, 149

TO_STRING function, 282

TODATE function, 219

TOOBJECT procedure, 285

TOUCHRESOURCE Procedure, 185

TRACE procedure, 43

TRACE Procedure, 48

TRACEENABLED Function, 48

TRACETAB.SQL, 167

tracking LCRs, 159, 159, 204

TRANSACTION_BACKOUT Procedures, 70

TRANSFER_STATS Procedure, 155

TRANSFORM function, 285

transformations

rule-based

adding a column, 159, 204

custom, 159

deleting a column, 159, 204

keeping columns, 159, 204

renaming a column, 159, 204

renaming a schema, 159, 204

renaming a table, 159, 204

STREAMS$_TRANSFORM_FUNCTION, 159

TRANSFORMNODE function, 203

TRANSLATE function, 260, 282

TRANSLATE_ERROR Procedure, 150

TRANSLATE_SQL Procedure, 150

TRANSLATEXML Function, 201

TRANSLITERATE Function, 253, 260

TRANSPORT_SET_CHECK procedure, 172

TRIM Procedures, 88

TUNE_MVIEW Procedure, 19

TYPE_BUILD function, 44

TYPE_DIMENSION_COMPILE function, 44

TYPE_OPERATIONS function, 44

TYPE_REJECTED_RECORDS function, 44

types

MGD_ID, 282, 282

MGD_ID_COMPONENT, 282

MGD_ID_COMPONENT_VARRAY, 282

Oracle Multimedia

ORDAudio, 276

ORDDicom, 277

ORDDoc, 278

ORDImage, 279

ORDVideo, 281

SQL/MM Still Image, 280

---

U

ULISTCLOSE function

of HTF package, 207

ULISTCLOSE procedure

of HTP package, 208

ULISTOPEN function

of HTF package, 207

ULISTOPEN procedure

of HTP package, 208

UNASSIGN_ACL Procedure, 101

UNASSIGN_WALLET_ACL Procedure, 101

UNCHECKOUT function, 186

UNCL_ARRAY Table Type, 174

UNDERLINE function

of HTF package, 207

UNDERLINE procedure

of HTP package, 208

UNESCAPE function, 266

UNESCAPEURI function, 273

UNIFORM_DIST_FIT procedure, 156

UNIQUE_SESSION_ID Function, 143

UNIQUE_SESSION_NAME function, 112

UNIT_LINE Function, 247

UNKEEP procedure, 144

UNLOCK_MAP procedure, 157

UNLOCK_PARTITION_STATS Procedure, 155

UNLOCK_SCHEMA_STATS procedure, 155

UNLOCK_TABLE_STATS procedure, 155

UNLOCKPATH Procedure, 48, 49

UNLOCKRESOURCE Function, 185

UNMAP_DAD Procedure, 65

UNMARKHOT Procedure, 144

UNMOUNTSTORE Procedure, 48

UNPACK_MESSAGE procedures, 112

UNPACK_STGTAB_BASELINE Function, 148

UNPACK_STGTAB_DIRECTIVE Function, 147

UNPACK_STGTAB_SQLPATCH Procedure, 152

UNPACK_STGTAB_SQLPROF Procedure, 154

UNPACK_STGTAB_SQLSET Procedure, 154

UNREGISTER_DEPENDENT_OBJECT procedure, 122

UNREGISTER_FOREIGN_QUEUE Procedure, 97

UNREGISTERSTORE Procedure, 48

UNREGISTERURLHANDLER procedure, 273

UNSCHEDULE_PROPAGATION Procedure, 97

UNUSED_SPACE procedure, 145

UPDATE_BY_CAT procedure, 105

UPDATE_CATEGORY Procedure, 131

UPDATE_CDB_AUTOTASK_DIRECTIVE Procedure, 131

UPDATE_CDB_DEFAULT_DIRECTIVE Procedure, 131

UPDATE_CDB_PLAN Procedure, 131

UPDATE_CDB_PLAN_DIRECTIVE Procedure, 131

UPDATE_CONSUMER_GROUP procedure, 131

UPDATE_CREDENTIAL Procedure, 39

UPDATE_FULL_REDACTION_VALUES Procedure, 121

UPDATE_OBJECT procedure, 262

UPDATE_OBJECT Procedure, 19

UPDATE_OBJECT_INFO Function, 179

UPDATE_PLAN procedure, 131

UPDATE_PLAN_DIRECTIVE procedure, 131

UPDATE_REC_ATTRIBUTES Procedure, 19

UPDATE_SIGNATURES procedure, 105

UPDATE_SQLSET procedures, 154

UPDATE_SQLWKLD_ATTRIBUTES Procedure, 19

UPDATE_SQLWKLD_STATEMENT Procedure, 19

UPDATE_TASK_ATTRIBUTES Procedure, 19

UPDATERESOURCEMETADATA Procedures, 185

UPDATETRANSLATION Function, 201

UPDATEXML function, 196, 200

UPGRADE_DATABASE Procedure, 62

UPGRADE_SCHEMA Procedure, 62

UPGRADE_STAT_TABLE procedure, 155

UPGRADE_TABLE Procedure, 62

URI Types

description, 273

UriFactory package, 273

ESCAPEURI function, 273

GETURL function, 273

methods, 273

REGISTERURLHANDLER procedure, 273

UNESCAPEURI function, 273

UNREGISTERURLHANDLER procedure, 273

UriType supertype, 273

GETBLOB function, 273

GETCLOB function, 273

GETCONTENTTYPE function, 273

GETEXTERNALURL function, 273

GETURL function, 273

GETXML function, 273

methods, 273

UROWID_TABLE Table Type, 149

USE_FILTER_SET Procedure, 178

USE_ROLLBACK_SEGMENT procedure, 168

USEBINARYSTREAM Function, 191

USEDPORT Procedure, 183

USEITEMTAGSFORCOLL procedure, 192

USENULLATTRIBUTEINDICATOR procedure, 192, 195

USER_EXPORT procedures, 84

USETYPEFORCOLLELEMTAG procedure, 195

Using DBMS_ADVISOR, 19

Using DBMS_AQIN, 27, 27

Using DBMS_FILE_GROUP, 68

Using DBMS_MVIEW, 100

Using DBMS_RULE, 138

Using DBMS_RULE_ADM, 139

Using DBMS_STREAMS, 158

Using DBMS_STREAMS_ADM, 159

Using DBMS_STREAMS_TABLESPACE_ADM, 164

Using DBMS_XMLDOM, 191

Using DBMS_XMLSCHEMA, 197

Using UTL_HTTP, 252

UTL Streams Types, 284

UTL_BINARYINPUTSTREAM Type, 284

UTL_BINARYOUTPUTSTREAM Type, 284

UTL_CHARACTERINPUTSTREAM Type, 284

UTL_CHARACTEROUTPUTSTREAM Type, 284

UTL_COLL package, 248

UTL_COMPRESS package, 249

UTL_ENCODE package, 250

UTL_FILE package, 251

UTL_HTTP package, 252

UTL_I18N package, 253

ESCAPE_REFERENCE function, 253, 253, 253, 253, 253, 253, 253

GET_DEFAULT_CHARSET function, 253

MAP_CHARSET function, 253

MAP_LANGUAGE_FROM_ISO function, 253

MAP_LOCALE_TO_ISO function, 253

MAP_TERRITORY_FROM_ISO function, 253

RAW_TO_CHAR function, 253

RAW_TO_NCHAR function, 253

UNESCAPE_REFERENCE function, 253

UTL_INADDR package, 254

UTL_LMS package, 256

FORMAT_MESSAGE function, 256

GET_MESSAGE function, 256

UTL_MAIL package, 257

UTL_MATCH package, 258

UTL_NLA package, 259

UTL_RAW package, 260

UTL_RECOMP package, 261

UTL_REF package, 262

UTL_SPADV package, 264

UTL_TCP package, 265

UTL_URL package, 266

UUDECODE function, 250

UUENCODE function, 250

---

V

V$STREAMS_MESSAGE_TRACKING view, 159, 159, 204

v$vpd_policies, 135

VALIDATE Procedure, 174

VALIDATE_DIMENSION procedure, 60

VALIDATE_PENDING_AREA procedure, 131

VALIDATE_REWRITE_EQUIVALENCE Procedure, 18

VALIDATE_SCHEME function, 96

VALIDATE_XML procedure, 42

VALUE functions, 119

VALUEOF procedure, 203

VARCHAR2_TABLE Table Type, 149

VARCHAR2A Table Type, 149

VARCHAR2S Table Type, 149

VARIABLE function

of HTF package, 207

VARIABLE procedure

of HTP package, 208

VARIABLE_VALUE procedures, 149

VERBOSE_ACTION function, 44

VERBOSE_DEBUG function, 44

VERBOSE_INFO function, 44

VERBOSE_NOTICE function, 44

VERBOSE_STATS function, 44

VERIFY_VALUES function, 215

VERSION function, 44

views

comparing, 35

virtual dependency definitions

object dependencies

creating, 23

dropping, 23

value dependencies, 23

Virtual Private Database. See VPD

VPD

viewing current cursors and policy predicates, 135

VPD use of DBMS_RLS, 135

VRFY function, 263

---

W

WAIT_ON_PENDING_DML Procedure, 174

WAITANY procedure, 20

WAITONE procedure, 20

WBR function

of HTF package, 207

WBR procedure

of HTP package, 208

WEIBULL_DIST_FIT procedure, 156

WHAT procedure, 84

WHO_CALLED_ME procedure, 219

WPG_DOCLOAD package, 267

WRAP Functions, 54

WRITE Procedures, 88

WRITE_DATA procedure, 263

WRITE_LINE function, 265

WRITE_LINE procedure, 252

WRITE_RAW function, 265

WRITE_RAW procedure, 252

WRITE_RAW_DATA procedure, 263

WRITE_TEXT function, 265

WRITE_TEXT procedure, 252

WRITEAPPEND Procedures, 88

WRITETOBUFFER procedure, 191

WRITETOCLOB procedure, 191

WRITETOFILE procedure, 191

---

X

XA_COMMIT Function, 180

XA_END Function, 180

XA_FORGET Function, 180

XA_GETLASTOER Function, 180

XA_PREPARE Function, 180

XA_RECOVER Function, 180

XA_ROLLBACK Function, 180

XA_SETTIMEOUT Function, 180

XA_START Function, 180

XDBEvent Type Subprograms, 190

XDBHandler Type Subprograms, 190

XDBHandlerList Type Subprograms, 190

XDBLink Type Subprograms, 190

XDBPath Type Subprograms, 190

XDBRepositoryEvent Type Subprograms, 190

XDBSCHEMA_PREFIXES Function, 184

XDBUriType, 273

XDBURITYPE function, 273

XDBUriType subtype, 273

CREATEURI function, 273

GETBLOB function, 273

GETCLOB function, 273

GETCONTENTTYPE function, 273

GETEXTERNALURL function, 273

GETURL function, 273

GETXML function, 273

methods, 273

XDBURITYPE function, 273

XDBZ Constants, 189

XFORM_BIN_CAT procedure, 46

XFORM_BIN_NUM procedure, 46

XFORM_CLIP procedure, 46

XFORM_COL_REM procedure, 46

XFORM_EXPR_NUM procedure, 46

XFORM_EXPR_STR procedure, 46

XFORM_MISS_CAT procedure, 46

XFORM_MISS_NUM procedure, 46

XFORM_NORM_LIN procedure, 46

XFORM_STACK procedure, 46

XML_TO_LCR Function, 98

XMLINDEXADDPATH Procedure, 182

XMLINDEXREMOVEPATH Procedure, 182

XMLType

CREATENONSCHEMABASEDXML function, 285

CREATESCHEMABASEDXML function, 285

CREATEXML function, 285

description, 285

EXISTSNODE function, 285

EXTRACT function, 285

GETBLOBVAL function, 285

GETCLOBVAL function, 285

GETNUMBERVAL function, 285

GETROOTELEMENT function, 285

GETSCHEMAURL function, 285

GETSTRINGVAL function, 285

ISFRAGMENT function, 285

ISSCHEMABASED function, 285

ISSCHEMAVALID function, 285

ISSCHEMAVALIDATED function, 285

NAMESPACE function, 285

SCHEMAVALIDATE procedure, 285

SETSCHEMAVALIDATED procedure, 285

TOOBJECT procedure, 285

TRANSFORM function, 285

XMLTYPE function, 285

XMLTYPE function, 285

XPATH2TABCOLMAPPING Function, 199

XRANGE function, 260

XSD_ATTRIBUTE Function, 184

XSD_COMPLEX_TYPE Function, 184

XSD_ELEMENT Function, 184

XSD_GROUP Function, 184

XStream

DBMS_XSTREAM_ADM package, 204

privileges, 205

removing configuration, 204

security, 204

XStream administrator, 205