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 MATERIALIZED VIEW INDEX SYNONYM INDEXTYPE TABLE OPERATOR TRIGGER PACKAGE TYPE PACKAGE BODY TYPE BODY PROCEDURE 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.