Hi folks,

we have production database 11.2.0.3.0 which is RAC mode & user by name PRDODTA in the Database which has several tables & develpoment database 11.2.0.3.0 which is also RAC mode & user by name CRPDTA which has several tables. so my question is here how to refresh data periodically from production to developement.
i know dblink is the way but any one could assits me the whole scripts or dbms job

i have created db link from dev DB (user crpdta) to prod (user proddta)

At Dev side
>create database link refresh
connect to proddta identified by password
using to-prod;


thanks & regards