The following describes how to unmark a stored procedure.
To unmark a stored procedure
Log in to the Mirror Replication Agent instance with the administrator login.
Use the pdb_setrepproc command to confirm that the stored procedure is marked in the primary database:
pdb_setrepproc pdb_proc
where pdb_proc is the name of the stored procedure that you want to unmark.
If the pdb_setrepproc command returns information that the specified stored procedure is marked, continue this procedure to unmark the stored procedure.
If the pdb_setrepproc command does not return information that the specified stored procedure is marked, you do not need to continue this procedure.
Use the pdb_setrepproc command to disable replication of the stored procedure:
pdb_setrepproc pdb_proc, disable
where pdb_proc is the name of the stored procedure that you want to unmark.
Use the pdb_setrepproc command to remove the replication marking from the stored procedure:
pdb_setrepproc pdb_proc, unmark
where pdb_proc is the name of the stored procedure that you want to unmark.
If you need to force the unmark, you can use the following command:
pdb_setrepproc pdb_proc, unmark, force
Use the pdb_setrepproc command to confirm that the stored procedure is no longer marked for replication:
pdb_setrepproc pdb_proc
where pdb_proc is the name of the stored procedure in the primary database that you unmarked.
You can unmark all marked stored procedures in the primary database by invoking the pdb_setrepproc command with the all keyword.
For Oracle only: If you disabled
DDL replication during stored procedure unmarking, remember to re-enable
DDL replication. See “Enabling replication for DDL”.
