Re: it takes a long time to create a database

"Sybrand Bakker" <gooiditweg_at_sybrandb.demon.nl> wrote in message news:ntiq209e70omqrov5f0jma9ig1eipf1a25_at_4ax.com...
> On Fri, 13 Feb 2004 14:26:15 -0600, "Vu Pham" <vu_at_sivell.com> wrote:
>
> >
> >Btw, then if I have two different projects, is it not better to have a
2nd
> >database ?
>
> No. In Oracle multiple applications are stored in multiple schema's. A
> schema is located in a single oracle user.
> So you could have an user called foo with the project foo and an user
> called bar with the project bar.
> Standard SQL security allows you to set up end users so they can only
> see the objects they need.
> As an Oracle database means a separate Oracle instance, and an Oracle
> instance means a new separate shared memory segment, setting up 2
> separate databases for 2 different project usually means wasting
> resources.

Sybrand, thanks for the detailed explanation. Now I understand a little bit more about Oracle.
I also just read the Concepts and a question arises.

I created a user SAMPLE. When I logged to this user and createed a table TABLE1, then the schema SAMPLE was created too. Then if I would like to add another user, say SECOND to create TABLE2 on this SCHEMA. How can I do this ?

I move from MsSql to Oracle then many concepts are confused.

Thanks,

Vu Received on Fri Feb 13 2004 - 17:09:54 CST