Return-Path: <oracle-l-bounce@freelists.org>
X-Original-To: oracle-l@orafaq.com
Delivered-To: oracle-l@orafaq.com
Received: from puck1183.startdedicated.com (localhost [127.0.0.1])
 by puck1183.startdedicated.com (Postfix) with ESMTP id 472CC1960291
 for <oracle-l@orafaq.com>; Wed, 26 Feb 2014 17:49:46 +0100 (CET)
Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180])
 by puck1183.startdedicated.com (Postfix) with ESMTP
 for <oracle-l@orafaq.com>; Wed, 26 Feb 2014 17:49:46 +0100 (CET)
Received: from localhost (localhost [127.0.0.1])
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 4116C28485;
 Wed, 26 Feb 2014 11:49:45 -0500 (EST)
X-Virus-Scanned: Debian amavisd-new at turing.freelists.org
Received: from turing.freelists.org ([127.0.0.1])
 by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024)
 with ESMTP id L1S1JeSLs9GI; Wed, 26 Feb 2014 11:49:45 -0500 (EST)
Received: from turing.freelists.org (localhost [127.0.0.1])
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 9606128437;
 Wed, 26 Feb 2014 11:49:03 -0500 (EST)
Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 26 Feb 2014 11:48:22 -0500 (EST)
Received: from localhost (localhost [127.0.0.1])
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 280E1282EF
 for <oracle-l@freelists.org>; Wed, 26 Feb 2014 11:48:22 -0500 (EST)
Received: from turing.freelists.org ([127.0.0.1])
 by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024)
 with ESMTP id q1EBxThtEwAm for <oracle-l@freelists.org>;
 Wed, 26 Feb 2014 11:48:22 -0500 (EST)
Received: from mail-we0-f181.google.com (mail-we0-f181.google.com [74.125.82.181])
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id A6C2B2826F
 for <oracle-l@freelists.org>; Wed, 26 Feb 2014 11:48:21 -0500 (EST)
Received: by mail-we0-f181.google.com with SMTP id q58so493999wes.12
        for <oracle-l@freelists.org>; Wed, 26 Feb 2014 08:48:20 -0800 (PST)
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20130820;
        h=x-gm-message-state:reply-to:from:to:cc:references:in-reply-to
         :subject:date:organization:message-id:mime-version:content-type
         :thread-index:content-language;
        bh=K9mmBeiUn8OhbXF20wowumHCmlPZrXLZoZ6j1+eRQz8=;
        b=au2TQ2M44OHpAsQvNPPiOoJnnyMPreu7D2ZwTlwGM1HcK9qi9IF6TpJI0Llqrn4345
         Y6kQbxst4YbLK4E9m/Vl2lRLUqhS3bGq1XpX1k28QAK4hBcfFaxD/xDMK1u78bhUXiId
         JHCwcACqXptMbOcKpp52TxrlKwEvqQJkFkTCEiSOY+WlZwCxW8KmhMmiXbsBojQBeMkf
         jxtsrLwAZGWiIMR43C+LMU9HOrH+t7MvTdpkks+6tAixgnCaD1MlTBm9Ni9y8iMIoagw
         lt2IcrqvYO9gMabyXkkwEOYYOGBWXeDI4VySZEazNmHB69p/rKgjtf8qfgeYe4mFt0E6
         qRSg==
X-Gm-Message-State: ALoCoQlCyYCDgmYJyZyjRh/B3l8BtO+6O2kQVbcAfYA0qzDs9sCvbmCrtusJZBMbHxAhOk5Pb0Rd
X-Received: by 10.194.78.16 with SMTP id x16mr1100089wjw.86.1393433300362;
        Wed, 26 Feb 2014 08:48:20 -0800 (PST)
Received: from gofaster6 ([91.208.239.222])
        by mx.google.com with ESMTPSA id fo6sm6978390wib.7.2014.02.26.08.48.19
        for <multiple recipients>
        (version=TLSv1 cipher=ECDHE-RSA-AES128-SHA bits=128/128);
        Wed, 26 Feb 2014 08:48:19 -0800 (PST)
From: "David Kurtz" <info@go-faster.co.uk>
To: <exriscer@gmail.com>,
 "'Mohan'" <moganconsulting@msn.com>
