- 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.
|