Name
DBMS_REPCAT.ALTER_SITE_PRIORITY_SITE
Synopsis
The ALTER_SITE_PRIORITY_SITE procedure is analogous to the ADD_PRIORITY_datatype procedure; use it to change the site name for an existing named site in a site priority group. The specifications for Oracle7 and Oracle8 differ as follows.
Oracle7 specification:
PROCEDURE DBMS_REPCAT.ALTER_SITE_PRIORITY_SITE
(gname IN VARCHAR2 := '',
name IN VARCHAR2,
old_site IN VARCHAR2,
new_site IN VARCHAR2,
sname IN VARCHAR2 := '');Oracle8 specification:
PROCEDURE DBMS_REPCAT.ALTER_SITE_PRIORITY_SITE
(gname IN VARCHAR2 := '',
name IN VARCHAR2,
old_site IN VARCHAR2,
new_site IN VARCHAR2);Parameters
Parameter Name | Description |
|---|---|
gname | Name of the replication group to which the site priority group name belongs |
name | Name of the site priority group |
old_site | Global name of the site currently associated with the priority level |
new_site | Global name of the site that is to replace old_site at old_site’s priority level |
sname (Oracle7 only) | Schema name (provided for pre-Oracle 7.3 compatibility) |
Exceptions
Exception Name | Number | Description |
|---|---|---|
duplicatesite | –00001 | new_site is already in the site priority group. |
missingpriority | –01403 | Site priority group name does not exist. |
missingrepgroup | –23373 | Replication group gname does not exist. |
missingvalue | –23337 | old_site is not in the site priority group. |
nonmasterdef | –23312 | Calling site is not the master definition site. |
Restrictions
You must call this procedure from the master definition site.
The new site must be unique in the site priority group.