My rule of thumb is -
If it's got different entities then it's a different database.
If it shares some entitites then it's a different schema, with it's own
entities separate from the base schema.
If it uses the same database objects and the same data then it's a user
with no objects of its own and a role that gives it the required privileges
on the database.
I've never had problems with multiple databases on the same server, even
with different versions of Oracle. You just need to have it perfectly clear
who is in charge of allocating shared resources.
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Oct 07 2005 - 08:22:37 CDT
