2010-10-11

How to copy synonyms from one user to another

Several times I'm asked this question:
How to copy synonyms from one user to another?

Here is the script you should use in the original user

SELECT 'create synonym '||synonym_name|| ' for '||table_owner||'.'||table_name|| CASE WHEN db_link IS NOT NULL THEN '@'||db_link END ||';' from user_synonyms

I then use the output in the destination user.

No comments:

Post a Comment

Os comentários são moderados.
The comments are moderated.