Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1s2jLd-005Wcn-AC
	for pgsql-general@arkaria.postgresql.org; Fri, 03 May 2024 03:12:33 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1s2jLa-005ISY-Hd
	for pgsql-general@arkaria.postgresql.org; Fri, 03 May 2024 03:12:31 +0000
Received: from makus.postgresql.org ([2001:4800:3e1:1::229])
	by malur.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <ronljohnsonjr@gmail.com>)
	id 1s2jLa-005ISN-6e
	for pgsql-general@lists.postgresql.org; Fri, 03 May 2024 03:12:31 +0000
Received: from mail-oa1-x2f.google.com ([2001:4860:4864:20::2f])
	by makus.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256
	(Exim 4.94.2)
	(envelope-from <ronljohnsonjr@gmail.com>)
	id 1s2jLY-001B1o-Qc
	for pgsql-general@lists.postgresql.org; Fri, 03 May 2024 03:12:29 +0000
Received: by mail-oa1-x2f.google.com with SMTP id 586e51a60fabf-23d7b0b0a5cso1382236fac.3
        for <pgsql-general@lists.postgresql.org>; Thu, 02 May 2024 20:12:28 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20230601; t=1714705948; x=1715310748; darn=lists.postgresql.org;
        h=to:subject:message-id:date:from:in-reply-to:references:mime-version
         :from:to:cc:subject:date:message-id:reply-to;
        bh=djS2H81gkw0io4Wau3c7ePxQaxTkfT0bNiGq+hqFdbc=;
        b=chOHFRxazwMyNmmol3crN7PmVzT8CiPZkEDue2WoEEDANig0TN1n89Uprcw9HKrqwN
         sO936+cG3dmD+XN0Xz73Yb3D09mXZbgMWtxUvJMY4vMw9YSFM29lQyC8zUvrzBJpcoLG
         DTYyGeNOQEVTiVmjN57HxIlEudzoiMotdjGUUw/e5fau1JXREPhyF9vIAp5BfRYPrEUX
         8jFRgPr4+rrmTb5m6FeiMx8vkn8FI1NsaUibMnO/hPguK0ZTT9VzPURRXwZIvkLVYQ4c
         3R7t/+JUohcvnGp2oif18Xd2TQxuQXgk0DplIKS4X9p4MVEf22HXk7CrrSXxfOwRIexI
         ssmQ==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20230601; t=1714705948; x=1715310748;
        h=to:subject:message-id:date:from:in-reply-to:references:mime-version
         :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to;
        bh=djS2H81gkw0io4Wau3c7ePxQaxTkfT0bNiGq+hqFdbc=;
        b=mSOJXkftbf5bw0xaURKZU7q49e3pEIbx14w7yhznHviDjXaPHUnzxhkvi1foNh7qH0
         h9g9N8HvKN+jwWSMrrNPuvDIr7Lp8qUQQG6eynuULwNM7BREo01RZltDbLLoJFT4qqrl
         Ullal05MudtpcbIpKzLkra0B+n5/MYB0+MKE+ng6C2wwqIxAHMG/sTuhyFdrKOX6TWhB
         Ul8oq5A0hlAusoq0OhWxxaHJ3bjRxbE2yAlXJJG7mC5kScPHz+28p0/WaJr6pDly4Y6C
         xnySsJe/qEq1QHMzP6AM5a0dgYbInb6xOmrTZpwbxIZcVQ1kmsuOqi1HdAqrnwYaxbCT
         vNkg==
X-Gm-Message-State: AOJu0YyurDFsTfGTI++VDIH3LDZI7+9upMbgMl4YY2IP5UTzZ9ezJdbi
	tt4INRoBA5HNuhV93B3Gp3unYHN2EQWqwxSiLi56et6ipdA/rQO1EHoC/NMlW44IOXSdYTT/4F8
	Nomsorg3/7fIMRYkVmC6KQGnXoNLxfQ==
X-Google-Smtp-Source: AGHT+IGT+zlmrCSdA57qmEyqss5xbFHP5TXGOw+xCtYTuezTOzNbI710n1Lz+w+iKvqp6HQ7ctV1NY3/4NwhejNaZ3Y=
X-Received: by 2002:a05:6870:2050:b0:238:fecb:601b with SMTP id
 l16-20020a056870205000b00238fecb601bmr1965157oad.58.1714705948064; Thu, 02
 May 2024 20:12:28 -0700 (PDT)
MIME-Version: 1.0
References: <CAHER7LrDGLmmB6SGiQh7prAJ4pQy7QczoPa2EcJ4zkFTTTZ61A@mail.gmail.com>
In-Reply-To: <CAHER7LrDGLmmB6SGiQh7prAJ4pQy7QczoPa2EcJ4zkFTTTZ61A@mail.gmail.com>
From: Ron Johnson <ronljohnsonjr@gmail.com>
Date: Thu, 2 May 2024 23:12:17 -0400
Message-ID: <CANzqJaCb=aEycqm7hQEUc-NAeNVqDdGAeetTOmG4qWOTx7GgkQ@mail.gmail.com>
Subject: Re: Ora2pg Delta Migration: Oracle to PostgreSQL
To: PostgreSQL General <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000edc42c06178416c4"
List-Id: <pgsql-general.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-general@lists.postgresql.org>
List-Owner: <mailto:pgsql-general-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-general>
Archived-At: <https://www.postgresql.org/message-id/CANzqJaCb%3DaEycqm7hQEUc-NAeNVqDdGAeetTOmG4qWOTx7GgkQ%40mail.gmail.com>
Precedence: bulk

--000000000000edc42c06178416c4
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Thu, May 2, 2024 at 8:28=E2=80=AFPM Amit Sharma <amitpgsql@gmail.com> wr=
ote:

> Hello,
>
> Has anyone tried delta/incremental data migration for Oracle to PostgreSQ=
L
> using Ora2pg? Or what are the best options to run delta migration for
> Oracle to PostgreSQL?
>

What do the ora2pg docs say about whether or not that feature is
implemented?  (It wasn't when I last used it in 2022.)

--000000000000edc42c06178416c4
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr">On Thu, May 2, 2024 at 8:28=E2=80=AFPM Am=
it Sharma &lt;<a href=3D"mailto:amitpgsql@gmail.com">amitpgsql@gmail.com</a=
>&gt; wrote:<br></div><div class=3D"gmail_quote"><blockquote class=3D"gmail=
_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204=
,204);padding-left:1ex"><div dir=3D"ltr">Hello,<div><br></div><div>Has anyo=
ne tried delta/incremental data migration for Oracle to PostgreSQL using Or=
a2pg? Or what are the best options to run delta migration for Oracle to Pos=
tgreSQL?</div></div></blockquote><div><br></div><div>What do the ora2pg doc=
s say about whether or not that feature is implemented?=C2=A0 (It wasn&#39;=
t when I last used it in 2022.)</div><div>=C2=A0<br></div></div></div>

--000000000000edc42c06178416c4--