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

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@xxxxxxxxx]=20
Sent: Wednesday, December 29, 2004 4:08 PM
To: oracle-l@xxxxxxxxxxxxx
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

Other related posts: