Index

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

A

Advanced Queuing

DBMS_AQADM package, 5-1

altering

propagation method, 48-28, 48-32

savepoints, 70-5

workspaces, 70-6

AlterSavepoint procedure, 70-5

AlterWorkspace procedure, 70-6

anonymous PL/SQL blocks

dynamic SQL and, 62-3

arrays

BIND_ARRAY procedure, 62-7

bulk DML using DBMS_SQL, 62-29

availability

extended, 48-11, 48-31, 48-87, 48-101, 48-107, 48-111

available()

function of UTL_TCP, 83-9

B

BeginResolve procedure, 70-7

C

catproc.sql script, 1-3

Change Data Capture

DBMS_LOGMNR_CDC_PUBLISH package, 25-1

DBMS_LOGMNR_CDC_SUBSCRIBE package, 26-1

character sets

ANY_CS, 22-3

child workspace

merging, 70-40, 70-43

refreshing, 70-41, 70-43

removing, 70-45

CLOB datatype

NCLOBs, 22-3

CLOBs (character large objects) datatype

NCLOBS, 22-3

close_all_connections()

function of UTL_TCP, 83-19

close_connection()

function of UTL_TCP, 83-18

close_data() function

of UTL_SMTP, 82-15

collections

table items, 62-29

columns

adding to master tables, 48-98

column groups

adding members to, 48-8

creating, 48-61, 48-85

dropping, 48-66

removing members from, 48-67

command() function

of UTL_SMTP, 82-10

command_replies() function

of UTL_SMTP, 82-10

CommitResolve procedure, 70-8

comparing

tables, 44-3

compressing workspaces, 70-9, 70-11

CompressWorkspace procedure, 70-9

CompressWorkspaceTree procedure, 70-11

conflict management, 70-46

beginning resolution, 70-7

committing resolution, 70-8

rolling back resolution, 70-51

showing conflicts, 70-56

conflict resolution

additive method, 48-20

statistics, 48-40, 48-94

connection

function of UTL_TCP, 83-4

connection function

of UTL_SMTP, 82-7

context of current operation

getting, 70-26

continually refreshed workspace, 70-16

CopyForUpdate procedure, 70-13

CREATE PACKAGE BODY command, 1-3

CREATE PACKAGE command, 1-3

CreateSavepoint procedure, 70-14

CreateWorkspace procedure, 70-16

creating

new workspaces, 70-16

packages, 1-3

savepoints, 70-14

CRLF (carriage-return line-feed)

function of UTL_TCP, 83-6

cursors

DBMS_SQL package, 62-5

D

data definition language

altering replicated objects, 48-29

asynchronous, 48-80

supplying asynchronous, 48-80

data() function

of UTL_SMTP, 82-14

database tables

creating for DBMS_TRACE, 64-3

datatypes

DBMS_DESCRIBE, 13-4

DESC_TAB, 62-44

PL/SQL

numeric codes for, 13-8

ROWID, 57-1

DBA_REPCATLOG view

purging, 48-88

DBA_REPCOLUMN_GROUP view

updating, 48-41

DBA_REPGROUP view

updating, 48-44

DBA_REPOBJECT view

updating, 48-45

DBA_REPPRIORITY_GROUP view

updating, 48-43

DBA_REPRESOLUTION view

updating, 48-48

DBA_REPRESOLUTION_STATISTICS view

purging, 48-89

DBA_REPSITES view

updating, 48-46

DBMS_ALERT package, 2-1

DBMS_APPLICATION_INFO package, 3-2

DBMS_AQ package, 4-1

DBMS_AQADM package, 5-1

DBMS_AQELM package, 6-1, 6-2

DBMS_BACKUP_RESTORE package, 7-1

DBMS_DDL package, 8-1

DBMS_DEBUG package, 9-1

DBMS_DEFER package, 10-1

ANY_CHAR_ARG procedure, 10-5

ANY_CLOB_ARG procedure, 10-5

ANY_VARCHAR2_ARG procedure, 10-5

ANYDATA_ARG procedure, 10-5

BLOB_ARG procedure, 10-5

CALL procedure, 10-3

CHAR_ARG procedure, 10-5

CLOB_ARG procedure, 10-5

COMMIT_WORK procedure, 10-4

datatype_ARG procedure, 10-5

DATE_ARG procedure, 10-5

IDS_ARG procedure, 10-5

