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.