Re: [Q] create second schema under a account

"aaa" <mccdba_at_yahoo.com> a écrit dans le message de news:cqv6dh03s7_at_drn.newsguy.com...
| 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
|
| 3. switch between schemas
|
|
| Thanks.
|

From Concepts documentation, chapter 10 "Schema Objects", section "Introduction to Schema Objects", url:
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96524/c11schem.htm#22628

<quote>
A schema is a collection of logical structures of data, or schema objects. A schema is owned by a database user and has the same name as that user. Each user owns a single schema. </quote>

Regards
Michel Cadot Received on Wed Dec 29 2004 - 15:45:36 CST