ALL_REPCATLOG

Contains the interim status of any asynchronous administrative requests and any error messages generated at each master site. All messages encountered while executing a request are eventually transferred to the ALL_REPCATLOG view at the master site that originated the request. If an administrative request completes without error, then ultimately all traces of this request are removed from the ALL_REPCATLOG view. This view contains administrative requests and error messages that are accessible to the current user.

Related Views:

DBA_REPCATLOG describes the status for all asynchronous administrative requests and all error messages in the database.

USER_REPCATLOG describes the status for all asynchronous administrative requests and all error messages owned by the current user.

Column

Datatype

NULL

Description

ID

NUMBER

A sequence number. Together, the ID and SOURCE columns identify all log records at all master sites that pertain to a single administrative request.

SOURCE

VARCHAR2(128)

Location where the request originated.

USERID

VARCHAR2(30)

Name of the user making the request.

TIMESTAMP

DATE

When the request was made.

ROLE

VARCHAR2(9)

Indicates if site is the master definition site (masterdef) or a master site (master).

MASTER

VARCHAR2(128)

If the role is 'masterdef' and the task is remote, then indicates which master site is performing the task.

SNAME

VARCHAR2(30)

The name of the schema for the replicated object, if applicable.

REQUEST

VARCHAR2(29)

The name of the DBMS_REPCAT administrative procedure that was run.

ONAME

VARCHAR2(30)

The name of the replicated object, if applicable.

TYPE

VARCHAR2(12)

The type of replicated object:

FUNCTION

INDEX

INDEXTYPE

OPERATOR

PACKAGE

PACKAGE BODY

PROCEDURE

SNAPSHOT

SYNONYM

TABLE

TRIGGER

TYPE

TYPE BODY

VIEW

STATUS

VARCHAR2(14)

The status of the administrative request: READY, DO_CALLBACK, AWAIT_CALLBACK, or ERROR.