O'Reilly logo
  • Eric Chen thinks this is interesting:

have been some non-RMAN replication solutions that I’ve used; below I explain why:

  • External tables or SQL*Loader: A customer sends a spreadsheet or csv file with a request to load it into the database. If I’m loading over a network link then I’ll use SQL*Loader, otherwise I use external tables to load data from csv files.
  • exp/imp: I got lazy once or twice and just wanted to export one table and so I decided to use the deprecated exp utility. Having said that, Data Pump is a vastly superior tool for any tasks that exp/imp have historically been used for.
  • Data Pump: This tool really excels when you need to trans...


Cover of Oracle RMAN Database Duplication


For granular manipulation of the database