A synonym question
Date: Fri, 25 Jan 2008 11:54:05 -0800 (PST)
I have the following scenario:
- Tables and views are in Schema1 and Schema2
- Synonyms are created private under UserX
this works fine no problem.
Lately I created Schema3 and Schema4 to backup 1 and 2 respectively. Now I want to access these new schemas logging with userX and using the same synonyms, but the synonyms point to schema 1 and 2 how can I switch the same synonyms to point to schema3 and 4 dynamically?
Ziko Received on Fri Jan 25 2008 - 13:54:05 CST