ALL_REPCOLUMN

Lists the replicated columns for the tables accessible to the current user.

If the table contains a column object, then this view displays a placeholder for the type and one row for each type attribute. If the table contains a nested table, then then this view displays the storage table for the nested table as an independent table. If a table is an object table, then this view displays the hidden object identifier column.

Related Views:

• DBA_REPCOLUMN describes the replicated columns for all the tables in the database.
• USER_REPCOLUMN describes the replicated columns for all the tables owned by the current user.

  Column	Datatype	NULL	Description
  SNAME	VARCHAR2(30)	NOT NULL	The name of the object owner.
  ONAME	VARCHAR2(30)	NOT NULL	The name of the object.
  TYPE	VARCHAR2(8)	-	The type of the object, either MATERIALIZED VIEW or TABLE.
  CNAME	VARCHAR2(4000)	-	The name of the replicated column.
  ID	NUMBER	-	The ID number of the replicated column.
  POS	NUMBER	-	The ordering of the replicated column.
  COMPARE_OLD_ON_DELETE	VARCHAR2(1)	-	Indicates whether Oracle compares the old value of the column in replicated deletes.
  COMPARE_OLD_ON_UPDATE	VARCHAR2(1)	-	Indicates whether Oracle compares the old value of the column in replicated updates.
  SEND_OLD_ON_DELETE	VARCHAR2(1)	-	Indicates whether Oracle sends the old value of the column in replicated deletes.
  SEND_OLD_ON_UPDATE	VARCHAR2(1)	-	Indicates whether Oracle sends the old value of the column in replicated updates.
  CTYPE	VARCHAR2(30)	-	Displays the column type. For user-defined types, displays the user-defined type name.
  CTYPE_TOID	RAW(16)	-	If user-defined type, displays the object identifier (OID) of the type. Otherwise, this field is NULL.
  CTYPE_OWNER	VARCHAR2(30)	-	If user-defined type, displays the owner of a user-defined type. Otherwise, this field is NULL.
  CTYPE_HASHCODE	VARCHAR2(34)	-	If user-defined type, displays the type's hashcode. Otherwise, this field is NULL.
  CTYPE_MOD	VARCHAR2(3)	-	Displays REF for REF columns. Otherwise, this field is NULL.
  DATA_LENGTH	VARCHAR2(40)	-	Displays the length of the column in bytes.
  DATA_PRECISION	VARCHAR2(40)	-	Displays the column precision in terms of decimal digits for NUMBER columns or binary digits for FLOAT columns.
  DATA_SCALE	VARCHAR2(40)	-	Displays the digits to right of decimal point in a number.
  NULLABLE	VARCHAR2(1)	-	Indicates if the column allow NULL values.
  CHARACTER_SET_NAME	VARCHAR2(44)	-	If applicable, displays the name of character set for the column.
  TOP	VARCHAR2(30)	-	Displays the top column for an attribute in a column object. For example, in the oe.customers table, cust_address is a column object and street_address is one of its attributes. For the street_address attribute, cust_address is the TOP column. For built-in datatypes, this field is NULL
  CHAR_LENGTH	NUMBER	-	Displays the length of the column in characters. This value only applies to the following datatypes: CHAR VARCHAR2 NCHAR NVARCHAR2
  CHAR_USED	VARCHAR2(1)	-	B indicates that the column uses BYTE length semantics. C indicates that the column uses CHAR length semantics. NULL indicates that the datatype is not any of the following: CHAR VARCHAR2 NCHAR NVARCHAR2