IYM_ARG procedure, 10-5

NCHAR_ARG procedure, 10-5

NCLOB_ARG procedure, 10-5

NUMBER_ARG procedure, 10-5

NVARCHAR2_ARG procedure, 10-5

RAW_ARG procedure, 10-5

ROWID_ARG procedure, 10-5

TIMESTAMP_ARG procedure, 10-5

TRANSACTION procedure, 10-8

TSLTZ_ARG procedure, 10-5

TSTZ_ARG procedure, 10-5

VARCHAR2_ARG procedure, 10-5

DBMS_DEFER_QUERY package, 11-1

GET_ANYDATA_ARG procedure, 11-9

GET_ARG_FORM function, 11-3

GET_ARG_TYPE function, 11-5

GET_BLOB_ARG procedure, 11-9

GET_CALL_ARGS procedure, 11-7

GET_CHAR_ARG procedure, 11-9

GET_CLOB_ARG procedure, 11-9

GET_datatype_ARG function, 11-9

GET_DATE_ARG procedure, 11-9

GET_IDS_ARG procedure, 11-9

GET_IYM_ARG procedure, 11-9

GET_NCHAR_ARG procedure, 11-9

GET_NCLOB_ARG procedure, 11-9

GET_NUMBER_ARG procedure, 11-9

GET_NVARCHAR2_ARG procedure, 11-9

GET_OBJECT_NULL_VECTOR_ARG function, 11-12

GET_RAW_ARG procedure, 11-9

GET_ROWID_ARG procedure, 11-9

GET_TIMESTAMP_ARG procedure, 11-9

GET_TSLTZ_ARG procedure, 11-9

GET_TSTZ_ARG procedure, 11-9

GET_VARCHAR2_ARG procedure, 11-9

DBMS_DEFER_SYS package

ADD_DEFAULT_DEST procedure, 12-4

CLEAR_PROP_STATISTICS procedure, 12-5

DELETE_DEF_DESTINATION procedure, 12-6

DELETE_DEFAULT_DEST procedure, 12-6

DELETE_ERROR procedure, 12-7

DELETE_TRAN procedure, 12-8, 12-9, 12-11

DISABLED function, 12-9

EXCLUDE_PUSH function, 12-10

EXECUTE_ERROR procedure, 12-11

EXECUTE_ERROR_AS_USER procedure, 12-12

PURGE function, 12-13

PUSH function, 12-16

REGISTER_PROPAGATOR procedure, 12-19

SCHEDULE_EXECUTION procedure, 12-22

SCHEDULE_PURGE procedure, 12-20

SCHEDULE_PUSH procedure, 12-22

SET_DISABLED procedure, 12-24

UNREGISTER_PROPAGATOR procedure, 12-26

UNSCHEDULE_PURGE procedure, 12-27

UNSCHEDULE_PUSH procedure, 12-27

DBMS_DESCRIBE package, 13-1

DBMS_DISTRIBUTED_TRUST_ADMIN package, 14-1

DBMS_FGA package, 15-1

DBMS_FLASHBACK package, 16-1, 16-6

DBMS_HS_PASSTHROUGH package, 17-1

DBMS_IOT package, 18-1

DBMS_JOB package, 19-1

and instance affinity, 19-2

DBMS_LOB package, 22-1

DBMS_LOCK package, 23-1

DBMS_LOGMNR package, 24-1

ADD_LOGFILE procedure, 24-4

COLUMN_PRESENT function, 24-9

constants, 24-2

END_LOGMNR procedure, 24-8

MINE_VALUE function, 24-8

START_LOGMNR procedure, 24-5

DBMS_LOGMNR_CDC_PUBLISH package, 25-1

ALTER_CHANGE_TABLE procedure, 25-8

CREATE_CHANGE_SOURCE procedure, 25-3

CREATE_CHANGE_TABLE procedure, 25-3

DROP_CHANGE_TABLE procedure, 25-16

DBMS_LOGMNR_CDC_SUBSCRIBE package, 26-1

ACTIVATE_SUB SCRIPTION procedure, 26-9

DROP_SUBSCRIBER_VIEW procedure, 26-13

DROP_SUBSCRIPTION procedure, 25-14, 26-16

EXTEND_WINDOW procedure, 26-10

EXTEND_WINDOW_LIST procedure, 26-11

GET_SUBSCRIPTION_HANDLE procedure, 26-5

