Managing Administrative Requests

An administrative request is a specific call to a procedure or function in Oracle's replication management API. For example, when you use the Create Master Group Wizard to create a new master group, it completes the task by making a call to the DBMS_REPCAT.CREATE_MASTER_REPGROUP procedure. All DDL changes to replication groups, and all DDL changes to the objects within these groups, generate administrative requests. Many top-level administrative requests generate additional replication management API calls to complete the request.

Administrative requests are inserted by the master definition site in the administrative request queues at all master sites as one distributed transaction. Each master site has a scheduled job, DO_DEFERRED_REPCAT_ADMIN, that executes requests at each site. As administrative requests are processed, each site reports back to the master definition site. Oracle removes requests that complete successfully from the administrative request queue at the master definition site. However, if any errors are encountered, the administrative request remains in the master definition site's administrative request queue with an error status.

You can view and update the status of administrative requests. To learn more about managing administrative requests for a master group refer to the following:

• Displaying Administrative Requests

• Applying Administrative Requests

• Purging Administrative Requests

• Viewing Details of an Administrative Request

• Diagnosing Problems with Administrative Requests