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>

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

Original text of this message