PREPARE_SUBSCRIBER_VIEW procedure, 26-11

PREPARE_UNBOUNDED_VIEW procedure, 26-13

PURGE_WINDOW procedure, 26-14

SUBSCRIBE procedure, 26-6

usage examples, 26-16

DBMS_LOGMNR_D package, 27-1

BUILD procedure, 27-3

DBMS_MVIEW package

BEGIN_TABLE_REORGANIZATION procedure, 29-3

END_TABLE_REORGANIZATION procedure, 29-4

EXPLAIN_MVIEW procedure, 29-5

EXPLAIN_REWRITE procedure, 29-6

I_AM_A_REFRESH function, 29-7

PMARKER function, 29-8

PURGE_DIRECT_LOAD_LOG procedure, 29-8

PURGE_LOG procedure, 29-9

PURGE_MVIEW_FROM_LOG procedure, 29-10

REFRESH procedure, 29-12

REFRESH_ALL_MVIEWS procedure, 29-15

REFRESH_DEPENDENT procedure, 29-16

REGISTER_MVIEW procedure, 29-18

UNREGISTER_MVIEW procedure, 29-21

DBMS_OBFUSCATION_TOOLKIT package, 30-1

DBMS_OFFLINE_OG package

BEGIN_INSTANTIATION procedure, 32-3

BEGIN_LOAD procedure, 32-4

END_INSTANTIATION procedure, 32-6

END_LOAD procedure, 32-7

RESUME_SUBSET_OF_MASTERS procedure, 32-9

DBMS_OFFLINE_SNAPSHOT package

BEGIN_LOAD procedure, 33-3

END_LOAD procedure, 33-5

DBMS_OLAP package, 34-1

DBMS_ORACLE_TRACE_AGENT package, 35-1

DBMS_ORACLE_TRACE_USER package, 36-1

DBMS_OUTLN package, 37-1

DBMS_OUTLN_EDIT package, 38-1

DBMS_OUTPUT package, 39-1

DBMS_PCLXUTIL package, 40-1

DBMS_PIPE package, 41-1

DBMS_PROFILER package, 42-1

DBMS_RANDOM package, 43-1

DBMS_RECTIFIER_DIFF package

DIFFERENCES procedure, 44-3

RECTIFY procedure, 44-6

DBMS_REFRESH package

ADD procedure, 46-3

CHANGE procedure, 46-4

DESTROY procedure, 46-6

MAKE procedure, 46-7

REFRESH procedure, 46-10

SUBTRACT procedure, 46-10

DBMS_REPAIR package, 47-1

DBMS_REPCAT package

ADD_DELETE_RESOLUTION procedure, 48-20

ADD_GROUPED_COLUMN procedure, 48-8

ADD_MASTER_DATABASE procedure, 48-9

ADD_NEW_MASTERS procedure, 48-11

ADD_PRIORITY_CHAR procedure, 48-17

ADD_PRIORITY_datatype procedure, 48-17

ADD_PRIORITY_DATE procedure, 48-17

ADD_PRIORITY_NUMBER procedure, 48-17

ADD_PRIORITY_VARCHAR2 procedure, 48-17

ADD_SITE_PRIORITY_SITE procedure, 48-19

ADD_UNIQUENESS_RESOLUTION procedure, 48-20

ADD_UPDATE_RESOLUTION procedure, 48-20

ALTER_CATCHUP_PARAMETERS procedure, 48-26

ALTER_MASTER_PROPAGATION procedure, 48-28

ALTER_MASTER_REPOBJECT procedure, 48-29

ALTER_MVIEW_PROPAGATION procedure, 48-32

ALTER_PRIORITY procedure, 48-34

ALTER_PRIORITY_CHAR procedure, 48-35

ALTER_PRIORITY_datatype procedure, 48-35

ALTER_PRIORITY_DATE procedure, 48-35

ALTER_PRIORITY_NUMBER procedure, 48-35

ALTER_PRIORITY_RAW procedure, 48-35

ALTER_SITE_PRIORITY procedure, 48-37

ALTER_SITE_PRIORITY_SITE procedure, 48-39

CANCEL_STATISTICS procedure, 48-40

COMMENT_ON_COLUMN_GROUP procedure, 48-41

COMMENT_ON_DELETE_RESOLUTION procedure, 48-48

COMMENT_ON_MVIEW_REPSITES procedure, 48-42

