Replication Catalog Views, 8 of 81

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	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`.
`MESSAGE`	`VARCHAR2(200)`	Any error message that has been returned.
`ERRNUM`	`NUMBER`	The Oracle error number for the message.
`GNAME`	`VARCHAR2(30)`	The name of the replication group.