>Hi Arnon !
>
>The problem is that my application is one from family of applications,
>Each application can be sold separatly and has own set of databases for example.
>Payroll apllication - SYSTEM-OFFICE-PEOPLE
>Accouting application - SYSTEM-OFFICE-ACCOUNTING-PAYMENTS
>Sales application - SYSTEM-OFFICE-SALES-PAYMENTS.
>
>You can see modular structure - if database PEOPLE is changing there is no influence in other databases. So programmers of another application even don't know that something was changed. If it was only one database they will have to update its structure.
>
Hi Jozef,
We modularized our application in pretty much the same way
using different tablespaces (which translate to different actual files on the server) allows you to keep this seperation

Arnon