Database cloning. [message #415232] |
Sun, 26 July 2009 10:27 |
srini_thiru
Messages: 133 Registered: May 2008
|
Senior Member |
|
|
Hi Gurus,
We have a production database and one development database. Our developers want the development database to be updated with the production database with every two days once. Actually i was doing export in production and then import in test database.
Actually only some rows will be modified in all the tables.
Is that any other way to refresh the test database like cloning the database or creating the standby database.
Please share your comments.
Thanks in Advance,
Seenu.
|
|
|
Re: Database cloning. [message #415341 is a reply to message #415232] |
Mon, 27 July 2009 05:37 |
babuknb
Messages: 1736 Registered: December 2005 Location: NJ
|
Senior Member |
|
|
>>Our developers want the development database to be updated with the production database with every two days once
What's your prodcution database size?
>>Is that any other way to refresh the test database like cloning the database or creating the standby databas
Yes Physical Standby database
Use Advanced Replicaiton (It's Materialized View based replication (only use read only materialized views))
[Updated on: Mon, 27 July 2009 07:23] Report message to a moderator
|
|
|