Home Oracle Commands Oracle Data Dictionary
v$ Performance views

DBA_REPCOLUMN

Replicated top-level columns (table) sorted alphabetically in ascending order

Columns
   ___________________________
 
   SNAME
      Name of the object owner
   ONAME
      Name of the object
   TYPE
      Type of the object
   CNAME
      Name of the replicated column
   ID
      ID of the replicated column
   POS
      Ordering of the replicated column
   COMPARE_OLD_ON_DELETE
      Compare the old value of the column in replicated deletes
   COMPARE_OLD_ON_UPDATE
      Compare the old value of the column in replicated updates
   SEND_OLD_ON_DELETE
      Send the old value of the column in replicated deletes
   SEND_OLD_ON_UPDATE
      Send the old value of the column in replicated updates
   CTYPE
      Type of the column
   CTYPE_TOID
      Type OID of a column of TYPE
   CTYPE_OWNER
      Type owner of a column of TYPE
   CTYPE_HASHCODE
      Type hashcode of a column of TYPE
   CTYPE_MOD
      Datatype modifier of a column
   DATA_LENGTH
      Length of the column in bytes
   DATA_PRECISION
      Length: decimal digits (NUMBER) or binary digits (FLOAT)
   DATA_SCALE
      Digits to right of decimal point in a number
   NULLABLE
      Does column allow NULL values?
   CHARACTER_SET_NAME
      Name of character set for column,if applicable
   TOP
      Top column name for an attribute
   CHAR_LENGTH
      The maximum length of the column in characters
   CHAR_USED
      C if the width was specified in characters,B if in bytes

Related:



Simon Sheppard
SS64.com