Re: multiple schemas per user - possible?

Not that obvious. How do you propose "maintaining parallel data sets for the same versions of the tables" with multiple databases?

If EMP is in both database A and database B, it's not the same table, is it? Never mind the same "version of the table".

Regards
HJR "Jake" <me_at_heyjay.com> wrote in message
news:am8peu$281$1_at_bob.news.rcn.net...
> Seems like everyone is neglecting the obvious, so I'll say it. Build
> another database. This way you don't have to have any code in your
> application to change schemas, or workspaces. You just connect as the
same
> user to a different database.
>
> Typical, dev, test, qa, prod environments
>
>
> "roger" <rsr_at_rogerwrae.com> wrote in message
> news:TKIh9.129711$Jo.36522_at_rwcrnsc53...
> > Hello there.
> >
> > Is there any way to create/manage/user multiple "schemas"
> > for a single database user?
> >
> > As I understand things, each user having a private schema,
> > has a set of tables, and these tables are all distinct from
> > any other identically named tables that reside in the private
> > schema of any other users.
> > That is fine great and handy.
> >
> > But, how do we account for a situation where a single user
> > would like to have serveral distinct versions of the tables in
> > his schema? For example, when developing/testing new versions
> > of some software, or simply maintaining parallel data sets for
> > the same versions of the tables...
> >
> >
> > I've read about synonyms, and while I understand that it is
> > possible to achieve this sort of indirection with them,
> > I sure hope there is a better answer than that available!
> >
> >
> > To me, it seems like a user should be able to create multiple
> > "schemas", add objects to the various schemas, and specify a
> > default schema which would be used in the absence of an explicit
> > schema reference, etc...
> >
> > Indeed, this seems like such a fundamental concept to me that
> > the fact that Oracle doesn't seem to work that way tells me I
> > must be missing something.
> >
> > Any suggestions appreciated.
>
>
Received on Tue Sep 17 2002 - 23:16:18 CDT