Data Dictionary Views, 3 of 112

ALL_REPCATLOG

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

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, indicates which master 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.

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 replicated object group.

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, indicates which master 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.
`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 replicated object group.