DBA Data[Home] [Help] [Dependency Information]

VIEW: SYS.ALL_REPCATLOG

Object Details
Object Name: ALL_REPCATLOG
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

Information about asynchronous administration requests

[View Source]

Columns
Name Datatype Length Mandatory Comments
ID NUMBER

Identifying number of repcat log record
SOURCE VARCHAR2 (128)
Name of the database at which the request originated
USERID VARCHAR2 (128)
Name of the user who submitted the request
TIMESTAMP DATE

When the request was submitted
ROLE VARCHAR2 (9)
Is this database the masterdef for the request
MASTER VARCHAR2 (128)
Name of the database that processes this request
SNAME VARCHAR2 (128)
Schema of replicated object name, if applicable
REQUEST VARCHAR2 (29)
Name of the requested operation
ONAME VARCHAR2 (128)
Replicated object name, if applicable
TYPE VARCHAR2 (12)
Type of replicated object, if applicable
STATUS VARCHAR2 (14)
Status of the request at this database
MESSAGE VARCHAR2 (200)
Error message associated with processing the request
ERRNUM NUMBER

Oracle error number associated with processing the request
GNAME VARCHAR2 (128)
Name of the replicated object group
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ID
,      SOURCE
,      USERID
,      TIMESTAMP
,      ROLE
,      MASTER
,      SNAME
,      REQUEST
,      ONAME
,      TYPE
,      STATUS
,      MESSAGE
,      ERRNUM
,      GNAME
FROM SYS.ALL_REPCATLOG;

Dependencies

[top of page]

SYS.ALL_REPCATLOG references the following:

SchemaSYS
ViewALL_OBJECTS
ViewALL_USERS
ViewREPCAT_REPCATLOG
ViewUSER_REPCATLOG
PL/SQL PackageXML_SCHEMA_NAME_PRESENT - show dependent code
SYS.ALL_REPCATLOG is referenced by following:

SchemaPUBLIC
SynonymALL_REPCATLOG
SchemaSYS
ViewALL_REPDDL