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.
|
Column
| Description
|
dblink
| Fully qualified pathname to master database site for which you have scheduled periodic execution of deferred remote procedure calls.
|
job
| Number assigned to job when you created it by calling DBMS_DEFER_SYS.SCHEDULE_EXECUTION. Query the WHAT column of USER_JOBS view to determine what is executed when the job is run.
|
interval
| Function used to calculate the next time to apply any changes.
|
next_date
| Next date that job is scheduled to be executed.
|
last_date
| Last time the DBMS_DEFER_SYS.EXECUTE pushed (or attempted to push) remote procedure calls to this destination.
|
disabled
| Is propagation to destination disabled?
|
last_txn_count
| Number of transactions pushed during last attempt.
|
last_error
| Oracle error number from last push
|
last_msg
| Error message from last push.
|
Column
| Description
|
deferred_tran_id
| The transaction ID originating or copying the deferred remote procedure calls.
|
deferred_tran_db
| The fully qualified database name of the database originating or copying the deferred remote procedure calls.
|
origin_tran_id
| The transaction ID originating the deferred remote procedure calls.
|
origin_tran_db
| The fully qualified database name of the database originating the deferred remote procedure calls.
|
origin_user
| The userid of the user originating the deferred remote procedure calls.
|
delivery_order
| An identifier that determines the order of deferred transactions in the queue. The identifier is derived from the system commit number of the originating or copying transaction.
|
destination_list
| 'R' or 'D'. 'R' indicates that the destinations are determined by the RepSchema view. 'D' indicates that the destinations were determined by the DefDefaultDest view or the NODE_LIST argument to the TRANSACTION, CALL, or COPY procedures.
|
start_time
| The start time of the originating transaction
|
commit_comment
| Any user-supplied comments.
|
Column
| Description
|
JOB
| Identifier of the job.
|
LOG_USER
| User logged in when the job was submitted.
|
| For example, if user SCOTT calls a package that runs in the security domain of SYS, and this package starts a job, the LOG_USER would be SCOTT.
|
PRIV_USER
| User whose default privileges apply to this job.
|
| For example, if user SCOTT calls a package that runs in the security domain of SYS, and this package starts a job, the PRIV_USER would be SYS.
|
SCHEMA_USER
| Default schema that parses the job.
|
| For example, if the SCHEMA_USER is SCOTT and you submit the procedure HIRE_EMP as a job, Oracle looks for SCOTT.HIRE_EMP.
|
LAST_DATE
| Last date that this job executed successfully, measured to the nearest day.
|
LAST_SEC
| Last date that this job executed successfully, measured to the nearest second.
|
THIS_DATE
| Date that the current execution of the job started, measured to the nearest day. Usually null if the job is not currently executing.
|
THIS_SEC
| Date that the current execution of the job started, measured to the nearest second. Usually null if the job is not currently executing.
|
NEXT_DATE
| Date that this job is next scheduled to be executed, measured to the nearest day.
|
NEXT_SEC
| Date that this job is next scheduled to be executed, measured to the nearest second.
|
TOTAL_TIME
| Total elapsed time spent by the system on this job, in seconds.
|
BROKEN
| "N" indicates that the job is not broken. "Y" indicates that the job is considered broken and will not be executed.
|
INTERVAL
| Date function that calculates the next time to execute the job.
|
FAILURES
| Number of times that the job was started and failed since it last successfully completed. After 16 failures, a job is marked as broken.
|
WHAT
| Job definition.
|
CURRENT_
SESSION_LABEL
| Trusted Oracle7 label of the current session, as seen by this job.
|
CLEARANCE_HI
| Highest level of clearance available to this job. Applies to Trusted Oracle7 only.
|
CLEARANCE_LO
| Lowest level of clearance available to this job. Applies to Trusted Oracle7 only.
|
NLS_ENV
| ALTER SESSION parameters that describe the NLS environment of this job.
|
MISC_ENV
| Other session parameters that apply to this job.
|
Column
| Description
|
SID
| Identifier of the session that is executing the job.
|
JOB
| Identifier of the job that is currently executing.
|
FAILURES
| Number of times the job was started and failed since it last successfully completed.
|
LAST_DATE
| Last date this job was successfully executed, measured to the nearest day.
|
LAST_SEC
| Last date this job was successfully executed, measured to the nearest second.
|
THIS_DATE
| Date the current execution of the job started, measured to the nearest day.
|
THIS_SEC
| Date the current execution of the job started, measured to the nearest second.
|
Column
| Description
|
OWNER
| Owner of the snapshot.
|
NAME
| Name of the view used by users and applications for querying and updating the snapshot.
|
TABLE_NAME
| Table in which the snapshot is stored (it has an extra column for the master rowid).
|
MASTER_VIEW
| View of the master table, owned by the snapshot owner, used for refreshes.
|
MASTER_OWNER
| Owner of the master table.
|
MASTER
| Master table that this snapshot copies.
|
MASTER_LINK
| Database link name to the master site.
|
CAN_USE_LOG
| YES if this snapshot can use a snapshot log, NO if this snapshot is too complex to use a log.
|
UPDATABLE
| `YES' indicates snapshot is updatable; `NO' indicates read-only.
|
LAST_REFRESH
| Date and time at the master site of the last refresh.
|
ERROR
| Error returned last time an automatic refresh was attempted or number of failed attempts since last successful attempt.
|
TYPE
| Type of refresh for all automatic refreshes: COMPLETE, FAST, FORCE.
|
NEXT
| Date function used to compute next refresh dates.
|
START_WITH
| Date function used to compute next refresh dates.
|
REFRESH_GROUP
| Group identifier for consistent refresh.
|
UPDATE_TRIG
| Name of the trigger that fills in the UPDATE_LOG for an updatable snapshot.
|
UPDATE_LOG
| Name of the table that logs changes to an updatable snapshot.
|
QUERY
| Query used to create the snapshot.
|
Column
| Description
|
ROWNER
| Owner of the refresh group.
|
RNAME
| Name of the refresh group.
|
REFGROUP
| ID number of the refresh group.
|
IMPLICIT_DESTROY
| Implicit delete flag. If this value is Y, Oracle deletes the refresh group after you have subtracted the last member from the group.
|
JOB
| ID number of the job used to execute the automatic refresh of the snapshot group. You can use this information to query the USER_JOBS view for more information about the job.
|
NEXT_DATE
| Date when the members of the group will next be refreshed.
|
INTERVAL
| The function used to calculate the interval between refreshes.
|
BROKEN
| Flag used to indicate a problem with the refresh group. If the value of the broken flag is Y, Oracle will not refresh the group, even if it is scheduled to be refreshed.
|
Column
| Description
|
OWNER
| Owner of the refresh group member.
|
NAME
| Name of the refresh group member.
|
TYPE
| Type of the refresh group member; for example, SNAPSHOT.
|
ROWNER
| Owner of the refresh group.
|
RNAME
| Name of the refresh group.
|
REFGROUP
| ID number of the refresh group.
|
IMPLICIT_DESTROY
| Implicit delete flag. If this value is Y, Oracle deletes the refresh group after you have subtracted the last member from the group.
|
JOB
| ID number of the job used to execute the automatic refresh of the snapshot refresh group. You can use this information to query the USER_JOBS view for more information about the job.
|
NEXT_DATE
| Date when the members of the group will next be refreshed.
|
INTERVAL
| The function used to calculate the interval between refreshes.
|
BROKEN
| Flag used to indicate a problem with the refresh group. If the value of the broken flag is Y, Oracle will not refresh the group, even if it is scheduled to be refreshed.
|