COMMENT_ON_PRIORITY_GROUP procedure, 48-43

COMMENT_ON_REPGROUP procedure, 48-44

COMMENT_ON_REPOBJECT procedure, 48-45

COMMENT_ON_REPSITES procedure, 48-46

COMMENT_ON_SITE_PRIORITY procedure, 48-43

COMMENT_ON_UNIQUE_RESOLUTION procedure, 48-48

COMMENT_ON_UPDATE_RESOLUTION procedure, 48-48

COMPARE_OLD_VALUES procedure, 48-50

CREATE_MASTER_REPGROUP procedure, 48-52

CREATE_MASTER_REPOBJECT procedure, 48-53

CREATE_MVIEW_REPGROUP procedure, 48-57

CREATE_MVIEW_REPOBJECT procedure, 48-58

DEFINE_COLUMN_GROUP procedure, 48-61

DEFINE_PRIORITY_GROUP procedure, 48-62

DEFINE_SITE_PRIORITY procedure, 48-64

DO_DEFERRED_REPCAT_ADMIN procedure, 48-65

DROP_COLUMN_GROUP procedure, 48-66

DROP_DELETE_RESOLUTION procedure, 48-78

DROP_GROUPED_COLUMN procedure, 48-67

DROP_MASTER_REPGROUP procedure, 48-68

DROP_MASTER_REPOBJECT procedure, 48-69

DROP_MVIEW_REPGROUP procedure, 48-71

DROP_MVIEW_REPOBJECT procedure, 48-72

DROP_PRIORITY procedure, 48-73

DROP_PRIORITY_CHAR procedure, 48-75

DROP_PRIORITY_datatype procedure, 48-75

DROP_PRIORITY_DATE procedure, 48-75

DROP_PRIORITY_GROUP procedure, 48-74

DROP_PRIORITY_NUMBER procedure, 48-75

DROP_PRIORITY_VARCHAR2 procedure, 48-75

DROP_SITE_PRIORITY procedure, 48-76

DROP_SITE_PRIORITY_SITE procedure, 48-77

DROP_UNIQUE_RESOLUTION procedure, 48-78

DROP_UPDATE_RESOLUTION procedure, 48-78

EXECUTE_DDL procedure, 48-80

GENERATE_MVIEW_SUPPORT procedure, 48-82

GENERATE_REPLICATION_SUPPORT procedure, 48-83

MAKE_COLUMN_GROUP procedure, 48-85

PREPARE_INSTANTIATED_MASTERS procedure, 48-87

PURGE_MASTER_LOG procedure, 48-88

PURGE_STATISTICS procedure, 48-89

REFRESH_MVIEW_REPGROUP procedure, 48-90

REGISTER_MVIEW_REPGROUP procedure, 48-92

REGISTER_STATISTICS procedure, 48-94

RELOCATE_MASTERDEF procedure, 48-95

REMOVE_MASTER_DATABASES procedure, 48-97

RENAME_SHADOW_COLUMN_GROUP procedure, 48-98

REPCAT_IMPORT_CHECK procedure, 48-99

RESUME_MASTER_ACTIVITY procedure, 48-100

RESUME_PROPAGATION_TO_MDEF procedure, 48-101

SEND_OLD_VALUES procedure, 48-102

SET_COLUMNS procedure, 48-52, 48-105

SPECIFY_NEW_MASTERS procedure, 48-107

SUSPEND_MASTER_ACTIVITY procedure, 48-109

SWITCH_MVIEW_MASTER procedure, 48-110

UNDO_ADD_NEW_MASTERS_REQUEST procedure, 48-111

UNREGISTER_MVIEW_REPGROUP procedure, 48-114

VALIDATE procedure, 48-114

WAIT_MASTER_LOG procedure, 48-118

DBMS_REPCAT_ADMIN package

GRANT_ADMIN_ANY_SCHEMA procedure, 49-3

GRANT_ADMIN_SCHEMA procedure, 49-4

REGISTER_USER_REPGROUP procedure, 49-5

REVOKE_ADMIN_ANY_SCHEMA procedure, 49-7

REVOKE_ADMIN_SCHEMA procedure, 49-8

UNREGISTER_USER_REPGROUP procedure, 49-9

DBMS_REPCAT_INSTANTIATE package

DROP_SITE_INSTANTIATION procedure, 50-3

