RE: Multiple (SYSADM) Schemas in a Peoplesoft Database
- From: "Sais, Gene" <Gsais@xxxxxxxxxxxxxxxxxxxx>
- To: "'hkchital@xxxxxxxxxxxxxx'" <hkchital@xxxxxxxxxxxxxx>, "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 20 May 2009 10:29:55 -0400
If I were going to separate it out, I would create a new PPS DB with it's own
SYSADM schema. What's one more db in PPS (PeopleSoft)? The PPS product
requires more databases than any other product, even SAP.
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Hemant K Chitale
Sent: Wednesday, May 20, 2009 10:12 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: 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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
