Versions Compared

Old Version 10

changes.mady.by.user Arjen Visser

Saved on

compared with

New Version 11

changes.mady.by.user Arjen Visser

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Before data replication can start, the target database must have a copy of the database objects that are going to be replicated. It is also highly desirable necessary that the data in the objects to be replicated are also completely in sync. If the data is not in sync before replication starts, there is a strong possibility that data conflicts can occur. For instance if a record is updated or deleted on the source database that does not exist on the target database.

...

Info
  • The Data Pump option (option 1 above) is best used when the whole database does not need to be replicated, but only a select number of schemas and tables. Also use this option when the source and target databases are different Oracle versions and on different Operating Systems.
  • Options 2, 3 and 4 above can be used when the entire database or many schemas need to be replicated.
  • The Transportable Tablespace option can be used for heterogeneous environment when the whole database needs to be replicated or there is a very high data volume.

The options are available through the setup wizard. In the following pages, each option will be described.

Note

Only when the target database is Oracle, Dbvisit Replicate assists in creating the starting point. If the target database is not Oracle, then this will have to be done manually. Please see Data instantiation for non Oracle for more information.

...