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

msvkrishna  

  • 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 - 1 of 1 Answers

rajat dey

  • Feb 20th, 2006
 

Hi,

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)

regrds

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