Reputation: 61
How to do that I am using oracle 10 g
Upvotes: 0
Views: 174
Reputation: 5145
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.
Upvotes: 2
Reputation: 1064
can you use data guard and take snapshots to work on whenever required?
Upvotes: 0