Re: Creating schema in oracle10g express edition

thanx for your reply.. my english is not very good, maybe this is the problem :)
reading documentation i understand that oracle call the "database" as "schema" (it's right?)
well, if it's right, how i can create a new schema associated with exiting user? i don't see any menu item "create new schema" maybe this is a limitation of express version of oracle? for example (if u know the express version), the express version of oracle have a default user named "HR", how i can create a new database (with tables and related objects) associated with this user? But if i want create a database not associated with a specific user, i can?
Thanx again ;)

hpuxrac ha scritto:

> dops wrote:
> > hi all,
> > i'm new to oracle (and excuse my english), i've downloaded the free
> > version of oracle 10g (express edition), i don't understand logical
> > process to creating a database.. i undertsand that the "schema" element
> > is "the database" of sql server, but why i've to create a new user for
> > a new database?
>
> You don't necessarily have to create new users, it's optional.
>
> Normally in oracle you create a "few" schema owners that are associated
> with tables, procedures, views etc.
>
> Other oracle users are granted access against the tables that are owned
> by the schema owners. Do this through roles to have a maintainable
> system.
>
> > i can't have in oracle an user owner more databases?
>
> What? Sorry I don't understand what you are trying to ask here.
>
> Users don't own databases. A database can have multiple owners within
> it that have tables etc.
>
> > Another question: what is the differcence from oracle enterprice
> > version and express version? only the max limitation of free space to
> > create databases objects?
>
> Lots of other options. There's an oracle licensing paper that
> discusses this subject in detail. Or you can search this newsgroup
> there's been lots of prior discussions in this area.
>
> > thanx for your reply..
>
> Have fun. You might want to start learning more about oracle by going
> through the concepts manual, that would probably clear up a lot of your
> questions.
>
> You can find the oracle documentation at http://tahiti.oracle.com
Received on Sun Nov 19 2006 - 16:01:13 CST