Index

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

A

ABORT_GLOBAL_INSTANTIATION procedure, 8-3

ABORT_SCHEMA_INSTANTIATION procedure, 8-3

ABORT_TABLE_INSTANTIATION procedure, 8-4

ADD_COLUMN member procedure, 108-20

ADD_GLOBAL_PROPAGATION_RULES procedure, 73-3

ADD_GLOBAL_RULES procedure, 73-7

ADD_PAIR member procedure, 109-7

ADD_RULE procedure, 64-3

ADD_SCHEMA_PROPAGATION_RULES procedure, 73-11

ADD_SCHEMA_RULES procedure, 73-15

ADD_SUBSET_RULES procedure, 73-19

ADD_TABLE_PROPAGATION_RULES procedure, 73-24

ADD_TABLE_RULES procedure, 73-28

Advanced Queuing

DBMS_AQADM package, 6-1

ALTER_APPLY procedure, 4-4

ALTER_CAPTURE procedure, 8-4

ALTER_PROPAGATION procedure, 47-3

ALTER_RULE procedure, 64-5

altering

propagation method, 53-27, 53-32

savepoints, 80-6

workspace description, 80-7

AlterSavepoint procedure, 80-6

AlterWorkspace procedure, 80-7

anonymous PL/SQL blocks

dynamic SQL and, 69-3

AnyData datatype

queues

creating, 73-35

apply process

altering, 4-4

conflict handlers

setting, 4-37

creating, 4-9, 73-7, 73-15, 73-19, 73-28

DBMS_APPLY_ADM package, 4-1

DDL handler

setting, 4-4, 4-9

DML handlers

setting, 4-18

dropping, 4-14

error handlers

setting, 4-18

error queue

deleting errors, 4-13, 4-14

executing errors, 4-15, 4-16

getting error messages, 4-17

instantiation

global SCN, 4-23

schema SCN, 4-32

table SCN, 4-35

message handler

setting, 4-4, 4-9

parameters

commit_serialization, 4-29

disable_on_error, 4-29

disable_on_limit, 4-29

maximum_scn, 4-29

parallelism, 4-30

setting, 4-28

time_limit, 4-30

trace_level, 4-30

transaction_limit, 4-31

rules

defining global, 73-7

defining schema, 73-15

defining subset, 73-19

defining table, 73-28

removing, 73-34

starting, 4-41

stopping, 4-42

substitute key columns

setting, 4-26

arrays

BIND_ARRAY procedure, 69-7

bulk DML using DBMS_SQL, 69-29

auditing modifications

EnableVersioning history option, 80-29

availability

extended, 53-10, 53-31, 53-84, 53-97, 53-102, 53-107

available()

function of UTL_TCP, 101-9

B

BeginDDL procedure, 80-8

BeginResolve procedure, 80-9

C

capture process

altering, 8-4

creating, 73-7, 73-15, 73-28

instantiation

aborting database preparation, 8-3

aborting schema preparation, 8-3

aborting table preparation, 8-4

preparing a database for, 8-8

preparing a schema for, 8-9

preparing a table for, 8-10

parameters

disable_on_limit, 8-12

maximum_scn, 8-12

message_limit, 8-12

parallelism, 8-12

setting, 8-11

startup_seconds, 8-13

time_limit, 8-13

trace_level, 8-13

write_alert_log, 8-13

rules

defining global, 73-7

defining schema, 73-15

defining table, 73-28

removing, 73-34

starting, 8-14

stopping, 8-15

catproc.sql script, 1-3

Change Data Capture

DBMS_LOGMNR_CDC_PUBLISH package, 26-1

DBMS_LOGMNR_CDC_SUBSCRIBE package, 27-1

child workspace

merging, 80-52

refreshing, 80-57, 80-58

removing, 80-62

close_all_connections()

function of UTL_TCP, 101-19

close_connection()

function of UTL_TCP, 101-18

close_data() function

of UTL_SMTP, 100-14

collections

table items, 69-29

columns

adding to master tables, 53-94

column groups

adding members to, 53-6

creating, 53-59, 53-82

dropping, 53-63

removing members from, 53-64

command() function

of UTL_SMTP, 100-8

command_replies() function

of UTL_SMTP, 100-8

CommitDDL procedure, 80-10

CommitResolve procedure, 80-12

comparing

tables, 49-2

compressing

workspaces, 80-13, 80-16

CompressWorkspace procedure, 80-13

CompressWorkspaceTree procedure, 80-16

conflict management, 80-63

beginning resolution, 80-9

committing resolution, 80-12

rolling back resolution, 80-69

showing conflicts, 80-74

conflict resolution

additive method, 53-19

statistics, 53-38, 53-90

connection

function of UTL_TCP, 101-4

connection function

of UTL_SMTP, 100-6

constants

DBMS_MGWADM package, 31-7

DBMS_MGWMSG package, 32-8

context (session)

GetSessionInfo function, 80-38

context of current operation

getting, 80-37

continually refreshed workspace, 80-21

CopyForUpdate procedure, 80-17

CREATE PACKAGE BODY command, 1-3

CREATE PACKAGE command, 1-3

CREATE_APPLY procedure, 4-9

CREATE_CAPTURE procedure

capture process

creating, 8-6

CREATE_EVALUATION_CONTEXT procedure, 64-8

CREATE_PROPAGATION procedure, 47-4

CREATE_RULE procedure, 64-11

CREATE_RULE_SET procedure, 64-13

CreateSavepoint procedure, 80-19

CreateWorkspace procedure, 80-20

creating

packages, 1-3

savepoints, 80-19

workspaces, 80-20

CRLF (carriage-return line-feed)

function of UTL_TCP, 101-6

cursors

DBMS_SQL package, 69-5

D

data definition language

altering replicated objects, 53-28

asynchronous, 53-77

supplying asynchronous, 53-77

data dictionary

removing Streams information, 73-32

data() function

of UTL_SMTP, 100-13

database tables

creating for DBMS_TRACE, 74-3

datatypes

DBMS_DESCRIBE, 14-4

DESC_TAB, 69-45

PL/SQL

numeric codes for, 14-8

ROWID, 62-1

DBA_REPCATLOG view

purging, 53-85

DBA_REPCOLUMN_GROUP view

updating, 53-39

DBA_REPGROUP view

updating, 53-42

DBA_REPOBJECT view

updating, 53-43

DBA_REPPRIORITY_GROUP view

updating, 53-41

DBA_REPRESOLUTION view

