RE: PeopleSoft and Logical Standby

From: David Kurtz <>
Date: Wed, 11 Feb 2009 23:06:24 -0000
Message-ID: <2629FB016BF54C278042105F98616FEF_at_GOFASTER4>

If you are using logical standby there is nothing to prevent you updating tables on the target. So I don't see why you couldn't log into that standby via the PIA (although it may not be desirable).


David Kurtz
Go-Faster Consultancy Ltd.
tel: +44 (0)7771 760660
fax: +44 (0)7092 348865
Book: PeopleSoft for the Oracle DBA: <>
DBA Blogs: PeopleSoft: <> , Oracle: <> PeopleSoft DBA Forum:  

From: [] On Behalf Of steve montgomerie
Sent: Wednesday, February 11, 2009 6:21 PM To:
Cc: oracle-l
Subject: Re: PeopleSoft and Logical Standby Importance: High

I'm not sure that you would even be able to login as I believe psoprdefn is update with last login everytime a user logs in.

On Wed, Feb 11, 2009 at 11:40 AM, Li Li <> wrote:

Hi, List,

Has anybody implemented Logical Standby for PeopleSoft database? From oracle documentation, logical standby doesn't support certain data types (collections, user-defined types, etc) and DDLs, I am wondering if this would prevent from implementing logical standby for peoplesoft databases.


-- Received on Wed Feb 11 2009 - 17:06:24 CST

Original text of this message