INSTANTIATE_OFFLINE function, 50-3

INSTANTIATE_ONLINE function, 50-6

DBMS_REPCAT_RGT package

ALTER_REFRESH_TEMPLATE procedure, 51-5

ALTER_TEMPLATE_OBJECT procedure, 51-7

ALTER_TEMPLATE_PARM procedure, 51-10

ALTER_USER_AUTHORIZATION procedure, 51-12

ALTER_USER_PARM_VALUE procedure, 51-14

COMPARE_TEMPLATES function, 51-16

COPY_TEMPLATE function, 51-18

CREATE_OBJECT_FROM_EXISTING function, 51-20

CREATE_REFRESH_TEMPLATE function, 51-22

CREATE_TEMPLATE_OBJECT function, 51-24

CREATE_TEMPLATE_PARM function, 51-27

CREATE_USER_AUTHORIZATION function, 51-30

CREATE_USER_PARM_VALUE function, 51-31

DELETE_RUNTIME_PARMS procedure, 51-33

DROP_ALL_OBJECTS procedure, 51-34

DROP_ALL_TEMPLATE_PARMS procedure, 51-36

DROP_ALL_TEMPLATE_SITES procedure, 51-37

DROP_ALL_TEMPLATES procedure, 51-38

DROP_ALL_USER_AUTHORIZATIONS procedure, 51-38

DROP_ALL_USER_PARM_VALUES procedure, 51-39

DROP_REFRESH_TEMPLATE procedure, 51-40

DROP_SITE_INSTANTIATION procedure, 51-41

DROP_TEMPLATE_OBJECT procedure, 51-42

DROP_TEMPLATE_PARM procedure, 51-44

DROP_USER_AUTHORIZATION procedure, 51-45

DROP_USER_PARM_VALUE procedure, 51-46

GET_RUNTIME_PARM_ID function, 51-47

INSERT_RUNTIME_PARMS procedure, 51-47

INSTANTIATE_OFFLINE function, 51-49

INSTANTIATE_ONLINE function, 51-52

LOCK_TEMPLATE_EXCLUSIVE procedure, 51-55

LOCK_TEMPLATE_SHARED procedure, 51-55

DBMS_REPUTIL package

FROM_REMOTE function, 52-4

GLOBAL_NAME function, 52-5

MAKE_INTERNAL_PKG procedure, 52-5

REPLICATION_IS_ON function, 52-4

REPLICATION_OFF procedure, 52-3

REPLICATION_ON procedure, 52-3

SYNC_UP_REP procedure, 52-6

DBMS_RESOURCE_MANAGER package, 53-1

DBMS_RESOURCE_MANAGER_PRIVS package, 54-1

DBMS_RESUMABLE package, 55-1

DBMS_RLS package, 56-1

DBMS_ROWID package, 57-1

DBMS_SESSION package, 58-1

DBMS_SHARED_POOL package, 59-1

DBMS_SPACE package, 60-1

DBMS_SPACE_ADMIN package, 61-1

DBMS_STATS package, 63-1

DBMS_TRACE package, 64-1

DBMS_TRANSACTION package, 65-1

DBMS_TRANSFORM package, 66-1

DBMS_TTS package, 67-1

DBMS_UTILITY package, 69-1

DBMS_WM package, 70-1

DDL. See data definition language

DEBUG_EXPTOC package, 74-1

DEFDEFAULTDEST view

adding destinations to, 12-4

removing destinations from, 12-6

deferred transactions

DefDefaultDest table

removing destinations from, 12-6

DEFDEFAULTDEST view

adding destination to, 12-4

removing destinations from, 12-6

deferred remote procedure calls (RPCs)

argument types, 11-5

argument values, 11-9

arguments to, 10-5

building, 10-3

executing immediately, 12-16

DEFSCHEDULE view

clearing statistics, 12-5

deleting from queue, 12-8

re-executing, 12-11

scheduling execution, 12-22

starting, 10-8

DEFERROR view

deleting transactions from, 12-7

DEFSCHEDULE view

clearing statistics, 12-5

DeleteSavepoint procedure, 70-17

deleting

savepoints, 70-17

workspaces, 70-44

deployment templates

alter object, 51-7

alter parameters, 51-10

alter template, 51-5

alter user authorization, 51-12

alter user parameter values, 51-14

compare templates, 51-16

copy template, 51-18

