Re: Creating schema in oracle10g express edition

In message <1164409397.904974_at_bubbleator.drizzle.com>, DA Morgan <damorgan_at_psoug.org> writes
>Brian Peasland wrote:
>>> Dops:
>>> just consider a schema as a user with the objects he owns... So a
>>>schema is just a user who is owner of some objects.
>> The Oracle docs are a wonderful thing....
>>
>>http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14220/int
>>ro.htm#sthref69 As stated, "A schema is a collection of database
>>objects. A schema is owned by a database user and has the same name
>>as that user."
>> However, a user by itself is not a schema. Using the definition
>>above, the schema is the collection of object. A schema is not a
>>user. The schema is owned by some user. So saying that a schema is a
>>user with the object he owns is not entirely accurate. What if the
>>user owns no objects? Is that a schema? Not according to Oracle's definition.
>> Cheers,
>> Brian
>> (what's in a user?)
>
>Oracle has two different DDL statements:
>
>"CREATE USER" and "CREATE SCHEMA"
>
>What each does clearly defines the meaning of the terms.

That's rather disingenuous of you. The create schema statement is included for ANSI compatibility and is all but useless because it restricts you to tables, views and grants and only the ANSI standard versions of those.

Have you ever used create schema in a real database?

-- 
Jim Smith
Ponder Stibbons Limited <http://oracleandting.blogspot.com/>
RSS <http://oracleandting.blogspot.com/atom.xml>