Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: [Q] create second schema under a account ???
"aaa" <mccdba_at_yahoo.com> a écrit dans le message de news:cqv6f0041l_at_drn.newsguy.com...
| 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.
|
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:44:38 CST