Each view has three versions, which have different prefixes: USER_*, ALL_*, and SYS.DBA_*. This section ignores any differences between these views.
Column
| Description
|
id
| 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
| Location that the request originated.
|
userid
| Userid of person making the request.
|
timestamp
| When the request was made.
|
role
| Indicates if site is the 'masterdef' or a 'master' site.
|
master
| If the role is 'masterdef' and the task is remote, indicates which master is performing the task.
|
sname
| The name of the schema for the replicated object, if applicable.
|
request
| The name of the DBMS_REPCAT administrative procedure that was run.
|
oname
| The name of the replicated object, if applicable.
|
type
| The type of replicated object.
|
status
| The status of the administrative request: ready, do_callback, await_callback, or error.
|
message
| Any error message that has been returned.
|
errnum
| The Oracle error number for the message.
|
gname
| The name of the replicated object group.
|
Column
| Description
|
sname
| The name of the schema containing the replicated object.
|
oname
| The name of the replicated object.
|
type
| The type of replicated object: table, view, package, package body, procedure, function, index, synonym, trigger, or snapshot.
|
status
| CREATE indicates that Oracle is applying user supplied or Oracle-generated DDL to the local database in an attempt to create the object locally. When a local replica exists, Oracle COMPAREs the replica with the master definition to ensure that they are consistent. When creation or comparison complete successfully, Oracle updates the status to VALID; otherwise, it updates the status to ERROR. If you drop an object, Oracle updates its status to DROPPED before deleting the row from the RepObject view.
|
id
| The identifier of the local database object, if one exists.
|
object_comment
| Any user supplied comments.
|
gname
| The name of the replicated object group to which the object belongs.
|
Column
| Description
|
sname
| The name of the schema containing the replicated table.
|
oname
| The name of the replicated table.
|
conflict_type
| The type of conflict that the routine is used to resolve: delete, uniqueness, or update.
|
reference_name
| The object to which the routine applies. For delete conflicts, this is the table name. For uniqueness conflicts, this is the constraint name. For update conflicts, this is the column group name.
|
sequence_no
| The order that resolution methods are applied, with 1 being applied first.
|
method_name
| The name of an Oracle-supplied conflict resolution method. For user-supplied methods, this value is 'user function'.
|
function_name
| For methods of type 'user function', the name of the user-supplied conflict resolution routine.
|
priority_group
| For methods of type 'priority group', the name of the priority group.
|
parameter_table_
name
| Defaults to object name of PL/SQL table containing columns passed to conflict resolution function.
|
parameter_
column_name
| The name of the column used as the IN parameter for the conflict resolution routine.
|
parameter_
sequence_no
| Ordering of column used as IN parameter.
|
Column
| Description
|
sname
| The name of the replicated schema. Obsolete with release 7.3 or later.
|
gname
| The name of the replicated object group.
|
priority_group
| The name of the priority group or site priority group.
|
priority
| The priority level of the member. The highest number has the highest priority.
|
data_type
| The datatype of the values in the priority group.
|
fixed_data_length
| The maximum length of values of datatype CHAR.
|
char_value
| The value of the priority group member, if data_type = char.
|
varchar2_value
| The value of the priority group member, if data_type = varchar2.
|
number_value
| The value of the priority group member, if data_type = number.
|
date_value
| The value of the priority group member, if data_type = date.
|
raw_value
| The value of the priority group member, if data_type = raw.
|
Column
| Description
|
sname
| The name of the replicated schema.
|
oname
| The name of the replicated table.
|
conflict_type
| The type of conflict that the routine is used to resolve: delete, uniqueness, or update.
|
reference_name
| The object to which the routine applies. For delete conflicts, this is the table name. For uniqueness conflicts, this is the constraint name. For update conflicts, this is the column group name.
|
sequence_no
| The order that resolution methods are applied, with 1 being applied first.
|
method_name
| The name of an Oracle-supplied conflict resolution method. For user-supplied methods, this value is 'user function'.
|
function_name
| For methods of type 'user function', the name of the user-supplied conflict resolution routine.
|
priority_group
| For methods of type 'priority group', the name of the priority group.
|
resolution_
comment
| Any user-supplied comments.
|
Column
| Description
|
sname
| The name of the replicated schema.
|
oname
| The name of the replicated table.
|
conflict_type
| The type of conflict that was successfully resolved: delete, uniqueness, or update.
|
reference_name
| The object to which the conflict resolution routine applies. For delete conflicts, this is the table name. For uniqueness conflicts, this is the constraint name. For update conflicts, this is the column group name.
|
method_name
| The name of an Oracle-supplied conflict resolution method. For user-supplied methods, this value is 'user function'.
|
function_name
| For methods of type 'user function', the name of the user supplied conflict resolution routine.
|
priority_group
| For methods of type 'priority group', the name of the priority group.
|
primary_key_value
| A concatenated representation of the row's primary key.
|
resolved_date
| Date on which the conflict for this row was resolved.
|