Updating tables through object views in oracle

Having said that, I think your options are: The best option is to use another Data Guard instance (not schema, it have no sense) on another machine.

In this case you can have an up-to-date database an no disturb the production application.

And if the queries against materialized views also doesn't waste too many resources.

"We always did feel the same, We just saw it from a different point of view…

We need to run reports at a scheduled time of the day.

The application runs 24*7 and so there is not "off-peak" time as such.

Therefore, running the reports should not add undue load on the system.

Leave a Reply

Your email address will not be published. Required fields are marked *

One thought on “updating tables through object views in oracle”

  1. But HDTV is far from just one standard – it incorporates a couple of different resolutions, two different scanning modes, and a number of different frame rates. Simply put, its tech-geek slang for ‘next generation’ and what that means is the console in question is a completely new version of either an established console or a completely new console that is on more powerful in what it can do when compared with current consoles on the market.