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 ) id 1tcOqf-00HNCq-JV for pgsql-admin@arkaria.postgresql.org; Mon, 27 Jan 2025 13:08:18 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tcOqd-00CJ1T-9G for pgsql-admin@arkaria.postgresql.org; Mon, 27 Jan 2025 13:08:15 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tcOqc-00CJ1L-Rx for pgsql-admin@lists.postgresql.org; Mon, 27 Jan 2025 13:08:14 +0000 Received: from mail-oi1-x22d.google.com ([2607:f8b0:4864:20::22d]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1tcOqY-001mql-2H for pgsql-admin@lists.postgresql.org; Mon, 27 Jan 2025 13:08:13 +0000 Received: by mail-oi1-x22d.google.com with SMTP id 5614622812f47-3ebbe804913so1113782b6e.0 for ; Mon, 27 Jan 2025 05:08:10 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=enterprisedb.com; s=google; t=1737983288; x=1738588088; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=mtyxTvX+lZkCK5oijtKWv+OeP7KMicwZiQJkrxCsztc=; b=IKnM46tlupN+fqeCyKGf/8FmLfR0cj7mbVIcjVjVr1MSJQT3yNrCm6AXcsJO6psUux KSlVnoG/1HDx3KvIJngnm1AtFh82IgKHVd9A5Wx9lgBNBAX6nmVUKitWAmUS4IQ2+Z0M OuEMG2Yf31xgf2SP7CqVFj9n5IFVCcVNOFYLNdBSCE3XMIpdKexXCLf8ap+iJXBYKydv 7T6W7kGF7OVq+rbGDutQS64623NRzX8TMVaBH37wUIpfT0iHshrtokMojAfjFcC7oJ2h Nm0mu6pV07V2vDwzrpXxlzYOiyM0ITLYTWThmJirPw5yQ3eQhUJ91qHNmhb8pjfUzqAW SVpw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1737983288; x=1738588088; h=cc: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=mtyxTvX+lZkCK5oijtKWv+OeP7KMicwZiQJkrxCsztc=; b=A9I/T2rxl4HBEVm/dWQIsh+/YXPwaKz70FVvbVyl9lcp0u6CoClALR2eiwDEsNtbBV WcJBuzTvxkdCt1Mz9MHAqS80gNVM3qdOPr+IjIETzSrki7MfeoANXwmBoxlhpCLkaX6C 0J9/4W5pah+ma5j6bKAMvrMtR0thla5xZmTZEuX1FOnWdok14BBZxRacKCG2KEIO3brE 0M+vu6kpkYo4OU1yb1Wwe3sO7YMkssfUeLaJWBtL2sE6MqM6W14+0nwWF7QX36K2HMpl +McOrdpr24BC7WUENyteTpqo4rLm8Q7C//2XEUFPl6YeqWstM7Cvclx0/FWCeLiA7BfJ tDHw== X-Forwarded-Encrypted: i=1; AJvYcCWumV+tFCW2yJc7B1cK0R0j9oCS9PdDMwhYFZLFQZ+eqbEuQujZcZmbVbSreDyg/hlbuBMMtLtwHk3n4w==@lists.postgresql.org X-Gm-Message-State: AOJu0Yx+NcTIZlPGINLRUpDe82dCHSQXU0dmucXBvKAcl/rbmJQqFGH5 ZQVbhcKR+zD2ixwzJBWMuuYd2YwPofnKHfWTR4seOATk3b3LyoPSs//TJ/1EKarfgHOH8AbtjIx kfKvTeFG9BUxApUFZfOGmudtuitsQZY/tE8QT X-Gm-Gg: ASbGncvxCpTP3wtIeSi/Qt+gHwC9UYJim8n/yzAS19Dc4f2QXqL92MhZOHHdMn1sdEd FZF2btbiLAH850WAOlMuaearzno512bhX4L8e9SxMKqFhiDAivlZEKUiIWg04LTuzISKEekUHTS iDOXFymg3iCdXrq5i3BA== X-Google-Smtp-Source: AGHT+IFwML7HZ/Hn3rr6tZx2RrKL5gulK7iy76vwEWAUbHrw0L6lkz/7DfMkblEBk3coBIS72+veiuCxeGcsf90DeHA= X-Received: by 2002:a05:6808:338a:b0:3f1:cd31:59ca with SMTP id 5614622812f47-3f1cd315b0emr17225189b6e.11.1737983287655; Mon, 27 Jan 2025 05:08:07 -0800 (PST) MIME-Version: 1.0 References: In-Reply-To: From: =?UTF-8?Q?Raphael_Salguero_Arag=C3=B3n?= Date: Mon, 27 Jan 2025 14:07:57 +0100 X-Gm-Features: AWEUYZlvkPklCrWFzabQ-x6vXldtu-wr4A6tIf_hHCzqYfcH9TbrOqXmxIECQ1g Message-ID: Subject: Re: Oracle to postgres migration To: Rajesh Kumar Cc: Ron Johnson , Pgsql-admin Content-Type: multipart/alternative; boundary="0000000000007c97e1062cafc423" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000007c97e1062cafc423 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Hi Rajesh Rajesh Kumar schrieb am Mo. 27. Jan. 2025 um 11:13: > With regards to lo, is there any difficulty if we have rowsize > 1gb > For most cases, I would recommend to migrate lobs > 1gb into pg_largeobjects. The way of accessing those lobs will change (also for the application) This could be done with a bit of python scripting. I=E2=80=99m not sure if = there is a option within ora2pg meanwhile. Regarding the sizes in general, you can check out below article: https://www.enterprisedb.com/postgres-tutorials/postgresql-toast-and-workin= g-blobsclobs-explained Best regards Raphael > On Mon, 27 Jan 2025, 15:41 Rajesh Kumar, > wrote: > >> Thank you all. As mush as more info is always appreciated by dearest >> admins >> >> On Mon, 27 Jan 2025, 15:40 Ron Johnson, wrote: >> >>> I migrated a 12TB Oracle db that was mostly LOB objects into an 8TB PG >>> database. LOBs loaded into bytea columns. >>> One thing which I did not do, but should have, was have ora2pg convert >>> NUMBER(38,0) values to BIGINT. >>> >>> We just used ora2pg to convert data; the app developer rewrote all of >>> the stored procedures, functions, triggers, etc. >>> >>> On Mon, Jan 27, 2025 at 4:31=E2=80=AFAM Rajesh Kumar < >>> rajeshkumar.dba09@gmail.com> wrote: >>> >>>> Size is 300gb, have lob objects. I prefer ora2pg. Does EDB MTK costs? >>>> >>>> Mostly I need to know what are all the things I need to ask oracle >>>> people to start withj >>>> >>>> On Mon, 27 Jan 2025, 14:52 Julien Rouhaud, wrote: >>>> >>>>> Hi, >>>>> >>>>> On Mon, Jan 27, 2025 at 02:42:22PM +0530, Rajesh Kumar wrote: >>>>> > Hi team, >>>>> > >>>>> > I am trying to migrate from oracle to postgres. >>>>> > >>>>> > I have been asked to provide an estimation for effort days. Anybody >>>>> has any >>>>> > document related to estimation? And steps. >>>>> > >>>>> > Where do I start with? Anybody has any documentation related to >>>>> ora2pg >>>>> > migration ? >>>>> >>>>> ora2pg is probably the best tool for your task. And yes it does >>>>> provide >>>>> estimates for the migration efforts, see >>>>> https://ora2pg.darold.net/documentation.html#Migration-cost-assessmen= t >>>>> . >>>>> >>>>> In general the ora2pg documentation is really good, you should find >>>>> the answer >>>>> to all your questions there. >>>>> >>>> >>> >>> -- >>> Death to , and butter sauce. >>> Don't boil me, I'm still alive. >>> lobster! >>> >> --0000000000007c97e1062cafc423 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi Rajesh

Rajesh Kumar <rajeshkumar.dba09@gmail.com&= gt; schrieb am Mo. 27. Jan. 2025 um 11:13:

With regards to lo, is there any difficulty if we have rowsize >= ; 1gb

For most cases, I would recommend to migrate= lobs > 1gb into pg_largeobjects. The way of accessing those lobs will c= hange (also for the application)
This could be done = with a bit of python scripting. I=E2=80=99m not sure if there is a option w= ithin ora2pg meanwhile.

= Regarding the sizes in general, you can check out below article:=C2=A0

Best regards
R= aphael=C2=A0


On Mon, 27 J= an 2025, 15:41 Rajesh Kumar, <rajeshkumar.dba09@gmail.com> wrote:
=

Thank you all. As mush as more info is alwa= ys appreciated by dearest admins


On Mon= , 27 Jan 2025, 15:40 Ron Johnson, <ronljohnsonjr@gmail.com> = wrote:
I migrated a 12TB Or= acle db that was mostly LOB objects into an 8TB PG database.=C2=A0 LOBs loa= ded into bytea columns.
One thing which I did not do, but should = have, was have ora2pg convert NUMBER(38,0) values to BIGINT.

=
We just used ora2pg to convert data; the app developer rewrote a= ll of the stored procedures, functions, triggers, etc.

On Mon, Jan 27, 2025 at 4:31=E2=80=AFAM Rajesh Kumar <rajeshkumar.dba09@gmail.com> wrote:
=

Size is 300gb, have lob objects. I prefer ora2pg. Does EDB M= TK costs?

Mostly I need to know what are all the things I need to ask = oracle people to start withj


On Mon= , 27 Jan 2025, 14:52 Julien Rouhaud, <rjuju123@gmail.com&= gt; wrote:
Hi,

On Mon, Jan 27, 2025 at 02:42:22PM +0530, Rajesh Kumar wrote:
> Hi team,
>
> I am trying to migrate from oracle to postgres.
>
> I have been asked to provide an estimation for effort days. Anybody ha= s any
> document related to estimation? And steps.
>
> Where do I start with? Anybody has any documentation related to ora2pg=
> migration ?

ora2pg is probably the best tool for your task.=C2=A0 And yes it does provi= de
estimates for the migration efforts, see
https://ora2pg.darold.net/documentation.html#Migration-cost-assessment.

In general the ora2pg documentation is really good, you should find the ans= wer
to all your questions there.


--
Death to <Redacted>, and butter sauce.Don't boil me, I'm still alive.
<Redacted> lobs= ter!
--0000000000007c97e1062cafc423--