Multiple (SYSADM) Schemas in a Peoplesoft Database


I believe that Peoplesoft does allow multiple schemas (the default is SYSADM, so the multiples could be SYSADM_1, SYSADM_2 etc) in a single Oracle Database.
This could support seperate business units in one Oracle instance.

Has anyone implemented this in Production ? Particularly for Financials modules -- (GL, Payables, Assets)

(Currently, we do have multiple BUs in the single SYSADM schema but I am asked to explore two options :
a.  Seperate Database Instances
b.  Seperate schemas in one Database Instance )



Hemant K Chitale

http://hemantoracledba.blogspot.com





--
http://www.freelists.org/webpage/oracle-l


Other related posts: