Data Migration from one database to another

[oupickitup]

Hi,
I am trying to move data from one table in one database to another table in another database using PL/SQl. I am using database link for database connectivity.

This data needs to be moved in 3 instances(dev,test and prod).

I was wondering how can I use synonyms here in order to not to change my code for each instance ?

Also, is there any better way to do this.

Any help is appreciated.

Thanks

[skhanal]

create synonym mysynonym for mytable@prod;