Quick Search:
CODE
Oracle PL/SQL Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
 The Oracle PL/SQL ALL_REPRESOLUTION_STATISTICS Keyword      [Return To Index] Jump to:  
  Looking for the original pages? (formerly called "Morgan's Library") You can find them here.

Term: ALL_REPRESOLUTION_STATISTICS

Definition:
In Oracle PL/SQL, the ALL_REPRESOLUTION_STATISTICS dictionary view contains information about all the successfully resolved conflicts for the replicated tables, which can be accessed by the current user. The table stats can be gathered using DBMS_REPCAT.REGISTER_STATISTICS method call.

The structure of the view is shown below.

SNAME [VARCHAR2(30)] - Schema name containing the replicating group
ONAME [VARCHAR2(30)] - Replicated object group name
CONFLICT_TYPE [VARCHAR2(10)] - Conflict type
REFERENCE_NAME [VARCHAR2(30)] - Table, constraint or column group
METHOD_NAME [VARCHAR2(80)] - Name of conflict resolution method
FUNCTION_NAME [VARCHAR2(92)] - Name of the function for 'user function' method
PRIORITY_GROUP [VARCHAR2(30)] - Priority group name used for conflict resolution method
RESOLVED_DATE [DATE] - Date with timestamp of conflict resolution
PRIMARY_KEY_VALUE [VARCHAR2(2000)] - Primary key of the replicating row.

 
Home      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us 55 users online    © 2009 psoug.org
PSOUG LOGIN
Username: 
Password: 
Forgot your password?