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

TABLE: SYSTEM.REPCAT$_REPCATLOG

Object Details
Object Name: REPCAT$_REPCATLOG
Object Type: TABLE
Owner: SYSTEM
Subobject Name:
Status: VALID

Information about asynchronous administration requests

Storage Details
Tablespace: TablespaceSYSTEM
PCT Free: 10
PCT Used: 40
Primary Key: REPCAT$_REPCATLOG_PRIMARY
  1. ColumnID
  2. ColumnSOURCE
  3. ColumnROLE
  4. ColumnMASTER
Indexes
Index Type Uniqueness Tablespace Column
REPCAT$_REPCATLOG_PRIMARY NORMAL UNIQUE TablespaceSYSTEM ColumnID
ColumnSOURCE
ColumnROLE
ColumnMASTER
REPCAT$_REPCATLOG_GNAME NORMAL NONUNIQUE TablespaceSYSTEM ColumnGNAME
ColumnSNAME
ColumnONAME
ColumnTYPE
Foreign Keys
Table
Foreign Table Foreign Key Column
TableREPCAT$_DDL REPCAT$_DDL_PRNT REPCAT$_REPCATLOG REPCAT$_DDL LOG_ID
REPCAT$_DDL SOURCE
REPCAT$_DDL ROLE
REPCAT$_DDL MASTER
Columns
Name Datatype Length Mandatory Comments
VERSION NUMBER

Version of the repcat log record
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 (1) Yes Is this database the masterdef for the request
MASTER VARCHAR2 (128) Yes Name of the database that processes this request$_ddl
SNAME VARCHAR2 (128)
Schema of replicated object
REQUEST NUMBER

Name of the requested operation
ONAME VARCHAR2 (128)
Replicated object name, if applicable
TYPE NUMBER

Type of replicated object, if applicable
A_COMMENT VARCHAR2 (2000)
Textual argument used for comments
BOOL_ARG VARCHAR2 (1)
Boolean argument
ANO_BOOL_ARG VARCHAR2 (1)
Another Boolean argument
INT_ARG NUMBER

Integer argument
ANO_INT_ARG NUMBER

Another integer argument
LINES NUMBER

The number of rows in system.repcat$_ddl at the processing site
STATUS NUMBER

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 (30)
Name of the replicated object group
Query Text

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


SELECT VERSION
,      ID
,      SOURCE
,      USERID
,      TIMESTAMP
,      ROLE
,      MASTER
,      SNAME
,      REQUEST
,      ONAME
,      TYPE
,      A_COMMENT
,      BOOL_ARG
,      ANO_BOOL_ARG
,      INT_ARG
,      ANO_INT_ARG
,      LINES
,      STATUS
,      MESSAGE
,      ERRNUM
,      GNAME
FROM SYSTEM.REPCAT$_REPCATLOG;

Dependencies

[top of page]

SYSTEM.REPCAT$_REPCATLOG does not reference any database object

SYSTEM.REPCAT$_REPCATLOG is referenced by following:

SchemaSYS
Package BodyDBMSOBJGWRAPPER - show dependent code
Package BodyDBMS_OFFLINE_OG_INTERNAL - show dependent code
Package BodyDBMS_REPCAT_ADD_MASTER - show dependent code
Package BodyDBMS_REPCAT_MAS - show dependent code
Package BodyDBMS_REPCAT_RPC_UTL - show dependent code
Package BodyDBMS_REPCAT_RQ - show dependent code
Package BodyDBMS_REPCAT_UTL - show dependent code
Package BodyDBMS_REPCAT_UTL3 - show dependent code
Package BodyDBMS_REPCAT_UTL4 - show dependent code
ViewREPCAT_REPCATLOG
SchemaSYSTEM
TriggerREPCATLOGTRIG