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.