Name
DBMS_REPCAT.GENERATE_REPLICATION_PACKAGE
Synopsis
In some situations, you may wish to generate only replication support packages. GENERATE_REPLICATION_PACKAGE generates the table_name$RP package for the specified object at all master sites. The package is required for all tables participating in low-level replication.
PROCEDURE DBMS_REPCAT.GENERATE_REPLICATION__PACKAGE
(sname IN VARCHAR2,
oname IN VARCHAR2);Parameters
Parameter Name | Description |
|---|---|
sname | Name of the schema to which table oname belongs |
oname | Name of table for which package is being generated |
Exceptions
Exception Name | Number | Description |
|---|---|---|
commfailure | –23317 | Unable to communicate with all masters. |
dbnotcompatible | –23375 | One or more masters is a pre-7.3 release. |
missingobject | –23308 | Table oname does not exist in schema sname. |
nonmasterdef | –23312 | Calling site is not a master definition site. |
notquiesced | –23310 | Replication group to which object belongs is not quiesced. |
Restrictions
You must call this procedure from the master definition site.
The replication group must be quiesced.
The Oracle version must be 7.3 or later.