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...
For granular manipulation of the database
Share this highlighthttp://www.safaribooksonline.com/a/oracle-rman-database/273584/