RE: [Q] How to create second schema under a user account?

From: Goulet, Dick <DGoulet_at_vicr.com>
Date: Wed, 29 Dec 2004 16:17:54 -0500
Message-ID: <4001DEAF7DF9BD498B58B45051FBEA650207A1DE@25exch1.vicorpower.vicr.com>

I think you're a little confused. A user and a schema are one and the same. There's no way that I know of to build a second schema under a user. Now you can allow a user to proxy for another user.=20

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-----Original Message-----

From: dba1 mcc [mailto:mccdba1_at_yahoo.com]=20 Sent: Wednesday, December 29, 2004 4:08 PM To: oracle-l_at_freelists.org
Subject: [Q] How to create second schema under a user account?

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.

---

Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around=20 http://mail.yahoo.com=20
--

http://www.freelists.org/webpage/oracle-l
--

http://www.freelists.org/webpage/oracle-l Received on Wed Dec 29 2004 - 15:17:42 CST