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

Term: USER_REPKEY_COLUMNS

Definition:
In Oracle, the USER_REPKEY_COLUMNS dictionary view stores the information about the replication key columns in the tables, which are owned by the current user. During row level replication, replicating key columns determine the columns for comparison. Note that LOB type, collection type, REF type and object type columns cannot be the part of replication key column group. The structure of the view is shown below.

SNAME [VARCHAR2(30)] - Schema name containing the table
ONAME [VARCHAR2(30)] - Table name
COL [VARCHAR2(4000)] - Column name

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