Hi Guys,

Is it possible to have multiple schemes in a database ? :confused:
From the session ttdba0520m000, it appears that multiple groups (schemes) are possible.

If we create a new schema baan1, baan2... with multiple companies. How does BaaN identify the mapping for a company belonging to a different schema in the same database.

Your ideas are welcome and appreciated.

Thanks

~NP

Its based off of the user. Each user can belong 1 and only 1 group
so in the ora_users file you'll see

id1:dbid:<password>:group
id2:dbid2:<password>:group2

So if you have company 100 in the "group" schema
then all users that need to access company 100
have to be in "group"

Baan will create the tables based on the user you are creating them as. So in unix you could do like
USER=group2user bdbpost6.2 ...
to add tables to that 2nd group.

Thanks for the info Dave...

The background for my Q was we noticed a lot of performance degradation when we created 4-6 companies (each with 5000 tables) in Oracle-8.1.7.2. I am not sure how the behaviour is in Oracle-9i. So we create 4-6 companies per database and then move the next set of companies into another database instance.

So I was exploring options if we can create a new schema in the same database and then create the companies there so that we dont need to get a new database instance.

Did you ever implement this kind of setup ?

One more question - if I create 2 database groups for a database how can I specify which scheme has to be used for a company to be created ?

I referred to some of the manuals/documentations which do not have any information about this.

I have implemented it, the only real downsides are the lack of flexability that you have in that setup. For example
you cannot take one environment down to work on it while another one is up...

Remeber the schema isn't associated to a company, its associated to a user. So for example "bsp" would be assigned to baangroup1 while maybe bsp2 would be baangroup2.

They cannot cross over, so to create tables in the 2nd schema, you would have to use a "baangroup2" user...

Hope that helps!

Dave

NPrao,

The background for my Q was we noticed a lot of performance degradation when we created 4-6 companies (each with 5000 tables) in Oracle-8.1.7.2. I am not sure how the behaviour is in Oracle-9i. So we create 4-6 companies per database and then move the next set of companies into another database instance.

Did this help solving your performance problem?

Rgrds,
Han