updating, 53-46

DBA_REPRESOLUTION_STATISTICS view

purging, 53-86

DBA_REPSITES view

updating, 53-44

DBMS_ALERT package, 2-1

DBMS_APPLICATION_INFO package, 3-2

DBMS_APPLY_ADM package, 4-1

DBMS_AQ package, 5-1

DBMS_AQADM package, 6-1

DBMS_AQELM package, 7-1, 7-2

DBMS_CAPTURE package, 106-1

DBMS_CAPTURE_ADM package

capture process

DBMS_CAPTURE_ADM package, 8-1

DBMS_DDL package, 9-1

DBMS_DEBUG package, 10-1

DBMS_DEFER package, 11-1

ANY_CHAR_ARG procedure, 11-4

ANY_CLOB_ARG procedure, 11-4

ANY_VARCHAR2_ARG procedure, 11-4

ANYDATA_ARG procedure, 11-4

BLOB_ARG procedure, 11-4

CALL procedure, 11-2

CHAR_ARG procedure, 11-4

CLOB_ARG procedure, 11-4

COMMIT_WORK procedure, 11-3

datatype_ARG procedure, 11-4

DATE_ARG procedure, 11-4

IDS_ARG procedure, 11-4

IYM_ARG procedure, 11-4

NCHAR_ARG procedure, 11-4

NCLOB_ARG procedure, 11-4

NUMBER_ARG procedure, 11-4

NVARCHAR2_ARG procedure, 11-4

RAW_ARG procedure, 11-4

ROWID_ARG procedure, 11-4

TIMESTAMP_ARG procedure, 11-4

TRANSACTION procedure, 11-6

TSLTZ_ARG procedure, 11-4

TSTZ_ARG procedure, 11-4

VARCHAR2_ARG procedure, 11-4

DBMS_DEFER_QUERY package, 12-1

GET_ANYDATA_ARG procedure, 12-7

GET_ARG_FORM function, 12-2

GET_ARG_TYPE function, 12-3

GET_BLOB_ARG procedure, 12-7

GET_CALL_ARGS procedure, 12-6

GET_CHAR_ARG procedure, 12-7

GET_CLOB_ARG procedure, 12-7

GET_datatype_ARG function, 12-7

GET_DATE_ARG procedure, 12-7

GET_IDS_ARG procedure, 12-7

GET_IYM_ARG procedure, 12-7

GET_NCHAR_ARG procedure, 12-7

GET_NCLOB_ARG procedure, 12-7

GET_NUMBER_ARG procedure, 12-7

GET_NVARCHAR2_ARG procedure, 12-7

GET_OBJECT_NULL_VECTOR_ARG function, 12-9

GET_RAW_ARG procedure, 12-7

GET_ROWID_ARG procedure, 12-7

GET_TIMESTAMP_ARG procedure, 12-7

GET_TSLTZ_ARG procedure, 12-7

GET_TSTZ_ARG procedure, 12-7

GET_VARCHAR2_ARG procedure, 12-7

DBMS_DEFER_SYS package

ADD_DEFAULT_DEST procedure, 13-3

CLEAR_PROP_STATISTICS procedure, 13-4

DELETE_DEF_DESTINATION procedure, 13-5

DELETE_DEFAULT_DEST procedure, 13-5

DELETE_ERROR procedure, 13-6

DELETE_TRAN procedure, 13-6, 13-7, 13-9

DISABLED function, 13-7

EXCLUDE_PUSH function, 13-8

EXECUTE_ERROR procedure, 13-9

EXECUTE_ERROR_AS_USER procedure, 13-10

PURGE function, 13-11

PUSH function, 13-13

REGISTER_PROPAGATOR procedure, 13-17

SCHEDULE_EXECUTION procedure, 13-19

SCHEDULE_PURGE procedure, 13-17

SCHEDULE_PUSH procedure, 13-19

SET_DISABLED procedure, 13-21

UNREGISTER_PROPAGATOR procedure, 13-23

UNSCHEDULE_PURGE procedure, 13-24

UNSCHEDULE_PUSH procedure, 13-24

DBMS_DESCRIBE package, 14-1

DBMS_DISTRIBUTED_TRUST_ADMIN package, 15-1

DBMS_FGA package, 16-1

DBMS_FLASHBACK package, 17-1, 17-6

DBMS_HS_PASSTHROUGH package, 18-1

DBMS_IOT package, 19-1

DBMS_JOB package, 20-1

and instance affinity, 20-2

DBMS_LOB package, 23-1

DBMS_LOCK package, 24-1

DBMS_LOGMNR package, 25-1

ADD_LOGFILE procedure, 25-4

COLUMN_PRESENT function, 25-10

constants, 25-2

END_LOGMNR procedure, 25-8

MINE_VALUE function, 25-8

START_LOGMNR procedure, 25-5

DBMS_LOGMNR_CDC_PUBLISH package, 26-1

ALTER_CHANGE_TABLE procedure, 26-8

CREATE_CHANGE_SOURCE procedure, 26-3

CREATE_CHANGE_TABLE procedure, 26-3

DROP_CHANGE_TABLE procedure, 26-14

DBMS_LOGMNR_CDC_SUBSCRIBE package, 27-1

ACTIVATE_SUB SCRIPTION procedure, 27-9

DROP_SUBSCRIBER_VIEW procedure, 27-13

DROP_SUBSCRIPTION procedure, 26-13, 27-16

EXTEND_WINDOW procedure, 27-10

EXTEND_WINDOW_LIST procedure, 27-11

GET_SUBSCRIPTION_HANDLE procedure, 27-5

PREPARE_SUBSCRIBER_VIEW procedure, 27-11

PREPARE_UNBOUNDED_VIEW procedure, 27-13

PURGE_WINDOW procedure, 27-14

SUBSCRIBE procedure, 27-6

usage examples, 27-16

DBMS_LOGMNR_D package, 28-1

BUILD procedure, 28-2

SET_TABLESPACE procedure, 28-5

DBMS_LOGSTDBY package, 29-1

APPLY_SET procedure, 29-3

APPLY_UNSET procedure, 29-7

BUILD procedure, 29-8

GUARD BYPASS OFF procedure, 29-9

GUARD_BYPASS_ON procedure, 29-9

INSTANTIATE_TABLE procedure, 29-10

SKIP procedure, 29-11

SKIP_ERROR procedure, 29-18

SKIP_TRANSACTION procedure, 29-21

UNSKIP procedure, 29-22

