Show TOC

Changes to alter subscriptionLocate this document in the navigation structure

In this release, you can change a subscription’s user and init-table options.

Syntax
alter subscription <subname>
for database replication definition <repdefname>
with primary at <pri_dataserver.pri_database>
with replicate at <data_server.database>
[user <username> password <password>]
[[not] [create | create or truncate | truncate | recreate] replicate table]]
Parameters
user <username> password <password>
Set the user who performs the select and mark operations at the primary for materialization.
[not] [create | create or truncate | truncate | recreate] replicate table
Change the way a materialized table is added to the replication path. At most one of the init-table options (create, create or truncate, truncate, or recreate) can be in force at a time. For details and restrictions, see Reference Manual SAP Replication Server > SAP Replication Server Commands > create subscription.
Usage
  • Executing alter subscription move replicate is not allowed while the database subscription is being materialized.