ALL_REPPRIORITY

Contains the value and priority level of each priority group member in each priority group accessible to the current user. Priority group names must be unique within a replication group. Priority levels and values must each be unique within a given priority group.

Related Views:

• DBA_REPPRIORITY contains the value and priority level of each priority group member in each priority group in the database.

• USER_REPPRIORITY contains the value and priority level of each priority group member in each priority group owned by the current user.

  Column	Datatype	NULL	Description
  SNAME	VARCHAR2(30)	NOT NULL	The name of the replicated schema. Obsolete in release 7.3 or later.
  PRIORITY_GROUP	VARCHAR2(30)	NOT NULL	The name of the priority group or site priority group.
  PRIORITY	NUMBER	NOT NULL	The priority level of the member. The highest number has the highest priority.
  DATA_TYPE	VARCHAR2(9)		The datatype of the values in the priority group.
  FIXED_DATA_LENGTH	NUMBER(38)		The maximum length of values of datatype CHAR.
  CHAR_VALUE	CHAR(255)		The value of the priority group member, if DATA_TYPE is CHAR.
  VARCHAR2_VALUE	VARCHAR2(4000)		The value of the priority group member, if DATA_TYPE is VARCHAR2.
  NUMBER_VALUE	NUMBER		The value of the priority group member, if DATA_TYPE is NUMBER.
  DATE_VALUE	DATE		The value of the priority group member, if DATA_TYPE is DATE.
  RAW_VALUE	RAW(2000)		The value of the priority group member, if DATA_TYPE is RAW.
  GNAME	VARCHAR2(30)	NOT NULL	The name of the replication group.
  NCHAR_VALUE	NCHAR(500)		The value of the priority group member, if DATA_TYPE is NCHAR.
  NVARCHAR2_VALUE	VARCHAR2(1000)		The value of the priority group member, if DATA_TYPE is NVARCHAR2.
  LARGE_CHAR_VALUE	CHAR(2000)		The value of the priority group member, for blank-padded character strings over 255 characters.

  Note: The SNAME and GNAME columns are not present in the USER_REPPRIORITY view.