Re: [Q] create second schema under a account ???

From: HansF <News.Hans_at_telus.net>
Date: Thu, 30 Dec 2004 01:16:04 GMT
Message-Id: <pan.2004.12.30.01.15.33.622495@telus.net>

On Wed, 29 Dec 2004 13:09:52 -0800, aaa wrote:

> e 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
>
> 3. switch between schemas
>
>
> Thanks.

I suspect you are having a difficulty with terminology. Others have given some answers which may help, but ... please tell us how you interpret the terms "a user, a schema, a database and an instance", referring to both the operating system and the database/instance.

Based on your response, we might be able to give better direction.

/Hans Received on Wed Dec 29 2004 - 19:16:04 CST