-
synchronise data
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
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|