Name
DBMS_REPCAT.DEFINE_PRIORITY_GROUP
Synopsis
The DEFINE_PRIORITY_GROUP procedure creates a new priority group. The new group does not take effect until you call GENERATE_REPLICATION_SUPPORT for the table. The specifications differ for Oracle7 and Oracle8 as follows.
Oracle7 specification:
PROCEDURE DBMS_REPCAT.DEFINE_PRIORITY_GROUP
(gname IN VARCHAR2 := '',
pgroup IN VARCHAR2,
datatype IN VARCHAR2,
fixed_length IN INTEGER := NULL,
comment IN VARCHAR2 := NULL,
sname IN VARCHAR2 := '');Oracle8 specification:
PROCEDURE DBMS_REPCAT.DEFINE_PRIORITY_GROUP
(gname IN VARCHAR2 := '',
pgroup IN VARCHAR2,
datatype IN VARCHAR2,
fixed_length IN INTEGER := NULL,
comment IN VARCHAR2 := NULL);Parameters
Parameter Name | Description | ||||||
|---|---|---|---|---|---|---|---|
gname | Name of the replication group containing the priority group. | ||||||
pgroup | Name of the priority group. | ||||||
datatype | Datatype for the value used in the priority group. Supported datatypes:
| ||||||
fixed_length | Fixed length for values. Used only for datatype CHAR. | ||||||
comment | Comment. | ||||||
sname (Oracle7 only) | Schema name (provided for pre-Oracle 7.3 compatibility). |
Exceptions
Exception Name | Number | Description |
|---|---|---|
duplicateprioritygroup | –23335 | Priority group pgroup already exists. |
missingschema | –23306 | Schema does not exist. |
nonmasterdef | –23312 | Calling site is not the master definition site. |
typefailure | –23319 | Datatype not supported. |
Restrictions
You must call the DEFINE_PRIORITY_GROUP procedure from the master definition site.