Oracle 9i. Replication Management API Reference

Oracle 9i Replication Management API Reference contains information that describes the features and functionality of the replication management API. Specifically, this Oracle 9i Replication Management API Refeivnce contains reference information for the packages in the replication management API, as well as examples of their use-In addition. Oracle 9i Replication Management API Reference contains reference information about the replication catalog and other data dictionary views that are important for replication. Send Us Your Comments......Page 19 Preface......Page 21 1 Replication Overview......Page 35 Creating a Replication Environment Overview......Page 36 Before You Start......Page 38 2 Create Replication Site......Page 39 Overview of Setting Up Replication Sites......Page 40 Setting Up orc1.world......Page 42 Setting Up orc2.world......Page 47 Setting Up orc3.world......Page 50 Creating Scheduled Links Between the Master Sites......Page 53 Setting Up Materialized View Sites......Page 57 Setting Up mv1.world......Page 58 Setting Up mv2.world......Page 65 3 Create a Master Group......Page 71 Overview of Creating a Master Group......Page 72 Before You Start......Page 73 Creating a Master Group......Page 75 4 Create a Deployment Template......Page 85 Oracle Deployment Templates Concepts......Page 86 Creating a Deployment Template......Page 87 Packaging a Deployment Template for Instantiation......Page 96 Packaging a Deployment Template......Page 98 Saving an Instantiation Script to File......Page 100 Distributing Instantiation Files......Page 102 Instantiating a Deployment Template......Page 103 Refreshing a Refresh Group After Instantiation......Page 105 5 Create Materialized View Group......Page 107 Overview of Creating a Materialized View Group......Page 108 Creating the Materialized View Group at mv1.world......Page 110 Creating the Materialized View Group at mv2.world......Page 118 6 Configure Conflict Resolution......Page 127 Preparing for Conflict Resolution......Page 128 Overwrite and Discard Conflict Resolution Methods......Page 129 Minimum and Maximum Conflict Resolution Methods......Page 132 Timestamp Conflict Resolution Methods......Page 135 Additive and Average Conflict Resolution Methods......Page 139 Priority Groups Conflict Resolution Methods......Page 141 Site Priority Conflict Resolution Methods......Page 146 Creating Conflict Resolution Methods for Uniqueness Conflicts......Page 151 Creating Conflict Avoidance Methods for Delete Conflicts......Page 157 Workflow......Page 162 Token Passing......Page 163 Obtaining Ownership......Page 165 Applying the Change......Page 166 Viewing Conflict Resolution Statistics......Page 167 Clearing Statistics Information......Page 168 7 Managing a Master Replication Environment......Page 171 Option 1: All Master Sites Are Available......Page 172 Option 2: The Old Master Definition Site Is Not Available......Page 173 Adding New Master Sites Without Quiescing the Master Group......Page 174 Adding New Master Sites to a Quiesced Master Group......Page 198 Removing a Master Site from a Master Group......Page 207 Removing an Unavailable Master Site......Page 209 Updating the Comments Fields in Data Dictionary Views......Page 210 Restrictions on Procedural Replication......Page 212 User-Defined Types and Procedural Replication......Page 214 Generating Support for Replicated Procedures......Page 215 8 Managing a Materialized View Replication Environment......Page 219 Changing a Materialized View Group’s Master Site......Page 220 Dropping Materialized View Groups and Objects......Page 221 Dropping a Materialized View Groups Created with a Deployment Template......Page 222 Dropping a Materialized View Group or Objects Created Manually......Page 226 Cleaning Up a Master Site or Master Materialized View Site......Page 228 Altering Materialized View Logs......Page 233 Managing Materialized View Log Space......Page 234 Reorganizing Master Tables that Have Materialized View Logs......Page 237 Dropping a Materialized View Log......Page 240 Performing an Offline Instantiation of a Materialized View Site Using Export/Import......Page 241 Using a Group Owner for a Materialized View Group......Page 252 9 Managing Replication Objects and Queues......Page 259 Altering a Replicated Object in a Quiesced Master Group......Page 260 Disabling Replication......Page 263 Reenabling the Replication Facility......Page 264 Converting a LONG Column to a LOB Column in a Replicated Table......Page 265 Using the RECTIFY Procedure......Page 267 Pushing the Deferred Transaction Queue......Page 272 Purging the Deferred Transaction Queue......Page 273 Using the AnyData Type to Determine the Value of an Argument in a Deferred Call......Page 274 Managing the Error Queue......Page 276 Reexecuting Error Transaction as the Receiver......Page 277 Reexecuting Error Transaction as Alternate User......Page 278 10 Monitoring a Replication Environment......Page 279 Monitoring Master Sites......Page 280 Monitoring Master Groups......Page 281 Monitoring Masters......Page 284 Listing General Information About a Materialized View Site......Page 289 Listing General Information About Materialized View Groups......Page 290 Listing Information About Materialized Views......Page 291 Listing Information About the Refresh Groups at a Materialized View Site......Page 293 Determining the Job ID for Each Refresh Job at a Materialized View Site......Page 294 Listing General Information About Administrative Requests......Page 295 Determining the Cause of Administrative Request Errors......Page 296 Listing General Information About the Job that Executes Administrative Requests......Page 297 Monitoring Transaction Propagation......Page 298 Monitoring Purges of Successfully Propagated Transactions......Page 301 Listing General Information About the Error Transactions at a Replication Site......Page 304 Listing the Number of Error Transactions from Each Origin Master Site......Page 305 Determining the Error Operations at a Replication Site......Page 306 Monitoring Initialization Parameters......Page 307 Tracking the Average Number of Row Changes in a Replication Transaction......Page 308 Determining the Average Network Traffic Created To Propagate a Transaction......Page 309 Determining the Percentage of Time the Parallel Propagation Job Spends Sleeping......Page 310 Monitoring Parallel Propagation of Deferred Transactions Using V$REPLPROP......Page 311 11 Introduction to the Replication Management API Reference......Page 317 Examples of Using Oracle’s Replication Management API......Page 318 The Replication Management Tool and the Replication Management API......Page 319 Abbreviations for Datetime and Interval Datatypes......Page 320 12 DBMS_DEFER......Page 321 Summary of DBMS_DEFER Subprograms......Page 322 CALL Procedure......Page 323 COMMIT_WORK Procedure......Page 324 datatype_ARG Procedure......Page 325 TRANSACTION Procedure......Page 328 13 DBMS_DEFER_QUERY......Page 329 Summary of DBMS_DEFER_QUERY Subprograms......Page 330 GET_ARG_FORM Function......Page 331 GET_ARG_TYPE Function......Page 333 GET_CALL_ARGS Procedure......Page 335 GET_datatype_ARG Function......Page 337 GET_OBJECT_NULL_VECTOR_ARG Function......Page 340 14 DBMS_DEFER_SYS......Page 343 Summary of DBMS_DEFER_SYS Subprograms......Page 344 ADD_DEFAULT_DEST Procedure......Page 346 CLEAR_PROP_STATISTICS Procedure......Page 347 DELETE_DEF_DESTINATION Procedure......Page 348 DELETE_ERROR Procedure......Page 349 DELETE_TRAN Procedure......Page 350 DISABLED Function......Page 351 EXCLUDE_PUSH Function......Page 352 EXECUTE_ERROR Procedure......Page 353 EXECUTE_ERROR_AS_USER Procedure......Page 354 PURGE Function......Page 355 PUSH Function......Page 358 REGISTER_PROPAGATOR Procedure......Page 361 SCHEDULE_PURGE Procedure......Page 362 SCHEDULE_PUSH Procedure......Page 364 SET_DISABLED Procedure......Page 366 UNREGISTER_PROPAGATOR Procedure......Page 368 UNSCHEDULE_PUSH Procedure......Page 369 15 DBMS_MVIEW......Page 371 Summary of DBMS_MVIEW Subprograms......Page 372 BEGIN_TABLE_REORGANIZATION Procedure......Page 373 END_TABLE_REORGANIZATION Procedure......Page 374 EXPLAIN_MVIEW Procedure......Page 375 EXPLAIN_REWRITE Procedure......Page 376 I_AM_A_REFRESH Function......Page 377 PURGE_DIRECT_LOAD_LOG Procedure......Page 378 PURGE_LOG Procedure......Page 379 PURGE_MVIEW_FROM_LOG Procedure......Page 380 REFRESH Procedure......Page 382 REFRESH_ALL_MVIEWS Procedure......Page 385 REFRESH_DEPENDENT Procedure......Page 386 REGISTER_MVIEW Procedure......Page 388 UNREGISTER_MVIEW Procedure......Page 391 16 DBMS_OFFLINE_OG......Page 393 Summary of DBMS_OFFLINE_OG Subprograms......Page 394 BEGIN_INSTANTIATION Procedure......Page 395 BEGIN_LOAD Procedure......Page 396 END_INSTANTIATION Procedure......Page 398 END_LOAD Procedure......Page 399 RESUME_SUBSET_OF_MASTERS Procedure......Page 401 17 DBMS_OFFLINE_SNAPSHOT......Page 403 Summary of DBMS_OFFLINE_SNAPSHOT Subprograms......Page 404 BEGIN_LOAD Procedure......Page 405 END_LOAD Procedure......Page 407 18 DBMS_RECTIFIER_DIFF......Page 409 Summary of DBMS_RECTIFIER_DIFF Subprograms......Page 410 DIFFERENCES Procedure......Page 411 RECTIFY Procedure......Page 414 19 DBMS_REFRESH......Page 417 Summary of DBMS_REFRESH Subprograms......Page 418 ADD Procedure......Page 419 CHANGE Procedure......Page 420 DESTROY Procedure......Page 422 MAKE Procedure......Page 423 SUBTRACT Procedure......Page 426 20 DBMS_REPCAT......Page 429 Summary of DBMS_REPCAT Subprograms......Page 430 ADD_GROUPED_COLUMN Procedure......Page 436 ADD_MASTER_DATABASE Procedure......Page 437 ADD_NEW_MASTERS Procedure......Page 439 ADD_PRIORITY_datatype Procedure......Page 445 ADD_SITE_PRIORITY_SITE Procedure......Page 447 ADD_conflicttype_RESOLUTION Procedure......Page 448 ALTER_CATCHUP_PARAMETERS Procedure......Page 454 ALTER_MASTER_PROPAGATION Procedure......Page 456 ALTER_MASTER_REPOBJECT Procedure......Page 457 ALTER_MVIEW_PROPAGATION Procedure......Page 460 ALTER_PRIORITY Procedure......Page 462 ALTER_PRIORITY_datatype Procedure......Page 463 ALTER_SITE_PRIORITY Procedure......Page 465 ALTER_SITE_PRIORITY_SITE Procedure......Page 467 CANCEL_STATISTICS Procedure......Page 468 COMMENT_ON_COLUMN_GROUP Procedure......Page 469 COMMENT_ON_MVIEW_REPSITES Procedure......Page 470 COMMENT_ON_PRIORITY_GROUP/COMMENT_ON_SITE_PRIORITY Procedures......Page 471 COMMENT_ON_REPGROUP Procedure......Page 472 COMMENT_ON_REPOBJECT Procedure......Page 473 COMMENT_ON_REPSITES Procedure......Page 474 COMMENT_ON_conflicttype_RESOLUTION Procedure......Page 476 COMPARE_OLD_VALUES Procedure......Page 478 CREATE_MASTER_REPGROUP Procedure......Page 480 CREATE_MASTER_REPOBJECT Procedure......Page 481 CREATE_MVIEW_REPGROUP Procedure......Page 485 CREATE_MVIEW_REPOBJECT Procedure......Page 486 DEFINE_COLUMN_GROUP Procedure......Page 489 DEFINE_PRIORITY_GROUP Procedure......Page 490 DEFINE_SITE_PRIORITY Procedure......Page 492 DO_DEFERRED_REPCAT_ADMIN Procedure......Page 493 DROP_COLUMN_GROUP Procedure......Page 494 DROP_GROUPED_COLUMN Procedure......Page 495 DROP_MASTER_REPGROUP Procedure......Page 496 DROP_MASTER_REPOBJECT Procedure......Page 497 DROP_MVIEW_REPGROUP Procedure......Page 499 DROP_MVIEW_REPOBJECT Procedure......Page 500 DROP_PRIORITY Procedure......Page 501 DROP_PRIORITY_GROUP Procedure......Page 502 DROP_PRIORITY_datatype Procedure......Page 503 DROP_SITE_PRIORITY Procedure......Page 504 DROP_SITE_PRIORITY_SITE Procedure......Page 505 DROP_conflicttype_RESOLUTION Procedure......Page 506 EXECUTE_DDL Procedure......Page 508 GENERATE_MVIEW_SUPPORT Procedure......Page 510 GENERATE_REPLICATION_SUPPORT Procedure......Page 511 MAKE_COLUMN_GROUP Procedure......Page 513 PREPARE_INSTANTIATED_MASTER Procedure......Page 515 PURGE_MASTER_LOG Procedure......Page 516 PURGE_STATISTICS Procedure......Page 517 REFRESH_MVIEW_REPGROUP Procedure......Page 518 REGISTER_MVIEW_REPGROUP Procedure......Page 520 REGISTER_STATISTICS Procedure......Page 522 RELOCATE_MASTERDEF Procedure......Page 523 REMOVE_MASTER_DATABASES Procedure......Page 525 RENAME_SHADOW_COLUMN_GROUP Procedure......Page 526 REPCAT_IMPORT_CHECK Procedure......Page 527 RESUME_MASTER_ACTIVITY Procedure......Page 528 RESUME_PROPAGATION_TO_MDEF Procedure......Page 529 SEND_OLD_VALUES Procedure......Page 530 SET_COLUMNS Procedure......Page 533 SPECIFY_NEW_MASTERS Procedure......Page 535 SUSPEND_MASTER_ACTIVITY Procedure......Page 537 SWITCH_MVIEW_MASTER Procedure......Page 538 UNDO_ADD_NEW_MASTERS_REQUEST Procedure......Page 539 UNREGISTER_MVIEW_REPGROUP Procedure......Page 541 VALIDATE Function......Page 542 WAIT_MASTER_LOG Procedure......Page 545 21 DBMS_REPCAT_ADMIN......Page 547 Summary of DBMS_REPCAT_ADMIN Subprograms......Page 548 GRANT_ADMIN_ANY_SCHEMA Procedure......Page 549 GRANT_ADMIN_SCHEMA Procedure......Page 550 REGISTER_USER_REPGROUP Procedure......Page 551 REVOKE_ADMIN_ANY_SCHEMA Procedure......Page 553 REVOKE_ADMIN_SCHEMA Procedure......Page 554 UNREGISTER_USER_REPGROUP Procedure......Page 555 22 DBMS_REPCAT_INSTANTIATE......Page 557 Summary of DBMS_REPCAT_INSTANTIATE Subprograms......Page 558 INSTANTIATE_OFFLINE Function......Page 559 INSTANTIATE_ONLINE Function......Page 562 23 DBMS_REPCAT_RGT......Page 565 Summary of DBMS_REPCAT_RGT Subprograms......Page 566 ALTER_REFRESH_TEMPLATE Procedure......Page 569 ALTER_TEMPLATE_OBJECT Procedure......Page 571 ALTER_TEMPLATE_PARM Procedure......Page 574 ALTER_USER_AUTHORIZATION Procedure......Page 576 ALTER_USER_PARM_VALUE Procedure......Page 578 COMPARE_TEMPLATES Function......Page 580 COPY_TEMPLATE Function......Page 582 CREATE_OBJECT_FROM_EXISTING Function......Page 584 CREATE_REFRESH_TEMPLATE Function......Page 586 CREATE_TEMPLATE_OBJECT Function......Page 588 CREATE_TEMPLATE_PARM Function......Page 591 CREATE_USER_AUTHORIZATION Function......Page 594 CREATE_USER_PARM_VALUE Function......Page 595 DELETE_RUNTIME_PARMS Procedure......Page 597 DROP_ALL_OBJECTS Procedure......Page 598 DROP_ALL_TEMPLATE_PARMS Procedure......Page 600 DROP_ALL_TEMPLATE_SITES Procedure......Page 601 DROP_ALL_USER_AUTHORIZATIONS Procedure......Page 602 DROP_ALL_USER_PARM_VALUES Procedure......Page 603 DROP_REFRESH_TEMPLATE Procedure......Page 604 DROP_SITE_INSTANTIATION Procedure......Page 605 DROP_TEMPLATE_OBJECT Procedure......Page 606 DROP_TEMPLATE_PARM Procedure......Page 608 DROP_USER_AUTHORIZATION Procedure......Page 609 DROP_USER_PARM_VALUE Procedure......Page 610 INSERT_RUNTIME_PARMS Procedure......Page 611 INSTANTIATE_OFFLINE Function......Page 613 INSTANTIATE_ONLINE Function......Page 616 LOCK_TEMPLATE_SHARED Procedure......Page 619 24 DBMS_REPUTIL......Page 621 Summary of DBMS_REPUTIL Subprograms......Page 622 REPLICATION_ON Procedure......Page 623 FROM_REMOTE Function......Page 624 MAKE_INTERNAL_PKG Procedure......Page 625 SYNC_UP_REP Procedure......Page 626 25 Replication Catalog Views......Page 631 Summary of Replication Catalog Views......Page 632 ALL_REPCAT_REFRESH_TEMPLATES......Page 635 ALL_REPCAT_TEMPLATE_OBJECTS......Page 636 ALL_REPCAT_TEMPLATE_PARMS......Page 638 ALL_REPCAT_TEMPLATE_SITES......Page 641 ALL_REPCAT_USER_AUTHORIZATIONS......Page 642 ALL_REPCAT_USER_PARM_VALUES......Page 643 ALL_REPCATLOG......Page 645 ALL_REPCOLUMN......Page 647 ALL_REPCOLUMN_GROUP......Page 649 ALL_REPCONFLICT......Page 650 ALL_REPDDL......Page 651 ALL_REPGENOBJECTS......Page 652 ALL_REPGROUP......Page 653 ALL_REPGROUP_PRIVILEGES......Page 654 ALL_REPGROUPED_COLUMN......Page 655 ALL_REPKEY_COLUMNS......Page 656 ALL_REPOBJECT......Page 657 ALL_REPPARAMETER_COLUMN......Page 659 ALL_REPPRIORITY......Page 660 ALL_REPPRIORITY_GROUP......Page 662 ALL_REPPROP......Page 663 ALL_REPRESOL_STATS_CONTROL......Page 664 ALL_REPRESOLUTION......Page 665 ALL_REPRESOLUTION_METHOD......Page 666 ALL_REPRESOLUTION_STATISTICS......Page 667 ALL_REPSITES......Page 668 DBA_REPCAT_TEMPLATE_SITES......Page 669 DBA_REPCATLOG......Page 670 DBA_REPDDL......Page 671 DBA_REPEXTENSIONS......Page 672 DBA_REPOBJECT......Page 675 DBA_REPPROP......Page 676 DBA_REPRESOLUTION_STATISTICS......Page 677 DBA_REPSITES_NEW......Page 678 USER_REPCAT_REFRESH_TEMPLATES......Page 679 USER_REPCAT_USER_AUTHORIZATION......Page 680 USER_REPCOLUMN_GROUP......Page 681 USER_REPGROUP......Page 682 USER_REPPARAMETER_COLUMN......Page 683 USER_REPPROP......Page 684 USER_REPRESOLUTION_METHOD......Page 685 USER_REPSITES......Page 686 26 Replication Dynamic Performance Views......Page 687 V$REPLPROP......Page 688 V$REPLQUEUE......Page 690 27 Deferred Transaction Views......Page 691 DEFCALLDEST......Page 692 DEFERRCOUNT......Page 693 DEFLOB......Page 694 DEFSCHEDULE......Page 695 DEFTRANDEST......Page 698 28 Materialized View and Refresh Group Views......Page 699 ALL_BASE_TABLE_MVIEWS......Page 700 ALL_MVIEW_LOGS......Page 701 ALL_MVIEW_REFRESH_TIMES......Page 702 ALL_MVIEWS......Page 703 ALL_REFRESH......Page 707 ALL_REFRESH_CHILDREN......Page 708 ALL_REGISTERED_MVIEWS......Page 709 DBA_MVIEW_REFRESH_TIMES......Page 710 DBA_REGISTERED_MVIEW_GROUPS......Page 711 USER_MVIEWS......Page 712 USER_REGISTERED_MVIEWS......Page 713 A Security Options......Page 717 Security Setup for Multimaster Replication......Page 718 Trusted Compared With Untrusted Security......Page 719 Security Setup for Materialized View Replication......Page 723 Trusted Compared With Untrusted Security......Page 724 B User-Defined Conflict Resolution Methods......Page 729 Conflict Resolution Method Parameters......Page 730 Resolving Uniqueness Conflicts......Page 731 Multitier Materialized Views and User-Defined Conflict Resolution Methods......Page 732 Restrictions for User-Defined Conflict Resolution Methods......Page 733 Examples of User-Defined Conflict Resolution Method......Page 734 Creating a Conflict Notification Log......Page 736 Creating a Conflict Notification Package......Page 737 Viewing Conflict Resolution Information......Page 740 Index......Page 741