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

From: dba1 mcc <mccdba1_at_yahoo.com>
Date: Wed, 29 Dec 2004 13:07:59 -0800 (PST)
Message-ID: <20041229210759.30516.qmail@web60801.mail.yahoo.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.

---

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

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

Received on Wed Dec 29 2004 - 15:08:02 CST