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 -- http://www.freelists.org/webpage/oracle-l
- Follow-Ups:
- RE: Multiple (SYSADM) Schemas in a Peoplesoft Database
- From: Sais, Gene
- Re: Multiple (SYSADM) Schemas in a Peoplesoft Database
- From: Mayen . Shah
- Re: Multiple (SYSADM) Schemas in a Peoplesoft Database
- From: Karl Arao
- RE: Multiple (SYSADM) Schemas in a Peoplesoft Database
Other related posts:
- » Multiple (SYSADM) Schemas in a Peoplesoft Database - Hemant K Chitale
- » RE: Multiple (SYSADM) Schemas in a Peoplesoft Database - Sais, Gene
- » Re: Multiple (SYSADM) Schemas in a Peoplesoft Database - Mayen . Shah
- » Re: Multiple (SYSADM) Schemas in a Peoplesoft Database - Karl Arao
- » RE: Multiple (SYSADM) Schemas in a Peoplesoft Database - David Kurtz
- » RE: Multiple (SYSADM) Schemas in a Peoplesoft Database - John Hallas
- » RE: Multiple (SYSADM) Schemas in a Peoplesoft Database - David Kurtz
- » Re: Multiple (SYSADM) Schemas in a Peoplesoft Database - Nuno Souto
- » RE: Multiple (SYSADM) Schemas in a Peoplesoft Database - Vishal Gupta
- » RE: Multiple (SYSADM) Schemas in a Peoplesoft Database - Vishal Gupta
- » Re: Multiple (SYSADM) Schemas in a Peoplesoft Database - steve montgomerie
- » Re: Multiple (SYSADM) Schemas in a Peoplesoft Database - Nuno Souto