Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

refresh QA from produsction daily

BoochiMay 7 2008 — edited May 13 2008

I need to refresh one QA database from its production daily. The database version is 9.2.0.8 EE.

There are around 400 objects in the production schema. The export and import of complete schema daily is a time consuming process and also hit the performance of production database. Also, the QA app server to be taken offline daily. Is there any way apart from cloning and export/import. I'm thinking of asynchronous unidirectional replication scheduled to push daily once. Could someone suggest me best.

Thanks in advance.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 10 2008

Added on May 7 2008

#general-database-discussions

14 comments

837 views