we have production database 220.127.116.11.0 which is RAC mode & user by name PRDODTA in the Database which has several tables & develpoment database 18.104.22.168.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
thanks & regards
When I supported customers who run JD Edwards, I used data pump export and import to refresh the CRPDTA/CRPCTL schemas from PRODDTA/PRODCTL. If you have Enterprise edition, then compression=ALL and PARALLEL=8 can help depending on how many cores your prod server has compared with your test server.
Our requirement is to refresh data (i mean DML or DDL operations) from production database schema's to developement database periodically. could you assits me the complete way how the task to be done.
By the way you said " I used data pump export and import to refresh the CRPDTA/CRPCTL schemas from PRODDTA/PRODCTL" , i think it will be used for only compression, make he job easy.
Thanks & regards.
By the way... I think you should read about expdp and impdp.
Originally Posted by younusdba
1. expdp the schema on PROD
2. FTP the dump file to DEV host
3. Drop schema on DEV host
4. Create schema on DEV host
5. impdp dump file into DEV schema