create object from existing, 51-20

create template, 51-22

drop site instantiation, 50-3

dropping, 51-40

dropping all, 51-38

lock template, 51-55

objects

creating, 51-24

dropping, 51-42

dropping all, 51-34

offline instantiation, 50-3, 51-49

online instantiation, 50-6, 51-52

parameters

creating, 51-27

dropping, 51-44

dropping all, 51-36

runtime parameters

creating, 51-47

deleting, 51-33

get ID, 51-47

inserting, 51-47

sites

dropping, 51-41

dropping all, 51-37

user authorizations

creating, 51-30

dropping, 51-45

dropping all, 51-38

user parameter values

creating, 51-31

dropping, 51-46

dropping all, 51-39

DESC_TAB datatype, 62-44

DESDecrypt procedure, 30-6, 30-11

DESEncrypt procedure, 30-5, 30-9

differences

between tables, 44-3

rectifying, 44-6

DisableVersioning procedure, 70-19

disabling

propagation, 12-24

disabling changes, 70-22

unfreezing, 70-66

dynamic SQL

anonymous blocks and, 62-3

DBMS_SQL functions, using, 62-3

execution flow in, 62-5

E

ehlo() function

of UTL_SMTP, 82-11

e-mail

sending with UTL_SMTP, 82-1

EnableVersioning procedure, 70-21

errors

returned by DBMS_ALERT package, 18-3

exclusive locks, 70-60

execution flow

in dynamic SQL, 62-5

extend window

to create a new view, 26-2

extended availability, 48-11, 48-31, 48-87, 48-101, 48-107, 48-111

F

features, new, xxvii

filenames

normalization of with DBMS_BACKUP_RESTORE, 7-2

fine-grained access control

DBMS_RLS package, 56-1

flush()

function of UTL_TCP, 83-18

FORCE parameter

and job-to-instance affinity, 19-2

FreezeWorkspace procedure, 70-22

freezing workspace changes, 70-22

unfreezing, 70-66

functions

GetConflictWorkspace, 70-24

GetDiffVersions, 70-24

GetLockMode, 70-25

GetMultiWorkspaces, 70-26

GetOpContext, 70-26

GetPrivs, 70-27

GetWorkspace, 70-28

IsWorkspaceOccupied, 70-36

G

get_host_address()

function of UTL_INADDR, 79-3

get_line()

function UTL_TCP, 83-17

get_raw()

function of UTL_TCP, 83-17

get_text()

function of UTL_TCP, 83-17

GetConflictWorkspace function, 70-24

GetDiffVersions function, 70-24

GetLockMode function, 70-25

GetMultiWorkspaces, 70-26

GetOpContext function, 70-26

GetPrivs function, 70-27

GetWorkspace function, 70-28

GotoWorkspace procedure, 70-31

granting privileges

system, 70-32

workspace, 70-34

GrantSystemPriv procedure, 70-32

GrantWorkspacePriv procedure, 70-34

H

helo() function

of UTL_SMTP, 82-10

hierarchy

removing, 70-45

I

importing

materialized views

offline instantiation and, 33-3, 33-5

replication groups

offline instantiation and, 32-4, 32-7

status check, 48-99

instantiation

DROP_SITE_INSTANTIATION procedure, 50-3, 51-41

offline

INSTANTIATE_OFFLINE function, 50-3, 51-49

online

INSTANTIATE_ONLINE function, 50-6, 51-52

internet addressing

using UTL_INADDR, 79-1

IsWorkspaceOccupied function, 70-36

J

jobs

queues for

removing jobs from, 12-27

L

LOB columns with versioned tables, 70-13

LOBs

DBMS_LOB package, 22-1

lock mode

getting, 70-25

locking table rows, 70-37

LockRows procedure, 70-37

locks

disabling, 70-59

enabling, 70-60

M

mail() function

of UTL_SMTP, 82-12

master definition sites

relocating, 48-95

master groups

creating, 48-52

dropping, 48-68

quiescing, 48-109

resuming replication activity, 48-100

master sites

creating, 48-9

dropping, 48-97

propagating changes between, 12-22

master tables

adding columns to, 48-98

materialized view groups

creating, 48-57

materialized view logs

master table

purging, 29-8, 29-9, 29-10

materialized view sites

changing masters, 48-110

dropping, 48-71

propagating changes to master, 12-22

refreshing, 48-90

