Oracle7 Server Distributed Systems Volume II: Replicated Data

DBMS_DEFER_SYS.ADD_DEFAULT_DEST

Purpose

To add a destination database to the DefDefaultDest view. For additional information, refer to

Syntax

The parameter for the ADD_DEFAULT_DEST procedure is described in Table 12 - 14, and the exception is listed in Table 12 - 15. The syntax for this procedure is shown below:

DBMS_DEFER_SYS.ADD_DEFAULT_DEST(	dblink	IN	VARCHAR2)

Parameter Description
dblink The fully qualified database name of the node that you want to add to the DefDefaultDest view.

Table 12 - 14. Parameter for ADD_DEFAULT_DEST

Exception Description
ORA-23352 The DBLINK that you specified is already in the default list.

Table 12 - 15. Exception for ADD_DEFAULT_DEST

Parameter	Description
`dblink`	The fully qualified database name of the node that you want to add to the DefDefaultDest view.

Exception	Description
ORA-23352	The DBLINK that you specified is already in the default list.