What does Dbvisit Replicate replicate?

Owned by Arjen Visser
Last updated: Dec 10, 2013

Dbvisit Replicate can replicate on different levels. It can replicate:

  • Whole database (except sys and system objects).
  • Whole schemas.
  • Individual tables.
  • PL/SQL1

Dbvisit Replicate replicates both:

  • DML (data changes)
  • DDL Not all DDL is supported. For example create tablespace is not supported.  DDL is only supported for if the target is an Oracle database.

Dbvisit Replicate does NOT replicate:

  • Triggers
  • Constraints
  • Sequences
  • Database structure
  • ALTER DATABASE commands
  • ALTER SYSTEM commands

 

1

PL/SQL replication works as follows:

  • Dbvisit Replicate does not support creating the initial copy of the PL/SQL code.
  • Dbvisit Replicate replicates all create/alter/drop procedure/function/package/package body commands. Dbvisit Replicate does not replicate the actual code, Dbvisit Replicate replicates all DDLs for it.
  • Dbvisit Replicate currently does not replicate triggers, java, types, objects, synonyms, indextypes, mining models, editions, assemblies, flashback archives.