Quick Search:
 The Oracle PL/SQL ALL_REPRESOLUTION Keyword      [Return To Index] Jump to:  


In Oracle PL/SQL, the ALL_REPRESOLUTION dictionary view maintains the methods to resolve transaction conflicts (delete, update, or uniqueness) for each table, which can be accessed by the current user.

The structure of the view is as 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
SEQUENCE_NO [NUMBER] - Order of application of resolution
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
RESOLUTION_COMMENT [VARCHAR2(80)] - User comments on conflict resolution

   Home |    Search |    Code Library |    Sponsors |    Privacy |    Terms of Use |    Contact Us © 2003 - 2024 psoug.org