DDL Commands and Objects Filtered from Replication

Some Oracle DDL commands and objects are not replicated.

These DDL commands are not replicated:
  • alter database

  • alter rollback segment

  • alter session

  • alter snapshot

  • alter snapshot log

  • alter system

  • alter tablespace

  • analyze

  • audit

  • create control file

  • create database link

  • create pfile from spfile

  • create rollback segment

  • create schema authorization

  • create snapshot

  • create snapshot log

  • create spfile from pfile

  • create tablespace

  • drop database link

  • drop rollback segment

  • drop snapshot

  • drop snapshot/log

  • drop tablespace

  • explain

  • lock table

  • no audit

  • rename

  • set constraints

  • set role

  • set transaction

Any objects that are owned by SYS are not replicated. Any object owned by users defined in the list of nonreplicated users is not replicated. You can modify this list using the pdb_ownerfilter command. In addition, Sybase has provided a default list of owners whose objects are not replicated. However, you cannot remove the SYS owner. Use the pdb_ownerfilter command to return, add, or remove the list of owners whose objects are not replicated. See the Replication Agent Reference Manual.

Note: The truncate table command is replicated as rs_truncate.