Cc: "'Hemant-K.Chitale@sc.com'" <hemant-k.chitale@sc.com>,
 <oracle-l@freelists.org>
References: <0BDF2A25A09ADD40908745EEFC0A0FB60176B099@HKJUMXMB103B.zone1.scb.net>	<CAJ2-Qb8kdBe=UCwBX5VZbrMBbrD+rEn3euB=4EPqW+regG4YkA@mail.gmail.com>	<BLU168-W11138C10E6761366CAFA7D2B3800@phx.gbl> <CAJ2-Qb_KYjp-Ln8_JfnA5rOWDa-FXMcq3kjhU6DkwVST-PXMMA@mail.gmail.com>
In-Reply-To: <CAJ2-Qb_KYjp-Ln8_JfnA5rOWDa-FXMcq3kjhU6DkwVST-PXMMA@mail.gmail.com>
Subject: RE: Golden Gate or Logical Standby for Peoplesoft
Date: Wed, 26 Feb 2014 16:48:15 -0000
Organization: Go-Faster Consultancy Ltd.
Message-ID: <00ae01cf3312$8ba26f60$a2e74e20$@go-faster.co.uk>
MIME-Version: 1.0
Content-Type: multipart/alternative;
 boundary="----=_NextPart_000_00AF_01CF3312.8BA3F600"
Content-Language: en-gb
X-archive-position: 53121
X-ecartis-version: Ecartis v1.0.0
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
X-original-sender: info@go-faster.co.uk
Precedence: normal
Reply-To: info@go-faster.co.uk
List-help: <mailto:ecartis@freelists.org?Subject=help>
List-unsubscribe: <oracle-l-request@freelists.org?Subject=unsubscribe>
List-software: Ecartis version 1.0.0
List-Id: oracle-l <oracle-l.freelists.org>
X-List-ID: oracle-l <oracle-l.freelists.org>
List-subscribe: <oracle-l-request@freelists.org?Subject=subscribe>
List-owner: <mailto:mark.bobak@proquest.com>
List-post: <mailto:oracle-l@freelists.org>
List-archive: <http://www.freelists.org/archives/oracle-l>
X-list: oracle-l
------=_NextPart_000_00AF_01CF3312.8BA3F600
Content-Type: text/plain;
 charset="us-ascii"
Content-Transfer-Encoding: 7bit

PeopleSoft has unique key indexes.  Most of the columns are not null, and
providing you don't have a descending column in the unique index, you could
create a primary key using the unique key.  

You could also set _IGNORE_DESC_IN_INDEXES and rebuild the unique indexes
with descending columns.  Then you could create primary keys for all tables
with unique keys.

 

PeopleTools has its own data dictionary from which you can obtain all this
information.  

 

regards
_________________________
David Kurtz
tel: +44 (0)7771 760660
mailto:david.kurtz@go-faster.co.uk



 

 

From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org]
On Behalf Of Ls Cheng
Sent: 26 February 2014 15:31
To: Mohan
Cc: Hemant-K.Chitale@sc.com; oracle-l@freelists.org
Subject: Re: Golden Gate or Logical Standby for Peoplesoft
Importance: High

 

yea but if the application ensure integrity then keycols are not requiered,
in fact that would slow down the migration process since you have to involve
people from peoplesoft to tell you which columns can be used as potentil
keycols candidates

 

On Wed, Feb 26, 2014 at 4:24 PM, Mohan <moganconsulting@msn.com> wrote:

Hi
 
GoldenGate  has constructs to simulate the existence of a PK or UK via the
use of "KEYCOLS" during replication setup phase.

Mohan moganconsulting@msn.com 732-742-0640
 

  _____  

Date: Wed, 26 Feb 2014 10:53:53 +0100
Subject: Re: Golden Gate or Logical Standby for Peoplesoft
From: exriscer@gmail.com
To: Hemant-K.Chitale@sc.com
CC: oracle-l@freelists.org

 

Hi

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@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

 

 

 


------=_NextPart_000_00AF_01CF3312.8BA3F600
Content-Type: text/html;
 charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<html xmlns:v=3D"urn:schemas-microsoft-com:vml" =
xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml" =
xmlns=3D"http://www.w3.org/TR/REC-html40"><head><META =
HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Dus-ascii"><meta name=3DGenerator content=3D"Microsoft Word 14 =
(filtered medium)"><!--[if !mso]><style>v\:* =
{behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
	{font-family:Calibri;
	panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
	{font-family:Tahoma;
	panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
	{margin:0cm;
	margin-bottom:.0001pt;
	font-size:12.0pt;
	font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
	{mso-style-priority:99;
	color:blue;
	text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
	{mso-style-priority:99;
	color:purple;
	text-decoration:underline;}
p
	{mso-style-priority:99;
	mso-margin-top-alt:auto;
	margin-right:0cm;
	mso-margin-bottom-alt:auto;
	margin-left:0cm;
	font-size:12.0pt;
	font-family:"Times New Roman","serif";}
span.EmailStyle18
	{mso-style-type:personal-reply;
	font-family:"Calibri","sans-serif";
	color:#1F497D;}
.MsoChpDefault
	{mso-style-type:export-only;
	font-family:"Calibri","sans-serif";
	mso-fareast-language:EN-US;}
@page WordSection1
	{size:612.0pt 792.0pt;
	margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
	{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext=3D"edit">
<o:idmap v:ext=3D"edit" data=3D"1" />
</o:shapelayout></xml><![endif]--></head><body lang=3DEN-GB link=3Dblue =
vlink=3Dpurple><div class=3DWordSection1><p class=3DMsoNormal><span =
style=3D'font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497=
D'>PeopleSoft has unique key indexes.&nbsp; Most of the columns are not =
null, and providing you don&#8217;t have a descending column in the =
unique index, you could create a primary key using the unique key.&nbsp; =
<o:p></o:p></span></p><p class=3DMsoNormal><span =
style=3D'font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497=
D'>You could also set _IGNORE_DESC_IN_INDEXES and rebuild the unique =
indexes with descending columns.&nbsp; Then you could create primary =
keys for all tables with unique keys.<o:p></o:p></span></p><p =
class=3DMsoNormal><span =
style=3D'font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497=
D'><o:p>&nbsp;</o:p></span></p><p class=3DMsoNormal><span =
style=3D'font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497=
D'>PeopleTools has its own data dictionary from which you can obtain all =
this information.&nbsp; <o:p></o:p></span></p><p class=3DMsoNormal><span =
style=3D'font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497=
D'><o:p>&nbsp;</o:p></span></p><p class=3DMsoNormal =
style=3D'mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span =
lang=3DEN-US =
style=3D'font-size:10.0pt;color:#1F497D'>regards<br>_____________________=
____<br>David Kurtz<br>tel: +44 (0)7771 760660<br><a =
href=3D"mailto:david.kurtz@go-faster.co.uk">mailto:david.kurtz@go-faster.=
co.uk</a><br><br></span><span lang=3DEN-US =
style=3D'color:#1F497D'><o:p></o:p></span></p><p class=3DMsoNormal><span =
style=3D'font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497=
D'><o:p>&nbsp;</o:p></span></p><p class=3DMsoNormal><span =
style=3D'font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497=
D'><o:p>&nbsp;</o:p></span></p><p class=3DMsoNormal><b><span =
lang=3DEN-US =
style=3D'font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span>=
</b><span lang=3DEN-US =
style=3D'font-size:10.0pt;font-family:"Tahoma","sans-serif"'> =
oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] =
<b>On Behalf Of </b>Ls Cheng<br><b>Sent:</b> 26 February 2014 =
15:31<br><b>To:</b> Mohan<br><b>Cc:</b> Hemant-K.Chitale@sc.com; =
oracle-l@freelists.org<br><b>Subject:</b> Re: Golden Gate or Logical =
Standby for Peoplesoft<br><b>Importance:</b> =
High<o:p></o:p></span></p><p =
class=3DMsoNormal><o:p>&nbsp;</o:p></p><div><p class=3DMsoNormal>yea but =
if the application ensure integrity then keycols are not requiered, in =
fact that would slow down the migration process since you have to =
involve people from peoplesoft to tell you which columns can be used as =
potentil keycols candidates<o:p></o:p></p></div><div><p =
class=3DMsoNormal =
style=3D'margin-bottom:12.0pt'><o:p>&nbsp;</o:p></p><div><p =
class=3DMsoNormal>On Wed, Feb 26, 2014 at 4:24 PM, Mohan &lt;<a =
href=3D"mailto:moganconsulting@msn.com" =
target=3D"_blank">moganconsulting@msn.com</a>&gt; =
wrote:<o:p></o:p></p><div><div><p =
class=3DMsoNormal>Hi<br>&nbsp;<br>GoldenGate &nbsp;has constructs to =
simulate the existence of a PK or UK via the use of &quot;KEYCOLS&quot; =
during replication setup phase.<br><br>Mohan <a =
href=3D"mailto:moganconsulting@msn.com" =
target=3D"_blank">moganconsulting@msn.com</a> <a =
href=3D"tel:732-742-0640" =
target=3D"_blank">732-742-0640</a><br>&nbsp;<o:p></o:p></p><div><div =
class=3DMsoNormal align=3Dcenter style=3D'text-align:center'><hr =
size=3D2 width=3D"100%" align=3Dcenter></div><p class=3DMsoNormal>Date: =
Wed, 26 Feb 2014 10:53:53 +0100<br>Subject: Re: Golden Gate or Logical =
Standby for Peoplesoft<br>From: <a href=3D"mailto:exriscer@gmail.com" =
target=3D"_blank">exriscer@gmail.com</a><br>To: <a =
href=3D"mailto:Hemant-K.Chitale@sc.com" =
target=3D"_blank">Hemant-K.Chitale@sc.com</a><br>CC: <a =
href=3D"mailto:oracle-l@freelists.org" =
target=3D"_blank">oracle-l@freelists.org</a><o:p></o:p></p><div><div><p =
class=3DMsoNormal =
style=3D'margin-bottom:12.0pt'><o:p>&nbsp;</o:p></p><div><div><div><div><=
p class=3DMsoNormal =
style=3D'margin-bottom:12.0pt'>Hi<o:p></o:p></p></div><p =
class=3DMsoNormal style=3D'margin-bottom:12.0pt'>I dont have exp with =
Logical Standby but have use GoldenGate for several =
migrations.<o:p></o:p></p></div><p class=3DMsoNormal =
style=3D'margin-bottom:12.0pt'>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<br><br><o:p></o:p></p></div><p class=3DMsoNormal =
style=3D'margin-bottom:12.0pt'>Regards<br><br><o:p></o:p></p><div><p =
class=3DMsoNormal><o:p>&nbsp;</o:p></p><div><p class=3DMsoNormal =
style=3D'margin-bottom:12.0pt'><o:p>&nbsp;</o:p></p><div><p =
class=3DMsoNormal>On Wed, Feb 26, 2014 at 4:05 AM, Chitale, Hemant K =
&lt;<a href=3D"mailto:Hemant-K.Chitale@sc.com" =
target=3D"_blank">Hemant-K.Chitale@sc.com</a>&gt; =
wrote:<o:p></o:p></p><div><p><span =
style=3D'font-family:"Calibri","sans-serif"'>Has anyone done GoldenGate =
or Logical Standby setup for an *<b>entire</b>* Peoplesoft (Financials) =
Schema ?&nbsp;</span> <o:p></o:p></p><p><span =
style=3D'font-family:"Calibri","sans-serif"'>Peoplesoft doesn&#8217;t =
have PK and FK definitions and Referential Integrity =
constraints.&nbsp;</span>&nbsp;<span =
style=3D'font-family:"Calibri","sans-serif"'> Would GG / LS be doable =
?</span><o:p></o:p></p><p><span lang=3DEN-US =
style=3D'font-family:"Calibri","sans-serif"'>Hemant K =
Chitale</span><o:p></o:p></p><p =
class=3DMsoNormal><o:p>&nbsp;</o:p></p></div></div><p =
class=3DMsoNormal><o:p>&nbsp;</o:p></p></div></div></div></div></div></di=
v></div></div></div><p =
class=3DMsoNormal><o:p>&nbsp;</o:p></p></div></div></body></html>
------=_NextPart_000_00AF_01CF3312.8BA3F600--

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