Re: A synonym question
Date: Fri, 25 Jan 2008 12:28:18 -0800 (PST)
On Jan 25, 3:14 pm, Frank van Bortel <frank.van.bor..._at_gmail.com> wrote:
> nspa..._at_gmail.com wrote:
> > 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
> Accounts and schema's have a relationship. Your userX has
> schemaX; schemaX has synonyms pointing to One.table_1
> and One.view_1 (without going into the discussion whether
> one stands for the account, or for the schema).
> One belongs to user1 (which is schema1). You cannot
> point to user4 'dynamically'.
> Just drop the synonym, and re-create it while pointing to
> the other schema.
> The other schema's being backups, I fail to see the point
> of this exercise. Do not touch your backup!
> Frank van Bortel
> Top-posting in UseNet newsgroups is one way to shut me up- Hide quoted text -
> - Show quoted text -
The new created schemas are actually an archive not backup my
I want to connect with the same user and dynamically switch between main database and archive one.
Ziko Received on Fri Jan 25 2008 - 14:28:18 CST