Re: Golden Gate or Logical Standby for Peoplesoft

From: Ls Cheng <exriscer_at_gmail.com>
Date: Wed, 26 Feb 2014 10:53:53 +0100
Message-ID: <CAJ2-Qb8kdBe=UCwBX5VZbrMBbrD+rEn3euB=4EPqW+regG4YkA_at_mail.gmail.com>

I dont have exp with Logical Standby but have use GoldenGate for several migrations.

GoldenGate can handle tables with no PK or FK, not recommendable but it works, what it does is it uses all columns as PK when there is no PK defined. As long as the application handles correctly referential integrity GoldenGate is ok

Regards

On Wed, Feb 26, 2014 at 4:05 AM, Chitale, Hemant K <Hemant-K.Chitale_at_sc.com>wrote:

> Has anyone done GoldenGate or Logical Standby setup for an **entire**
> Peoplesoft (Financials) Schema ?
>
> Peoplesoft doesn't have PK and FK definitions and Referential Integrity
> constraints. Would GG / LS be doable ?
>
> Hemant K Chitale
>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Feb 26 2014 - 10:53:53 CET

This message: [ Message body ]
Next message: Ram Srinivasan: "Re: Database Change Control Process"
Previous message: Johan Eriksson: "Re: How do Oracle DBA's look or behave like when they reach their golden years?"
In reply to: Chitale, Hemant K: "Golden Gate or Logical Standby for Peoplesoft"
Next in thread: Ls Cheng: "Re: Golden Gate or Logical Standby for Peoplesoft"

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

Original text of this message