ALTER CONNECTION

Purpose

Use this statement to change the connection data of an external connection.

Prerequisite

You need to have the system privilege ALTER ANY CONNECTION or the connection must be granted to the user with the WITH ADMIN OPTION.

Syntax

alter_connection::=

Alter Connection

Alter Connection

Examples

ALTER CONNECTION ftp_connection
      TO 'ftp://192.168.1.1/'
      USER 'agent_008'
      IDENTIFIED BY 'secret';
ALTER CONNECTION exa_connection TO '192.168.6.11..14:8564';
ALTER CONNECTION ora_connection TO '(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.6.54)(PORT = 1522))
(CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = orcl)))';