drop logical connection

Drops a logical connection. Logical connections are used to manage warm standby applications.

Syntax

drop logical connection to <data_server>.<database>

Parameters

data_server: The logical data server specified in the create logical connection command.
database: The name of the database specified in the create logical connection command.

Examples

Example 1

Drops the logical connection for a data server named LDS and a database named <pubs2>:

drop logical connection to LDS.pubs2

Usage

Use this command to drop a logical connection when you are dismantling a warm standby application.
Before you can drop the logical connection, you must drop the connection to the standby database.

Permissions

drop logical connection requires “sa” permission.