Re: Creating schema in oracle10g express edition

dops wrote:
> ok, thanx very much for your all reply ;)
> my only difficult is the concept of creating a user to create a
> schema..
> this concept isn't present in sql server or db2 becouse in this
> databases i've to create a "library" or a "database" to create an
> container of all objects (tables etc..)
> In oracle if i've 50 schemas have 50 users.. omitting the fact that a
> single user can be used to connectiong all schemas object through
> permissions settings.. but the fact remains that I must create 50 users
> on the database :(

Well then on the sql server side you have 50 separate databases to manage? Each with it's own set of transaction logs right?

To me anway the oracle side makes more sense.

You don't often create 50 separate schema's in oracle to host the tables for a set of application. Usually you have a couple of schemas and you keep adding additional tables to the important schemas.

An integrated application should keep going after mostly the same tables right? Even applications that are only somewhat related can go after ( not necessarily should but can ) tables in the same schema.

Do you have someone that is designing your applications? Some kind of application architect or senior developer? It might be a good idea to spend some time talking with them. Received on Mon Nov 20 2006 - 13:16:29 CST