Hi Firends..
I have to refresh my UAT DB with my Prod DB while doing so i always have to recreate the synonyms and also have to grant the priveleges once again on the target DB.
As i am using EXPDP to backup my DB and as this being a logical backup and a logical backup means the objects which includes synonyms as well, are backed up and then during import this should be recreated in the target DB.
Following are the command that i am using:
expdp dumpfile=file_name.dmp logfile=logfile_name.log schemas=abc_liv directory=DATA_PUMP_DIR status=100 exclude=statistics
impdp dumpfile=file_name.dmp logfile=logfile_name.log remap_schema=abc_liv:abc directory=DATA_PUMP_DIR
where:
abc_liv = prod schema
abc = uat schema
Note:
UAT and Prod DB both has three schemas each and there are lots of dependencies among the three schemas.
UAT schemas names are different and Prod schemas names are different.
Kindly enlighten me...
BR