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
- See also procedures, 70-28
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