Multiple (SYSADM) Schemas in a Peoplesoft Database
- From: Hemant K Chitale <hkchital@xxxxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Wed, 20 May 2009 22:12:10 +0800
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
