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-admin-owner+archive@lists.postgresql.org>)
	id 1tcLKL-00GzYp-1Z
	for pgsql-admin@arkaria.postgresql.org; Mon, 27 Jan 2025 09:22:41 +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-admin-owner+archive@lists.postgresql.org>)
	id 1tcLKK-00Ai5k-6M
	for pgsql-admin@arkaria.postgresql.org; Mon, 27 Jan 2025 09:22:40 +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 <rjuju123@gmail.com>)
	id 1tcLKJ-00Ai4P-RX
	for pgsql-admin@lists.postgresql.org; Mon, 27 Jan 2025 09:22:39 +0000
Received: from mail-pl1-x62c.google.com ([2607:f8b0:4864:20::62c])
	by makus.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256
	(Exim 4.96)
	(envelope-from <rjuju123@gmail.com>)
	id 1tcLKH-001jhk-2L
	for pgsql-admin@lists.postgresql.org;
	Mon, 27 Jan 2025 09:22:38 +0000
Received: by mail-pl1-x62c.google.com with SMTP id
 d9443c01a7336-21644aca3a0so96551845ad.3
        for <pgsql-admin@lists.postgresql.org>;
 Mon, 27 Jan 2025 01:22:38 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20230601; t=1737969757; x=1738574557;
 darn=lists.postgresql.org;
        h=in-reply-to:content-disposition:mime-version:references:message-id
         :subject:cc:to:from:date:from:to:cc:subject:date:message-id:reply-to;
        bh=UCghUH8MYceqclizq+cxNBBjxgt0pXA8aPponLoNO80=;
        b=hqrlOFSAhecHk/u8xwfpu+yrvveZwR7P5uWpLd5imIYTftrf5puXOszhIMY6HaC0bp
         +Hq3TugIVmyMto7dFnhoY6mJJW7+abOTvqK3KOHskOc2jpFkKK8hGpYPyQGvKkahrnNz
         tfA4UgRwWkXVmLSB87E8xceATFnXtm/u69AqwYnl2+5vFpZig9OwxcFKIwsu0eBGxAG9
         w6u0WxC00ldLgrM5N25tjFCXNRPNUxk6+Bg4sXpgTwrLW6JItAxpsKy8ZtBt9LsCNIDz
         E59tPvWH6H9wAcu2/l1y3YgVD784ZKawO2+Aqej08+P/qKlGzygnWWyE7GbRnUkvlimS
         zIWg==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20230601; t=1737969757; x=1738574557;
        h=in-reply-to:content-disposition:mime-version:references:message-id
         :subject:cc:to:from:date:x-gm-message-state:from:to:cc:subject:date
         :message-id:reply-to;
        bh=UCghUH8MYceqclizq+cxNBBjxgt0pXA8aPponLoNO80=;
        b=g9nNj6FPtA/MYLHIQEvxRLZTh+RNl7GaMbKN+i6GgKoc8E+V4LgZbgWEb3d+IkaEBn
         FE1XQt4ZlJMGQCDR2mgSqDRckLzlE5BIYOnT39M7XtG4OTLjblVvUqMLIiEOI1RPMevA
         eZXn/YuzhJjz/raxVWuyumfwhLunT/0qGkJ/6juxUZgtpCW+kJ5lg+5ecmo8x5CX0GUa
         pXNMDs3+VejODEfcb+mUcAaVDJNLmHgZ5aYGxVttMqK9OmlqfdUsRabXnlOfEE3hHkL3
         CcabQRhbjXHPnBePdpwmNqiqT56szpd0fJ02ogZ2YovQbP5kE8U9hNba02APQEtuS3Oq
         Hq8g==
X-Gm-Message-State: AOJu0Yzjh3PniTJenlMuranbF41d3XwiBlWADiPGiTAIp9p+Ub3cILtB
	Urt1MB9HHzGSvuMMYPJG71hax6BU2c+PkChhvER/2kvgdACtM1MY
X-Gm-Gg: ASbGncufpNMyC+cqRA8PWbNA1fL8FqSOSgP8zCLgyrue0sb90gpVVE4YWaQLvFCsWmy
	2JO8Vye2lEOYuSNHyLtK5yTaUVpNSf5fxoSroVUWg00D6toMJEHH2xdUff0j2t7dHRYSbIzMtQZ
	LwY9dtti8YHHW1m1r0GtFckCqBbOPpNmBsA6L1ofWLqhJEIiykXbqQBDKWRCeXNKMp4o6tmTSA/
	bttbInghZnkPUAVoJjjtPRCp8VS4Z9bkCpCsZmnkwEjt0bVlXAczcQw1Zydnk2+VsrR1VgJ
X-Google-Smtp-Source: 
 AGHT+IHDcNmLrceBZ2tdjKc/FF3LvcHtyHwVYK+d9kuRC6mKCNd3ZUW/gRLyRHwaX6OwyrHqJWm08Q==
X-Received: by 2002:a17:902:ecc7:b0:215:6489:cfbf with SMTP id
 d9443c01a7336-21c352de2d6mr582186035ad.11.1737969757334;
        Mon, 27 Jan 2025 01:22:37 -0800 (PST)
Received: from jrouhaud ([115.43.41.38])
        by smtp.gmail.com with ESMTPSA id
 d9443c01a7336-21da41415c7sm58658265ad.108.2025.01.27.01.22.35
        (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256);
        Mon, 27 Jan 2025 01:22:36 -0800 (PST)
Date: Mon, 27 Jan 2025 17:22:31 +0800
From: Julien Rouhaud <rjuju123@gmail.com>
To: Rajesh Kumar <rajeshkumar.dba09@gmail.com>
Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Subject: Re: Oracle to postgres migration
Message-ID: <Z5dQV9IVZcLjKN3b@jrouhaud>
References: 
 <CAJk5AtavL_Q9AbcBw3J3oDmY+ggUC+Mgz-9RqOv0vHH1O9FQbA@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: 
 <CAJk5AtavL_Q9AbcBw3J3oDmY+ggUC+Mgz-9RqOv0vHH1O9FQbA@mail.gmail.com>
List-Id: <pgsql-admin.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-admin@lists.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-admin>
Archived-At: 
 <https://www.postgresql.org/message-id/Z5dQV9IVZcLjKN3b%40jrouhaud>
Precedence: bulk

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-assessment.

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