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

VIEW: SYS.USER_REPCATLOG

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

Information about the current user's asynchronous administration requests

[View Source]

Columns
Name Datatype Length Mandatory Comments
ID NUMBER
Yes Identifying number of repcat log record
SOURCE VARCHAR2 (128) Yes 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) Yes 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.USER_REPCATLOG;

Dependencies

[top of page]

SYS.USER_REPCATLOG references the following:

SchemaSYS
ViewREPCAT_REPCATLOG
ViewUSER_USERS
SYS.USER_REPCATLOG is referenced by following:

SchemaPUBLIC
SynonymUSER_REPCATLOG
SchemaSYS
ViewALL_REPCATLOG
ViewUSER_REPDDL