...
- Whole database (except sys and system objects).
- Whole schemas.
- Individual tables.
- Partial tables. Filtering can be done by row level.
- Partial tables. Certain columns can be excluded.
- PL/SQL1
Dbvisit Replicate replicates both:
...
| Note |
|---|
|
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.
|
| Note |
|---|
|
By default certain objects are excluded. The Oracle Compression Advisor creates tables with name like DBMS_TABCOMP_TEMP_CMP . These tables are automatically excluded from replication.
Oracle scheduler creates tables with name like SCHEDULER$_. These tables are automatically excluded from replication. |