SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Synonyms for multiple tables

Ste74Sep 8 2014 — edited Sep 11 2014

Hi,

I have a trigger that in specific condition change 14 synonyms to 14 different tables.

From the official documentation there isn't possible to create synonym for more then one table simultaneously.

Do you know any tips to simplify this operation?

Thanks,

Ste

This post has been answered by Solomon Yakobson on Sep 9 2014

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 9 2014

Added on Sep 8 2014

27 comments

6,684 views