Re: [Q] create second schema under a account

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Fri, 31 Dec 2004 05:17:04 +1100
Message-ID: <41d44628$0$3844$afc38c87@news.optusnet.com.au>

Serge Rielau wrote:

[snip]

>>>>> we have ORACLE 9.2.0.6 on UNIX server.  I know ORACLE support 
>>>>> multiple schemas
>>>>> under a user account.
>>>>>  Does any know how to do following and give me a sample:
>>>>>
>>>>>    1. create second schema under a user
>>>>>    2. create table or view under second schema

> Actually I'm not so sure I am missing the OP's point. The OP may be
> trying to apply a DB2 for LUW or SQL Standard background to Oracle.

He may be doing many things. But the content of his question as written is what I tend to look at. And the content of his initial statement and the first part of his actual question indicates that he doesn't understand the fundamental principle that a schema = a single user account that owns something.

> What
> you just explained may get him/her there.

So would just learning the fundamental principle. And probably a lot simpler and a lot quicker. KISS, after all. :-)

Regards
HJR Received on Thu Dec 30 2004 - 12:17:04 CST