ALTER REMOTE MESSAGE TYPE message-system
ADDRESS address

message-system : FILE | FTP | SMTP

address : string

The statement changes the publisher's address for a given message type.

The Message Agent sends outgoing messages from a database by one of the supported message links. The Extraction utility uses this address when it executes the GRANT CONSOLIDATE statement in the remote database.

The address is the publisher's address under the specified message system. If it is an email system, the address string must be a valid email address. If it is a file-sharing system, the address string is a subdirectory of the directory specified by the SQLREMOTE environment variable, or of the current directory if that is not set. You can override this setting on the GRANT CONSOLIDATE statement at the remote database.

You must have the SYS_REPLICATION_ADMIN_ROLE system role.

Automatic commit.

• CREATE REMOTE [MESSAGE] TYPE statement [SQL Remote]
• GRANT CONSOLIDATE statement [SQL Remote]
• SQLREMOTE environment variable
• SQL Remote message systems
• Altering a message type

The following statement changes the publisher's address for the FILE message link to new_addr.

ALTER REMOTE MESSAGE TYPE file
ADDRESS 'new_addr';