UNSKIP_ERROR procedure, 29-23

UNSKIP_TRANSACTION procedure, 29-23

DBMS_METADATA package, 30-1

ADD_TRANSFORM procedure, 30-15

CLOSE procedure, 30-24

FETCH_xxx procedure, 30-21

GET_DDL function, 30-28

GET_DEPENDENT_DDL function, 30-31

GET_DEPENDENT_XML function, 30-31

GET_GRANTED_DDL function, 30-33

GET_GRANTED_XML function, 30-33

GET_QUERY procedure, 30-12

GET_XML function, 30-28

OPEN procedure, 30-2

SET_COUNT procedure, 30-12

SET_FILTER procedure, 30-6

SET_PARSE_ITEM procedure, 30-13

SET_TRANSFORM_PARAM procedure, 30-17

DBMS_MGWADM package, 31-1

constants, 31-7

methods, 31-2

object types, 31-2

summary of subprograms, 31-12

DBMS_MGWMSG package, 32-1

constants, 32-8

methods, 32-2

object types, 32-2

summary of subprograms, 32-9

DBMS_MVIEW package

BEGIN_TABLE_REORGANIZATION procedure, 33-3

END_TABLE_REORGANIZATION procedure, 33-4

EXPLAIN_MVIEW procedure, 33-4

EXPLAIN_REWRITE procedure, 33-5

I_AM_A_REFRESH function, 33-6

PMARKER function, 33-7

PURGE_DIRECT_LOAD_LOG procedure, 33-7

PURGE_LOG procedure, 33-7

PURGE_MVIEW_FROM_LOG procedure, 33-8

REFRESH procedure, 33-10

REFRESH_ALL_MVIEWS procedure, 33-12

REFRESH_DEPENDENT procedure, 33-14

REGISTER_MVIEW procedure, 33-16

UNREGISTER_MVIEW procedure, 33-18

DBMS_OBFUSCATION_TOOLKIT package, 34-1

DBMS_OFFLINE_OG package

BEGIN_INSTANTIATION procedure, 36-2

BEGIN_LOAD procedure, 36-3

END_INSTANTIATION procedure, 36-5

END_LOAD procedure, 36-6

RESUME_SUBSET_OF_MASTERS procedure, 36-7

DBMS_OFFLINE_SNAPSHOT package

BEGIN_LOAD procedure, 37-2

END_LOAD procedure, 37-4

DBMS_OLAP package, 38-1

DBMS_ORACLE_TRACE_AGENT package, 39-1

DBMS_ORACLE_TRACE_USER package, 40-1

DBMS_OUTLN package, 41-1

DBMS_OUTLN_EDIT package, 42-1

DBMS_OUTPUT package, 43-1

DBMS_PCLXUTIL package, 44-1

DBMS_PIPE package, 45-1

DBMS_PROFILER package, 46-1

DBMS_PROPAGATION_ADM package, 47-1

DBMS_RANDOM package, 48-1

DBMS_RECTIFIER_DIFF package

DIFFERENCES procedure, 49-2

RECTIFY procedure, 49-5

DBMS_REFRESH package

ADD procedure, 51-2

CHANGE procedure, 51-3

DESTROY procedure, 51-5

MAKE procedure, 51-6

REFRESH procedure, 51-8

SUBTRACT procedure, 51-9

DBMS_REPAIR package, 52-1

DBMS_REPCAT package

ADD_DELETE_RESOLUTION procedure, 53-19

ADD_GROUPED_COLUMN procedure, 53-6

ADD_MASTER_DATABASE procedure, 53-8

ADD_NEW_MASTERS procedure, 53-10

ADD_PRIORITY_CHAR procedure, 53-16

ADD_PRIORITY_datatype procedure, 53-16

ADD_PRIORITY_DATE procedure, 53-16

ADD_PRIORITY_NUMBER procedure, 53-16

ADD_PRIORITY_VARCHAR2 procedure, 53-16

ADD_SITE_PRIORITY_SITE procedure, 53-17

ADD_UNIQUENESS_RESOLUTION procedure, 53-19

ADD_UPDATE_RESOLUTION procedure, 53-19

ALTER_CATCHUP_PARAMETERS procedure, 53-24

ALTER_MASTER_PROPAGATION procedure, 53-27

ALTER_MASTER_REPOBJECT procedure, 53-28

ALTER_MVIEW_PROPAGATION procedure, 53-32

ALTER_PRIORITY procedure, 53-33

ALTER_PRIORITY_CHAR procedure, 53-35

ALTER_PRIORITY_datatype procedure, 53-35

ALTER_PRIORITY_DATE procedure, 53-35

ALTER_PRIORITY_NUMBER procedure, 53-35

ALTER_PRIORITY_RAW procedure, 53-35

ALTER_SITE_PRIORITY procedure, 53-36

ALTER_SITE_PRIORITY_SITE procedure, 53-37

CANCEL_STATISTICS procedure, 53-38

COMMENT_ON_COLUMN_GROUP procedure, 53-39

COMMENT_ON_DELETE_RESOLUTION procedure, 53-46

COMMENT_ON_MVIEW_REPSITES procedure, 53-40

COMMENT_ON_PRIORITY_GROUP procedure, 53-41

COMMENT_ON_REPGROUP procedure, 53-42

COMMENT_ON_REPOBJECT procedure, 53-43

COMMENT_ON_REPSITES procedure, 53-44

COMMENT_ON_SITE_PRIORITY procedure, 53-41

COMMENT_ON_UNIQUE_RESOLUTION procedure, 53-46

COMMENT_ON_UPDATE_RESOLUTION procedure, 53-46

COMPARE_OLD_VALUES procedure, 53-47

CREATE_MASTER_REPGROUP procedure, 53-50

CREATE_MASTER_REPOBJECT procedure, 53-51

CREATE_MVIEW_REPGROUP procedure, 53-55

CREATE_MVIEW_REPOBJECT procedure, 53-56

DEFINE_COLUMN_GROUP procedure, 53-59

DEFINE_PRIORITY_GROUP procedure, 53-60

DEFINE_SITE_PRIORITY procedure, 53-61

DO_DEFERRED_REPCAT_ADMIN procedure, 53-62

DROP_COLUMN_GROUP procedure, 53-63

DROP_DELETE_RESOLUTION procedure, 53-75

DROP_GROUPED_COLUMN procedure, 53-64

DROP_MASTER_REPGROUP procedure, 53-65

DROP_MASTER_REPOBJECT procedure, 53-67

