A synonym question
From: <nsparta_at_gmail.com>
Date: Fri, 25 Jan 2008 11:54:05 -0800 (PST)
Message-ID: <4ff5820f-db4c-46a0-9f4e-2602106d0d4d@e23g2000prf.googlegroups.com>
Date: Fri, 25 Jan 2008 11:54:05 -0800 (PST)
Message-ID: <4ff5820f-db4c-46a0-9f4e-2602106d0d4d@e23g2000prf.googlegroups.com>
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?
Thank You,
Ziko
Received on Fri Jan 25 2008 - 13:54:05 CST