-
Data Migration from one database to another
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
-
create synonym mysynonym for mytable@prod;
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
|
|