DROP_MVIEW_REPGROUP procedure, 53-68

DROP_MVIEW_REPOBJECT procedure, 53-69

DROP_PRIORITY procedure, 53-70

DROP_PRIORITY_CHAR procedure, 53-72

DROP_PRIORITY_datatype procedure, 53-72

DROP_PRIORITY_DATE procedure, 53-72

DROP_PRIORITY_GROUP procedure, 53-71

DROP_PRIORITY_NUMBER procedure, 53-72

DROP_PRIORITY_VARCHAR2 procedure, 53-72

DROP_SITE_PRIORITY procedure, 53-73

DROP_SITE_PRIORITY_SITE procedure, 53-74

DROP_UNIQUE_RESOLUTION procedure, 53-75

DROP_UPDATE_RESOLUTION procedure, 53-75

EXECUTE_DDL procedure, 53-77

GENERATE_MVIEW_SUPPORT procedure, 53-78

GENERATE_REPLICATION_SUPPORT procedure, 53-80

MAKE_COLUMN_GROUP procedure, 53-82

PREPARE_INSTANTIATED_MASTERS procedure, 53-84

PURGE_MASTER_LOG procedure, 53-85

PURGE_STATISTICS procedure, 53-86

REFRESH_MVIEW_REPGROUP procedure, 53-87

REGISTER_MVIEW_REPGROUP procedure, 53-89

REGISTER_STATISTICS procedure, 53-90

RELOCATE_MASTERDEF procedure, 53-91

REMOVE_MASTER_DATABASES procedure, 53-93

RENAME_SHADOW_COLUMN_GROUP procedure, 53-94

REPCAT_IMPORT_CHECK procedure, 53-95

RESUME_MASTER_ACTIVITY procedure, 53-96

RESUME_PROPAGATION_TO_MDEF procedure, 53-97

SEND_OLD_VALUES procedure, 53-98

SET_COLUMNS procedure, 53-50, 53-100

SPECIFY_NEW_MASTERS procedure, 53-102

SUSPEND_MASTER_ACTIVITY procedure, 53-105

SWITCH_MVIEW_MASTER procedure, 53-105

UNDO_ADD_NEW_MASTERS_REQUEST procedure, 53-107

UNREGISTER_MVIEW_REPGROUP procedure, 53-109

VALIDATE procedure, 53-109

WAIT_MASTER_LOG procedure, 53-112

DBMS_REPCAT_ADMIN package

GRANT_ADMIN_ANY_SCHEMA procedure, 54-2

GRANT_ADMIN_SCHEMA procedure, 54-3

REGISTER_USER_REPGROUP procedure, 54-4

REVOKE_ADMIN_ANY_SCHEMA procedure, 54-6

REVOKE_ADMIN_SCHEMA procedure, 54-6

UNREGISTER_USER_REPGROUP procedure, 54-7

DBMS_REPCAT_INSTANTIATE package

DROP_SITE_INSTANTIATION procedure, 55-2

INSTANTIATE_OFFLINE function, 55-3

INSTANTIATE_ONLINE function, 55-5

DBMS_REPCAT_RGT package

ALTER_REFRESH_TEMPLATE procedure, 56-4

ALTER_TEMPLATE_OBJECT procedure, 56-6

ALTER_TEMPLATE_PARM procedure, 56-9

ALTER_USER_AUTHORIZATION procedure, 56-11

ALTER_USER_PARM_VALUE procedure, 56-12

COMPARE_TEMPLATES function, 56-15

COPY_TEMPLATE function, 56-16

CREATE_OBJECT_FROM_EXISTING function, 56-18

CREATE_REFRESH_TEMPLATE function, 56-20

CREATE_TEMPLATE_OBJECT function, 56-22

CREATE_TEMPLATE_PARM function, 56-25

CREATE_USER_AUTHORIZATION function, 56-27

CREATE_USER_PARM_VALUE function, 56-29

DELETE_RUNTIME_PARMS procedure, 56-31

DROP_ALL_OBJECTS procedure, 56-32

DROP_ALL_TEMPLATE_PARMS procedure, 56-33

DROP_ALL_TEMPLATE_SITES procedure, 56-34

DROP_ALL_TEMPLATES procedure, 56-35

DROP_ALL_USER_AUTHORIZATIONS procedure, 56-35

DROP_ALL_USER_PARM_VALUES procedure, 56-36

DROP_REFRESH_TEMPLATE procedure, 56-38

DROP_SITE_INSTANTIATION procedure, 56-39

DROP_TEMPLATE_OBJECT procedure, 56-40

DROP_TEMPLATE_PARM procedure, 56-41

DROP_USER_AUTHORIZATION procedure, 56-42

DROP_USER_PARM_VALUE procedure, 56-43

GET_RUNTIME_PARM_ID function, 56-44

INSERT_RUNTIME_PARMS procedure, 56-45

INSTANTIATE_OFFLINE function, 56-47

INSTANTIATE_ONLINE function, 56-50

LOCK_TEMPLATE_EXCLUSIVE procedure, 56-52

LOCK_TEMPLATE_SHARED procedure, 56-53

DBMS_REPUTIL package

FROM_REMOTE function, 57-3

GLOBAL_NAME function, 57-4

MAKE_INTERNAL_PKG procedure, 57-4

REPLICATION_IS_ON function, 57-3

REPLICATION_OFF procedure, 57-2

REPLICATION_ON procedure, 57-3

SYNC_UP_REP procedure, 57-5

DBMS_RESOURCE_MANAGER package, 58-1

DBMS_RESOURCE_MANAGER_PRIVS package, 59-1

DBMS_RESUMABLE package, 60-1

DBMS_RLS package, 61-1

DBMS_ROWID package, 62-1

DBMS_RULE package, 63-1

DBMS_RULE_ADM package, 64-1

DBMS_SESSION package, 65-1

DBMS_SHARED_POOL package, 66-1

DBMS_SPACE package, 67-1

DBMS_SPACE_ADMIN package, 68-1

DBMS_STATS package, 70-1

DBMS_STREAMS package, 72-1

DBMS_STREAMS_ADM package, 73-1

DBMS_TRACE package, 74-1

DBMS_TRANSACTION package, 75-1

DBMS_TRANSFORM package, 76-1

DBMS_TTS package, 77-1

DBMS_UTILITY package, 79-1

DBMS_WM package, 80-1

AlterSavepoint procedure, 80-6

AlterWorkspace procedure, 80-7

