I have a production 24/7 database and i am looking at refreshing the database, how is it possible ? Mind you ! Its a production 24/7 database nad hence cannot be shutdown ?

Editorial / Best Answer


  • Member Since Feb-2009 | Feb 11th, 2009

Why do you have to refresh a production database and with what will you refresh? You can refresh a Dev or Test Db. For production db you need to have a hot backup.

Showing Answers 1 - 3 of 3 Answers

rajat dey

  • Feb 20th, 2006


if you want to refresh the data  in specific interval basis you can use the facility of oracle 9i called materialized view (previuosly known as snapshot)


rajat dey

  Was this answer useful?  Yes

Chiranjeevi Manne

  • Mar 30th, 2007

Go for Replication using either Oracle Streams or Quest Shareplex

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.


Related Answered Questions


Related Open Questions