Multiple (SYSADM) Schemas in a Peoplesoft Database

From: Hemant K Chitale <hkchital_at_singnet.com.sg>
Date: Wed, 20 May 2009 22:12:10 +0800
Message-Id: <200905201412.n4KECD5d010488_at_smtp12.singnet.com.sg>

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

Received on Wed May 20 2009 - 09:12:10 CDT

This message: [ Message body ]
Next message: Mayen.Shah_at_lazard.com: "Re: Multiple (SYSADM) Schemas in a Peoplesoft Database"
Previous message: Fuad Arshad: "making sense of commit_preserve_order in a logical standby"
Next in thread: Mayen.Shah_at_lazard.com: "Re: Multiple (SYSADM) Schemas in a Peoplesoft Database"
Reply: Mayen.Shah_at_lazard.com: "Re: Multiple (SYSADM) Schemas in a Peoplesoft Database"
Maybe reply: David Kurtz: "RE: Multiple (SYSADM) Schemas in a Peoplesoft Database"
Maybe reply: Vishal Gupta: "RE: Multiple (SYSADM) Schemas in a Peoplesoft Database"
Maybe reply: Vishal Gupta: "RE: Multiple (SYSADM) Schemas in a Peoplesoft Database"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message