muti schema for multi project db

Hello,

  We are currently in transition from Data General MV platforms to OPEN SYSTEMS.   Almost all the databases were transformed to oracle.   However we are heading the Application transition together with new   projects.
  This means that DB structure will be different at times for different   developement teams (depends on their project).   I am trying to implement a multi-schema environment.   I am spliting the env. between databases according to those factors:

• availability (some processes require DB online for days)
• backup method (some require daily backup and others weekly)
• processes (some projects handle just transformation:heavy loads of data and some just online dev. and test.)

  However using multi schema requires setup:

• scripts to manouver user (via project setup) to the right schema
• use synonyms carefully
• dba scripts can't just run in the multischema DB as they run in production (where as only one schema exists)

  It would help alot if you can give me some more tips and issues i must   take into count if i sould use multi-schema.   Also if you have other ideas as to how to implement multi-project env.   (USE MANY DB's-i expect about 15 if using multi-db instead of multi-schema)   please let me know.

  I am not happy about multi-db cause i think it will overload the cpu and   cause management overhead.

  Thanks for your help,

        Jack.

Jack Bezalel,
Database and Systems Integration Dept. Mgr., MIS Dept.
PHOENIX Company L.T.D.
ISRAEL

                    May The CURSOR Be With You . . .

------------------------------------------------------------