Re: Creating a database is slow on Windows XP

Hans Forbrich <forbrich_at_yahoo.net> wrote in message news:<w%Coc.4114$RM.3429_at_edtnps89>...

Thanks for all replies.

> Dim St Thomas wrote:
>
> > I am a developer working on a database client program. I am testing this
>
> I have a strong suspicion that you might be creating databases where you
> really should be creating schemas.

I think you are right. That's what happens when you are brought up on MS Access. I have looked in the online doc which gives the following definition of a schema:

A named collection of objects, such as tables, views, clusters, procedures, and packages, associated with one or more particular users.

But this seems to be an arbitary collection rather than a "real" database object. In the example schemas, a schema is equivalent to a user. Is this an acceptable model, i.e. create a new user account for each schema?

> With all due respect the way you phrase your question implies you do not
> understand enough of the Oracle internals to program efficiently toward the
> way Oracle implements the database constructs.

Yes, I wouldn't claim to be anything other than an Oracle novice. Thanks for your help (and respect - an unusual thing on usenet!). Received on Fri May 14 2004 - 04:16:13 CEST