This script changes the Referenced Owner/Schema of Synonyms. This Schema does not need to be created on MR.

To change this, you only need to specify which owner you want to change and what is the new owner name. Just look at the code and you'll see where to input that.

Here's an example:

I have this Synonym: create or replace synonym Schema001.SYN_TBL_TEST for Schema002.TBL_TEST;

Now, i want to change the Schema002 name. So i change the following lines:

  fromUser = "Schema002"
  toUser = "NewSchema003"

Then i run it. Done! The synonym will be like this:

 create or replace synonym Schema001.SYN_TBL_TEST for NewSchema003.TBL_TEST;

 Att,

Ricardo