BeginDDL procedure, 80-8

BeginResolve procedure, 80-9

CommitDDL procedure, 80-10

CommitResolve, 80-12

CompressWorkspace procedure, 80-13

CompressWorkspaceTree procedure, 80-16

CopyForUpdate procedure, 80-17

CreateSavepoint procedure, 80-19

CreateWorkspace procedure, 80-20

DeleteSavepoint procedure, 80-22

DisableVersioning procedure, 80-24

DropReplicationSupport procedure, 80-26

EnableVersioning procedure, 80-27

FreezeWorkspace procedure, 80-30

GenerateReplicationSupport procedure, 80-32

GetConflictWorkspace function, 80-34

GetDiffVersions function, 80-35

GetLockMode function, 80-35

GetMultiWorkspaces function, 80-36

GetOpContext function, 80-37

GetPrivs function, 80-38

GetSessionInfo function, 80-38

GetWorkspace function, 80-40

GotoWorkspace procedure, 80-43

GrantSystemPriv procedure, 80-44

GrantWorkspacePriv procedure, 80-46

IsWorkspaceOccupied function, 80-48

LockRows procedure, 80-49

MergeTable procedure, 80-50

MergeWorkspace procedure, 80-52

RecoverAllMigratingTables procedure, 80-54

RecoverMigratingTable procedure, 80-55

RefreshTable procedure, 80-57

RefreshWorkspace procedure, 80-58

RelocateWriterSite procedure, 80-59

RemoveWorkspace procedure, 80-61

RemoveWorkspaceTree procedure, 80-62

ResolveConflicts procedure, 80-63

RevokeSystemPriv procedure, 80-65

RevokeWorkspacePriv procedure, 80-67

RollbackDDL procedure, 80-68

RollbackResolve procedure, 80-69

RollbackTable procedure, 80-70

RollbackToSP procedure, 80-72

RollbackWorkspace procedure, 80-73

SetConflictWorkspace procedure, 80-74

SetDiffVersions procedure, 80-75

SetLockingOFF procedure, 80-77

SetLockingON procedure, 80-78

SetMultiWorkspaces, 80-79

SetWoOverwriteOFF, 80-80

SetWoOverwriteON, 80-81

SetWorkspaceLockModeOFF procedure, 80-82

SetWorkspaceLockModeON procedure, 80-83

SynchronizeSite procedure, 80-85

UnfreezeWorkspace procedure, 80-86

UnlockRows procedure, 80-87

DDL (data definition language) operations

beginning, 80-8

committing, 80-10

rolling back, 80-68

DDL. See data definition language

DEBUG_EXPTOC package, 92-1

DEFDEFAULTDEST view

adding destinations to, 13-3

removing destinations from, 13-5

deferred transactions

DefDefaultDest table

removing destinations from, 13-5

DEFDEFAULTDEST view

adding destination to, 13-3

removing destinations from, 13-5

deferred remote procedure calls (RPCs)

argument types, 12-3

argument values, 12-7

arguments to, 11-4

building, 11-2

executing immediately, 13-13

DEFSCHEDULE view

clearing statistics, 13-4

deleting from queue, 13-6

reexecuting, 13-9

scheduling execution, 13-19

starting, 11-6

DEFERROR view

deleting transactions from, 13-6

DEFSCHEDULE view

clearing statistics, 13-4

DELETE_ALL_ERRORS procedure, 4-13

DELETE_COLUMN member procedure, 108-21

DELETE_ERROR procedure, 4-14

DeleteSavepoint procedure, 80-22

deleting

savepoints, 80-22

workspace, 80-61

deployment templates

alter object, 56-6

alter parameters, 56-9

alter template, 56-4

alter user authorization, 56-11

alter user parameter values, 56-12

compare templates, 56-15

copy template, 56-16

create object from existing, 56-18

create template, 56-20

drop site instantiation, 55-2

dropping, 56-38

dropping all, 56-35

lock template, 56-52, 56-53

objects

creating, 56-22

dropping, 56-40

dropping all, 56-32

offline instantiation, 55-3, 56-47

online instantiation, 55-5, 56-50

parameters

creating, 56-25

dropping, 56-41

dropping all, 56-33

runtime parameters

creating, 56-45

deleting, 56-31

get ID, 56-44

inserting, 56-45

sites

dropping, 56-39

dropping all, 56-34

user authorizations

creating, 56-27

dropping, 56-42

dropping all, 56-35

user parameter values

creating, 56-29

dropping, 56-43

dropping all, 56-36

DESC_TAB datatype, 69-45

DESDecrypt procedure, 34-5, 34-10

DESEncrypt procedure, 34-4, 34-8

differences

between tables, 49-2

rectifying, 49-5

DisableVersioning procedure, 80-24

disabling

propagation, 13-21

workspace changes

freezing, 80-30

unfreezing, 80-86

DROP_APPLY procedure, 4-14

DROP_CAPTURE procedure

capture process

dropping, 8-8

DROP_EVALUATION_CONTEXT procedure, 64-14

DROP_PROPAGATION procedure, 47-7

DROP_RULE procedure, 64-15

DROP_RULE_SET procedure, 64-16

DropReplicationSupport procedure, 80-26

dynamic SQL

anonymous blocks and, 69-3

DBMS_SQL functions, using, 69-3

execution flow in, 69-5

E

ehlo() function

of UTL_SMTP, 100-10

e-mail

sending with UTL_SMTP, 100-1

e-mail from PL/SQL (email), 101-3

EnableVersioning procedure, 80-27

error queue

deleting errors, 4-13, 4-14

executing errors, 4-15, 4-16

getting error messages, 4-17

errors

returned by DBMS_ALERT package, 19-3

EVALUATE procedure, 63-3

exclusive locks, 80-78

EXECUTE member procedure, 108-9, 108-22

EXECUTE_ALL_ERRORS procedure, 4-15

EXECUTE_ERROR procedure, 4-16

execution flow

in dynamic SQL, 69-5

extend window

to create a new view, 27-2

extended availability, 53-10, 53-31, 53-84, 53-97, 53-102, 53-107

F

features, new, xxvii

fine-grained access control

DBMS_RLS package, 61-1

flush()

function of UTL_TCP, 101-18

FORCE parameter

and job-to-instance affinity, 20-2

FreezeWorkspace procedure, 80-30

freezing

workspace changes, 80-30

G

GenerateReplicationSupport procedure, 80-32

GET_ALL_NAMES member function, 109-7

