Versions Compared

Key

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

...

  1. Oracle Data Pump
  2. Standby Database
  3. Rman Duplicate
  4. Rman Restore and Recover
  5. Transportable Tablespace ( Enterprise Edition Only)
  6. LOAD function of Dbvisit Replicate
Info
  • Datapump script is used when you have few tables/schemas to be replicated and the data volume is low. 
  • Any of the option from 2, 3 and 4 can be used  when you have many schemas to be replicated and the data volume is huge. 
  • Transportable Tablespace is a wise choice over datapump for heterogeneous environment with the high data volume if you are using Enterprise Edition.