materialized views

generating support for, 48-82

offline instantiation of, 33-3, 33-5

refreshing, 29-12, 29-15, 29-16

MergeTable procedure, 70-38, 70-43

MergeWorkspace procedure, 70-40

merging table changes, 70-38

merging tables, 70-43

merging workspaces, 70-40

migration

post-migration actions, 7-1, 30-1

N

national language support

NCLOBs, 22-3

new features, xxvii

noop() function

of UTL_SMTP, 82-18

O

objects

adding to materialized view sites, 48-58

altering, 48-29

creating, 48-53

for master group, 48-52

for master sites, 48-53

for materialized view sites, 48-58

dropping

materialized view site, 48-72

generating replication support for, 48-83

offline instantiation

INSTANTIATE_OFFLINE function, 50-3, 51-49

materialized views, 33-3, 33-5

replication groups, 32-3, 32-4, 32-6, 32-7, 32-9

online instantiation

INSTANTIATE_ONLINE function, 50-6, 51-52

open_connection()

function of UTL_TCP, 83-6

open_connection() function

of UTL_SMTP, 82-9

open_data() function

of UTL_SMTP, 82-15

operation context

getting, 70-26

OR REPLACE clause

for creating packages, 1-3

Oracle Advanced Queuing (Oracle AQ)

DBMS_AQADM package, 5-1

OUTLN_PKG package, 37-1

P

package overview, 1-2

package variables

i_am_a_refresh, 29-7

packages

creating, 1-3

referencing, 1-6

where documented, 1-7

parent workspace

conflicts with, 70-56

plan stability, 37-1

PL/SQL

datatypes, 13-6

numeric codes for, 13-8

priority groups

adding members to, 48-17

altering members

priorities, 48-34

values, 48-35

creating, 48-62

dropping, 48-74

removing members from, 48-73, 48-75

site priority groups

adding members to, 48-19

privileges

getting, 70-27

granting, 70-32, 70-34

revoking, 70-48, 70-50

procedures

AlterSavepoint, 70-5

AlterWorkspace, 70-6

BeginResolve, 70-7

CommitResolve, 70-8

CompressWorkspace, 70-9

CompressWorkspaceTree, 70-11

CopyForUpdate, 70-13

CreateSavepoint, 70-14

CreateWorkspace, 70-16

DeleteSavepoint, 70-17

DisableVersioning, 70-19

EnableVersioning, 70-21

FreezeWorkspace, 70-22

GotoWorkspace, 70-31

GrantSystemPriv, 70-32

GrantWorkspacePriv, 70-34

LockRows, 70-37

MergeTable, 70-38, 70-43

MergeWorkspace, 70-40

RefreshTable, 70-41

RefreshWorkspace, 70-43

RemoveWorkspace, 70-44

RemoveWorkspaceTree, 70-45

ResolveConflicts, 70-46

RevokeSystemPriv, 70-48

RevokeWorkspacePriv, 70-50

RollbackResolve, 70-51

RollbackTable, 70-52

RollbackToSP, 70-53

RollbackWorkspace, 70-55

SetConflictWorkspace, 70-56

SetDiffVersions, 70-57

SetLockingOFF, 70-59

SetLockingON, 70-60

SetMultiWorkspaces, 70-61

SetWoOverwriteOFF, 70-62

SetWoOverwriteON, 70-63

SetWorkspaceLockModeOFF, 70-64

SetWorkspaceLockModeON, 70-65

UnfreezeWorkspace, 70-66

UnlockRows, 70-67

programmatic environments, 4-13

propagation

altering method, 48-28, 48-32

disabling, 12-24

of changes, 48-28

status of, 12-9

propagator

registering, 12-19

purging

DBA_REPCATLOG table, 48-88

Q

queuing

DBMS_AQADM package, 5-1

quiescing

master groups, 48-109

quit() function

of UTL_SMTP, 82-19

R

rcpt() function

of UTL_SMTP, 82-13

read_line()

function of UTL_TCP, 83-15

read_raw()

function of UTL_TCP, 83-10

read_text()

function of UTL_TCP, 83-12

rectifying

tables, 44-6

refresh

materialized view sites, 48-90

materialized views, 29-12, 29-15, 29-16

refresh groups

adding members to, 46-3

creating, 46-7

deleting, 46-6

refresh interval

changing, 46-4

refreshing

manually, 46-10