GET_BASE_TABLE_NAME member function, 108-9

GET_BASE_TABLE_OWNER member function, 108-9

GET_COMMAND_TYPE member function, 108-35

GET_CURRENT_SCHEMA member function, 108-9

GET_ERROR_MESSAGE function, 4-17

get_host_address()

function of UTL_INADDR, 97-3

get_line()

function UTL_TCP, 101-17

GET_LOB_INFORMATION member procedure, 108-23

GET_LOB_OFFSET member function, 108-24

GET_LOB_OPERATION_SIZE member procedure, 108-25

GET_LOGON_USER member function, 108-11

GET_OBJECT_NAME member function, 108-35

GET_OBJECT_OWNER member function, 108-35

GET_OBJECT_TYPE member function, 108-11

get_raw()

function of UTL_TCP, 101-17

GET_SCN member function, 108-35

GET_SOURCE_DATABASE_NAME member function, 108-36

GET_TAG member function, 108-36

get_text()

function of UTL_TCP, 101-17

GET_TRANSACTION_ID member function, 108-36

GET_VALUE member function, 108-26, 109-8

GET_VALUES member function, 108-26

GetConflictWorkspace function, 80-34

GetDiffVersions function, 80-35

GetLockMode function, 80-35

GetMultiWorkspaces function, 80-36

GetOpContext function, 80-37

GetPrivs function, 80-38

GetSessionInfo function, 80-38

GetWorkspace function, 80-40

GotoWorkspace procedure, 80-43

GRANT_OBJECT_PRIVILEGE procedure, 64-17

GRANT_SYSTEM_PRIVILEGE procedure, 64-20

granting

Workspace Manager privileges

system, 80-44

workspace, 80-46

GrantSystemPriv procedure, 80-44

GrantWorkspacePriv procedure, 80-46

H

helo() function

of UTL_SMTP, 100-9

hierarchy

removing, 80-62

history option

EnableVersioning procedure, 80-28

I

importing

materialized views

offline instantiation and, 37-2, 37-4

replication groups

offline instantiation and, 36-3, 36-6

status check, 53-95

instantiation

aborting database preparation, 8-3

aborting schema preparation, 8-3

aborting table preparation, 8-4

DROP_SITE_INSTANTIATION procedure, 55-2, 56-39

global SCN, 4-23

offline

INSTANTIATE_OFFLINE function, 55-3, 56-47

online

INSTANTIATE_ONLINE function, 55-5, 56-50

preparing a database for, 8-8

preparing a schema for, 8-9

preparing a table for, 8-10

schema SCN, 4-32

table SCN, 4-35

internet addressing

using UTL_INADDR, 97-1

IS_NULL_TAG member function, 108-36

IsWorkspaceOccupied function, 80-48

J

jobs

queues for

removing jobs from, 13-24

L

LCR$_DDL_RECORD type, 108-3

LCR$_ROW_LIST type, 108-40

LCR$_ROW_RECORD type, 108-15

LCR$_ROW_UNIT type, 108-41

GET_LOB_INFORMATION member procedure, 108-23

GET_LOB_OPERATION_SIZE member procedure, 108-25

SET_LOB_INFORMATION member procedure, 108-28

SET_LOB_OPERATION_SIZE member procedure, 108-30

LOB columns with versioned tables, 80-17

LOBs

DBMS_LOB package, 23-1

lock mode

getting, 80-35

locking table rows, 80-49

LockRows procedure, 80-49

locks

disabling, 80-77

enabling, 80-78

log apply services

managing initialization parameters for logical standby databases, 29-2

logging of modifications

EnableVersioning history option, 80-29

logical change records (LCRs)

DDL LCRs, 108-3

getting base table name, 108-9

getting base table owner, 108-9

getting current schema, 108-9

getting logon user name, 108-11

getting object type, 108-11

setting base table name, 108-11

setting base table owner, 108-12

setting current schema, 108-12

setting DDL text, 108-13

setting logon user, 108-13

setting object type, 108-14

determining if tag is NULL, 108-36

executing, 108-9, 108-22

getting command type, 108-35

getting object name, 108-35

getting object owner, 108-35

getting SCN, 108-35

getting source database name, 108-36

getting tag, 108-36

getting transaction identifier, 108-36

LCR$_DDL_RECORD type, 108-3

LCR$_ROW_LIST type, 108-40

LCR$_ROW_RECORD type, 108-15

LCR$_ROW_UNIT type, 108-41

row LCRs, 108-15

adding value to column, 108-20

deleting value to column, 108-21

getting column value, 108-26

getting list of column values, 108-26

getting LOB offset, 108-24

renaming column, 108-27

setting column value, 108-31

setting list of column values, 108-32

setting LOB offset, 108-29

setting command type, 108-37

setting object name, 108-38

setting object owner, 108-38

setting source database name, 108-39

setting tag, 108-39

types, 108-1

M

mail() function

of UTL_SMTP, 100-11

master definition sites

relocating, 53-91

master groups

creating, 53-50

dropping, 53-65

quiescing, 53-105

resuming replication activity, 53-96

master sites

creating, 53-8

dropping, 53-93

propagating changes between, 13-19

master tables

adding columns to, 53-94

materialized view groups

creating, 53-55

materialized view logs

master table

purging, 33-7, 33-8

materialized view sites

changing masters, 53-105

dropping, 53-68

propagating changes to master, 13-19

refreshing, 53-87

materialized views

generating support for, 53-78

offline instantiation of, 37-2, 37-4

refreshing, 33-10, 33-12, 33-14

MergeTable procedure, 80-50

MergeWorkspace procedure, 80-52

merging

table changes, 80-50

workspaces, 80-52

messaging links

MQSeries, 31-10

queue properties, 31-12

methods

DBMS_MGWADM package, 31-2

DBMS_MGWMSG package, 32-2

migration

post-migration actions, 34-1

MQSeries

messaging links, 31-10

queue properties, 31-12

N

nested table

not supported for EnableVersioning, 80-29

new features, xxvii

noop() function

of UTL_SMTP, 100-17

O

object types

DBMS_MGWADM package, 31-2

DBMS_MGWMSG package, 32-2

objects

adding to materialized view sites, 53-56

altering, 53-28

creating, 53-51

for master group, 53-50

for master sites, 53-51

for materialized view sites, 53-56

dropping

materialized view site, 53-69

generating replication support for, 53-80

offline instantiation

INSTANTIATE_OFFLINE function, 55-3, 56-47

