We want to create a reporting database where no' delete' operation can be performed & all the records will be retained .Production DB & reporting DB are at different geographic location.In this scenario; what tool should be used for replication ? Can we achieve this using Data guard ? Can streaming be done over the WAN ? Does streaming has lot of overheads due to which performance may get hampered ?
This forum is for Berkeley DB replication. We do not have the expertise to answer questions about Oracle Data Guard or Streams. You may want to post your questions to one or both of the following forums: Data Guard Streams