tags:

views:

40

answers:

2

How to do that I am using oracle 10 g

A: 

can you use data guard and take snapshots to work on whenever required?

A.Rashad
+1  A: 

You may use Oracle DataPump utility. In my project, this is automated with help of a simple script and Windows scheduled task. The script exports from central DB and then import into dev DB. Depends on your requirements, you may export/import in DB/Schema/Table level.

Sujee