Re: it takes a long time to create a database

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 Bakker, Senior Oracle DBA