materialized views, 37-2, 37-4

replication groups, 36-2, 36-3, 36-5, 36-6, 36-7

online instantiation

INSTANTIATE_ONLINE function, 55-5, 56-50

open_connection()

function of UTL_TCP, 101-6

open_connection() function

of UTL_SMTP, 100-7

open_data() function

of UTL_SMTP, 100-14

operation context

getting, 80-37

OR REPLACE clause

for creating packages, 1-3

Oracle Advanced Queuing (Oracle AQ)

DBMS_AQADM package, 6-1

Oracle Streams

creating queues, 73-35

data dictionary

removing information, 73-32

Oracle-supplied types

logical change record (LCR) types, 108-1

rule types, 109-1

OUTLN_PKG package, 41-1

P

package overview, 1-2

package variables

i_am_a_refresh, 33-6

packages

creating, 1-3

referencing, 1-6

where documented, 1-7

parent workspace

conflicts with, 80-74

plan stability, 41-1

PL/SQL

datatypes, 14-6

numeric codes for, 14-8

functions

DBMS_MGWADM package subprograms, 31-12

DBMS_MGWMSG package subprograms, 32-9

procedures

DBMS_MGWADM package subprograms, 31-12

DBMS_MGWMSG package subprograms, 32-9

PREPARE_GLOBAL_INSTANTIATION procedure, 8-8

PREPARE_SCHEMA_INSTANTIATION procedure, 8-9

PREPARE_TABLE_INSTANTIATION procedure, 8-10

priority groups

adding members to, 53-16

altering members

priorities, 53-33

values, 53-35

creating, 53-60

dropping, 53-71

removing members from, 53-70, 53-72

site priority groups

adding members to, 53-17

privileges

getting, 80-38

granting, 80-44, 80-46

revoking, 80-65, 80-67

programmatic environments, 106-7

propagation

altering method, 53-27, 53-32

disabling, 13-21

of changes, 53-27

status of, 13-7

propagation jobs

altering, 47-3

creating, 47-4, 73-3, 73-11, 73-24

DBMS_PROPAGATION_ADM package, 47-1

dropping, 47-7

queues

creating, 73-35

rules

defining global, 73-3

defining schema, 73-11

defining table, 73-24

propagator

registering, 13-17

PURGE_SOURCE_CATALOG procedure, 73-32

purging

DBA_REPCATLOG table, 53-85

Q

queues

AnyData

creating, 73-35

queuing

DBMS_AQADM package, 6-1

quiescing

master groups, 53-105

quit() function

of UTL_SMTP, 100-18

R

rcpt() function

of UTL_SMTP, 100-12

RE$ATTRIBUTE_VALUE type, 109-4

RE$ATTRIBUTE_VALUE_LIST type, 109-4

RE$COLUMN_VALUE type, 109-5, 109-9

RE$COLUMN_VALUE_LIST type, 109-5

RE$NAME_ARRAY type, 109-6

RE$NV_ARRAY type, 109-6

RE$NV_LIST type, 109-6

ADD_PAIR member procedure, 109-7

GET_ALL_NAMES member function, 109-7

GET_VALUE member function, 109-8

REMOVE_PAIR member procedure, 109-8

RE$RULE_HIT type, 109-10

RE$RULE_HIT_LIST type, 109-10

RE$TABLE_ALIAS type, 109-11

RE$TABLE_ALIAS_LIST type, 109-11

RE$TABLE_VALUE type, 109-12

RE$TABLE_VALUE_LIST type, 109-12

RE$VARIABLE_TYPE type, 109-13

RE$VARIABLE_TYPE_LIST type, 109-15

RE$VARIABLE_VALUE type, 109-15

RE$VARIABLE_VALUE_LIST type, 109-15

read_line()

function of UTL_TCP, 101-15

read_raw()

function of UTL_TCP, 101-10

read_text()

function of UTL_TCP, 101-12

RecoverAllMigratingTables procedure, 80-54

RecoverMigratingTable procedure, 80-55

rectifying

tables, 49-5

refresh

materialized view sites, 53-87

materialized views, 33-10, 33-12, 33-14

refresh groups

adding members to, 51-2

creating, 51-6

deleting, 51-5

refresh interval

changing, 51-3

refreshing

manually, 51-8

removing members from, 51-9

refreshing

tables, 80-57

workspaces, 80-58

refreshing workspaces, 80-58

RefreshTable procedure, 80-57

RefreshWorkspace procedure, 80-58

registering

propagator for local database, 13-17

RelocateWriterSite procedure, 80-59

REMOVE_PAIR member procedure, 109-8

REMOVE_RULE procedure, 64-23, 73-34

RemoveWorkspace procedure, 80-61

RemoveWorkspaceTree procedure, 80-62

removing workspaces, 80-61

RENAME_COLUMN member procedure, 108-27

replicated objects

dropping from master sites, 53-67

replication

datetime datatypes

abbreviations, 1-6

disabling, 57-2

dropping support for, 80-26

enabling, 57-3

generating support for, 80-32

interval datatypes

abbreviations, 1-6

relocating writer site, 80-59

synchronizing local site, 80-85

replication groups

offline instantiation of, 36-2, 36-3, 36-5, 36-6, 36-7

replies function

of UTL_SMTP, 100-7

reply functions

of UTL_SMTP, 100-7

ResolveConflicts procedure, 80-63

resolving conflicts, 80-63

beginning, 80-9

committing, 80-12

rolling back, 80-69

resuming replication activity, 53-96

REVOKE_OBJECT_PRIVILEGE procedure, 64-25

REVOKE_SYSTEM_PRIVILEGE procedure, 64-26

RevokeSystemPriv procedure, 80-65

RevokeWorkspacePriv procedure, 80-67

revoking privileges, 80-65, 80-67

RollbackDDL procedure, 80-68

RollbackResolve procedure, 80-69

RollbackTable procedure, 80-70

RollbackToSP procedure, 80-72

RollbackWorkspace procedure, 80-73

rolling back

workspace to savepoint, 80-72

rolling back tables, 80-70

rolling back workspaces, 80-73

ROWID datatype

DBMS_ROWID package, 62-1

extended format, 62-13

rows

locking, 80-49

unlocking, 80-87

rset() function

of UTL_SMTP, 100-15

rule sets

adding rules to, 64-3

creating, 64-13

dropping, 64-16

removing rules from, 64-23

rules

action contexts

adding name-value pairs, 109-7

getting name-value pairs, 109-7

