Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Creating schema in oracle10g express edition
"Brian Peasland" <dba_at_nospam.peasland.net> schreef in bericht
news:J961tn.GvD_at_igsrsparc2.er.usgs.gov...
>> 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/intro.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?)
>
> --
> ===================================================================
>
> Brian Peasland
> dba_at_nospam.peasland.net
> http://www.peasland.net
>
> Remove the "nospam." from the email address to email me.
>
>
> "I can give it to you cheap, quick, and good.
> Now pick two out of the three" - Unknown
Brian.
You're right! I just wanted to make things a bit more simple. If you can't confuse them, convince them....
Shakespeare Received on Thu Nov 23 2006 - 16:59:37 CST