RE: [Q] How to create second schema under a user account?
- From: "Lex de Haan" <lex.de.haan@xxxxxxxxxxxxxx>
- To: <DGoulet@xxxxxxxx>, <mccdba1@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 29 Dec 2004 22:33:26 +0100
yep -- Oracle does support the ANSI/ISO standard CREATE SCHEMA command,
but it *fails* if the schema name does not correspond with the name of an
existing database user...
Lex.
----------------------------------------------------------------
Tom Kyte Seminar: http://www.naturaljoin.nl/events/seminars.html
----------------------------------------------------------------
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Goulet, Dick
Sent: Wednesday, December 29, 2004 22:18
To: mccdba1@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: 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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