getting value for name, 109-8

removing name-value pairs, 109-8

altering, 64-5

creating, 64-11

DBMS_RULE package, 63-1

DBMS_RULE_ADM package, 64-1

dropping, 64-15

evaluation, 63-3

evaluation contexts

creating, 64-8

dropping, 64-14

object privileges

granting, 64-17

revoking, 64-25

propagation jobs

removing, 73-34

RE$ATTRIBUTE_VALUE type, 109-4

RE$ATTRIBUTE_VALUE_LIST type, 109-4

RE$COLUMN_VALUE type, 109-5, 109-9

RE$COLUMN_VALUE_LIST type, 109-5

RE$NAME_ARRAY type, 109-6

RE$NV_ARRAY type, 109-6

RE$NV_LIST type, 109-6

RE$RULE_HIT type, 109-10

RE$RULE_HIT_LIST type, 109-10

RE$TABLE_ALIAS type, 109-11

RE$TABLE_ALIAS_LIST type, 109-11

RE$TABLE_VALUE type, 109-12

RE$TABLE_VALUE_LIST type, 109-12

RE$VARIABLE_TYPE type, 109-13

RE$VARIABLE_TYPE_LIST type, 109-15

RE$VARIABLE_VALUE type, 109-15

RE$VARIABLE_VALUE_LIST type, 109-15

subset

defining, 73-19

system privileges

granting, 64-20

revoking, 64-26

system-created

global apply, 73-7

global capture, 73-7

global propagation, 73-3

global schema, 73-15

removing, 73-34

schema capture, 73-15

schema propagation, 73-11

subset apply, 73-19

table apply, 73-28

table capture, 73-28

table propagation, 73-24

types, 109-1

S

savepoints

altering, 80-6

creating, 80-19

deleting, 80-22

rolling back to, 80-72

SDO_CD package, 1-16

SDO_GEOM package, 1-16

SDO_LRS package, 1-17

SDO_MIGRATE package, 1-20

SDO_TUNE package, 1-21

SDO_UTIL Package, 1-22

session context

GetSessionInfo function, 80-38

SET_BASE_TABLE_NAME member procedure, 108-11

SET_BASE_TABLE_OWNER member procedure, 108-12

SET_COMMAND_TYPE member procedure, 108-37

SET_CURRENT_SCHEMA member procedure, 108-12

SET_DDL_TEXT member procedure, 108-13

set_disabled, 13-21

SET_DML_HANDLER procedure, 4-18

SET_GLOBAL_INSTANTIATION procedure, 4-23

SET_KEY_COLUMNS procedure, 4-26

SET_LOB_INFORMATION member procedure, 108-28

SET_LOB_OFFSET member procedure, 108-29

SET_LOB_OPERATION_SIZE member procedure, 108-30

SET_LOGON_USER member procedure, 108-13

SET_OBJECT_NAME member procedure, 108-38

SET_OBJECT_OWNER member procedure, 108-38

SET_OBJECT_TYPE member procedure, 108-14

SET_PARAMETER procedure, 8-11

apply process, 4-28

SET_SCHEMA_INSTANTIATION procedure, 4-32

SET_SOURCE_DATABASE_NAME member procedure, 108-39

SET_TABLE_INSTANTIATION procedure, 4-35

SET_TAG member procedure, 108-39

SET_UP_QUEUE procedure, 73-35

SET_UPDATE_CONFLICT_HANDLER procedure, 4-37

SET_VALUE member procedure, 108-31

SET_VALUES member procedure, 108-32

SetConflictWorkspace procedure, 80-74

SetDiffVersions procedure, 80-75

SetLockingON procedure, 80-77, 80-78

SetMultiWorkspaces procedure, 80-79

SetWoOverwriteOFF procedure, 80-80

SetWoOverwriteON procedure, 80-81

SetWorkspaceLockModeOFF procedure, 80-82

SetWorkspaceLockModeON procedure, 80-83

shared locks, 80-78

site priority

altering, 53-36

site priority groups

adding members to, 53-17

creating

syntax, 53-61

dropping, 53-73

removing members from, 53-74

snapshot. See DBMS_MVIEW, 33-1

SQL statements

larger than 32 KB, 69-27

SQL*Plus

creating a sequence, 1-6

staging

queues

creating, 73-35

START_APPLY procedure, 4-41

START_CAPTURE procedure, 8-14

statistics

clearing, 13-4

collecting, 53-90

purging, 53-86

status

propagation, 13-7

STOP_APPLY procedure, 4-42

STOP_CAPTURE procedure, 8-15

stored outlines

OUTLN_PKG package, 41-1

subscriber view

dropping, 27-2

subscriber views

removing, 27-2

subscribers

drop the subscriber view, 27-2

drop the subscription, 27-2

extend the window to create a new view, 27-2

purge the subscription window, 27-2

removing subscriber views, 27-2

retrieve change data from the subscriber views, 27-2

subscription window

purging, 27-2

SynchronizeSite procedure, 80-85

SYS.ANYDATA, 12-7

system privileges, 80-44

T

tables

comparing, 49-2

rectifying, 49-5

table items as arrays, 69-29

TRACETAB.SQL, 74-3

U

UnfreezeWorkspace procedure, 80-86

unfreezing

workspaces, 80-86

unlocking

table rows, 80-87

UnlockRows procedure, 80-87

upgrading

post-upgrade actions, 34-1

UTL_COLL package, 93-1

UTL_ENCODE package, 94-1

UTL_FILE package, 95-1

UTL_INADDR package, 97-1

UTL_PG package, 1-22

UTL_RAW package, 94-1, 98-1

UTL_REF package, 99-1

UTL_SMTP package, 100-1

UTL_TCP package, 101-1

V

versioning

disabling, 80-24

enabling, 80-27

VIEW_WO_OVERWRITE mode

disabling, 80-80

enabling, 80-81

views

summary, 31-34

vrfy() function

of UTL_SMTP, 100-16

W

workspace lock mode

disabling, 80-82

enabling, 80-83

workspaces

altering description, 80-7

compressing, 80-13, 80-16

continually refreshed, 80-21

creating, 80-20

freezing, 80-30

getting, 80-40

going to, 80-43

unfreezing, 80-86

write_data() function

of UTL_SMTP, 100-14

write_line()

function of UTL_TCP, 101-16

write_raw()

function of UTL_TCP, 101-11

write_raw_data() function

of UTL_SMTP, 100-14

write_text()

function of UTL_TCP, 101-14