Categories:

システム関数 (System Control)

SYSTEM$DISABLE_DATABASE_REPLICATION

Disable replication for a primary database and any secondary databases linked to it.

If a database was previously enabled for replication using ALTER DATABASE ... ENABLE REPLICATION TO ACCOUNTS, database replication must be disabled before the database can be added to a replication or failover group.

Syntax

SYSTEM$DISABLE_DATABASE_REPLICATION('<db_name>');

Arguments

db_name

Specifies the identifier for the database.

Usage Notes

  • Only account administrators (users with the ACCOUNTADMIN role) can execute this SQL function.

  • This function must be executed from the source account with the primary database.

Examples

Disable replication for primary database mydb and any linked secondary databases.

Executed from the source account:

SELECT SYSTEM$DISABLE_DATABASE_REPLICATION('mydb');
最上部に戻る