removing members from, 46-10

refreshing tables, 70-41

refreshing workspaces, 70-43

RefreshTable procedure, 70-41

RefreshWorkspace procedure, 70-43

registering

propagator for local database, 12-19

RemoveWorkspace procedure, 70-44

RemoveWorkspaceTree procedure, 70-45

removing workspaces, 70-44

replicated objects

dropping from master sites, 48-69

replication

datetime datatypes

abbreviations, 1-7

disabling, 52-3

enabling, 52-3

interval datatypes

abbreviations, 1-7

replication groups

offline instantiation of, 32-3, 32-4, 32-6, 32-7, 32-9

replies function

of UTL_SMTP, 82-8

reply functions

of UTL_SMTP, 82-8

ResolveConflicts procedure, 70-46

resolving conflicts, 70-46

beginning, 70-7

committing, 70-8

rolling back, 70-51

resuming replication activity, 48-100

RevokeSystemPriv procedure, 70-48

RevokeWorkspacePriv procedure, 70-50

revoking privileges, 70-48, 70-50

RollbackResolve procedure, 70-51

RollbackTable procedure, 70-52

RollbackToSP procedure, 70-53

RollbackWorkspace procedure, 70-55

rolling back

tables, 70-52

workspaces, 70-55

to savepoint, 70-53

ROWID datatype

DBMS_ROWID package, 57-1

extended format, 57-12

rows

locking, 70-37

unlocking, 70-67

rset() function

of UTL_SMTP, 82-17

S

savepoints

altering, 70-5

creating, 70-14

deleting, 70-17

rolling back to, 70-53

SDO_CD package, 1-15

SDO_GEOM package, 1-15

SDO_LRS package, 1-16

SDO_MIGRATE package, 1-19

SDO_TUNE package, 1-20

set_disabled, 12-24

SetConflictWorkspace procedure, 70-56

SetDiffVersions procedure, 70-57

SetLockingON procedure, 70-59, 70-60

SetMultiWorkspaces procedure, 70-61

SetWoOverwriteOFF procedure, 70-62

SetWoOverwriteON procedure, 70-63

SetWorkspaceLockModeOFF procedure, 70-64

SetWorkspaceLockModeON procedure, 70-65

shared locks, 70-60

site priority

altering, 48-37

site priority groups

adding members to, 48-19

creating

syntax, 48-64

dropping, 48-76

removing members from, 48-77

SQL statements

larger than 32 KB, 62-26

SQL*Plus

creating a sequence, 1-6

statistics

clearing, 12-5

collecting, 48-94

purging, 48-89

status

propagation, 12-9

stored outlines

OUTLN_PKG package, 37-1

subscriber view

dropping, 26-2

subscriber views

removing, 26-2

subscribers

drop the subscriber view, 26-2

drop the subscription, 26-2

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

purge the subscription window, 26-2

removing subscriber views, 26-2

retrieve change data from the subscriber views, 26-2

subscription window

purging, 26-2

SYS.ANYDATA, 11-9

system privileges, 70-32

T

tables

comparing, 44-3

rectifying, 44-6

table items as arrays, 62-29

TRACETAB.SQL, 64-3

U

UnfreezeWorkspace procedure, 70-66

unlocking table rows, 70-67

UnlockRows procedure, 70-67

upgrading

post-upgrade actions, 7-1, 30-1

UTL_COLL package, 75-1

UTL_ENCODE package, 76-1

UTL_FILE package, 77-1

UTL_INADDR package, 79-1

UTL_PG package, 1-20

UTL_RAW package, 76-1, 80-1

UTL_REF package, 81-1

UTL_SMTP package, 82-1

UTL_TCP package, 83-1

V

versioning

disabling, 70-19

enabling, 70-21

VIEW_WO_OVERWRITE mode

disabling, 70-62

enabling, 70-63

vrfy() function

of UTL_SMTP, 82-18

W

workspace

continually refreshed, 70-16

creating, 70-16

freezing, 70-22

getting, 70-28

selecting, 70-31

unfreezing, 70-66

workspace lock mode

disabling, 70-64

enabling, 70-65

write_data() function

of UTL_SMTP, 82-15

write_line()

function of UTL_TCP, 83-16

write_raw()

function of UTL_TCP, 83-11

write_raw_data() function

of UTL_SMTP, 82-15

write_text()

function of UTL_TCP, 83-14