How to do that I am using oracle 10 g
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.
can you use data guard and take snapshots to work on whenever required?
精彩评论