Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1j1u0B-0006aZ-1Q for pgsql-admin@arkaria.postgresql.org; Wed, 12 Feb 2020 15:32:35 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1j1tz9-0006WB-6F for pgsql-admin@arkaria.postgresql.org; Wed, 12 Feb 2020 15:31:31 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1j1tz8-0006Vw-IA for pgsql-admin@lists.postgresql.org; Wed, 12 Feb 2020 15:31:30 +0000 Received: from resqmta-ch2-06v.sys.comcast.net ([2001:558:fe21:29:69:252:207:38]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1j1tz4-0002Tt-Rc for pgsql-admin@lists.postgresql.org; Wed, 12 Feb 2020 15:31:29 +0000 Received: from resomta-ch2-07v.sys.comcast.net ([69.252.207.103]) by resqmta-ch2-06v.sys.comcast.net with ESMTP id 1ss9jjzWUlbu31tyzjOhwU; Wed, 12 Feb 2020 15:31:21 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=comcast.net; s=20190202a; t=1581521481; bh=J8NvSY+HuEX8UMquIPWOub5oKQ3b91GxbsFuu5bl3rs=; h=Received:Received:From:Message-Id:Content-Type:Mime-Version: Subject:Date:To; b=jR38an02BEDBz84wqp6pENS071bFyD9/lbwtLX98fnKxYCtoCuZfRa7GQHGtk+1++ iQ2UhricXzXOS1u40PKaiPMK+XX4hgqZJsIWrB/lTq0S2mxKhUGrH7JOubLWfqRHfP 7/efFCEDPViCkACXbrN3wLO01dpAVXwN7Cid/eMXG6YWbJfM0k73zzgNiUA0ne51SA Cbw54rOAPwmReRuvkZpyfZJE0dXtfEciY/72PEv+L5JjBDfr2RnHdpBxhTPPr8+n9a eq8RVAs9XfpkiKB/OFUZ/yrG67/TF7011yjjdDM/1kDBH/ql9doD4fP37e1OSEl2Zi uZJGY0SWzOJPA== Received: from [IPv6:2601:240:d081:59d0:e1b0:1fad:f7cc:c212] ([IPv6:2601:240:d081:59d0:e1b0:1fad:f7cc:c212]) by resomta-ch2-07v.sys.comcast.net with ESMTPA id 1tyxjmtYJTpPj1tyyj6miw; Wed, 12 Feb 2020 15:31:20 +0000 X-Xfinity-VMeta: sc=0.00;st=legit From: John Wiencek Message-Id: Content-Type: multipart/alternative; boundary="Apple-Mail=_A1B494E7-689F-42C6-835E-FB77B890C0AB" Mime-Version: 1.0 (Mac OS X Mail 12.4 \(3445.104.11\)) Subject: Re: Oracle to PostgreSQL - DWH Date: Wed, 12 Feb 2020 09:31:19 -0600 In-Reply-To: <2A91BEF8171A5349931391E0C721CC538530B929@CPEMS-KPN501.KPNCNL.LOCAL> Cc: pgsql-admin@lists.postgresql.org, pgsql-admin@postgresql.org To: soumik.bhattacharjee@kpn.com References: <2A91BEF8171A5349931391E0C721CC538530B929@CPEMS-KPN501.KPNCNL.LOCAL> X-Mailer: Apple Mail (2.3445.104.11) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --Apple-Mail=_A1B494E7-689F-42C6-835E-FB77B890C0AB Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii EnterpriseDB has a product called Migration Toolkit (MTK) that can do = this. John > On Feb 12, 2020, at 8:25 AM, = wrote: >=20 > Hi Experts, > =20 > Greetings!! > =20 > Did anyone have some use cases for migrating Oracle to PostgreSQL in = context to DWH(Data warehousing ) considering 5TB to 8TB database size = (Source-Oracle) > =20 > =20 > Thanks.. --Apple-Mail=_A1B494E7-689F-42C6-835E-FB77B890C0AB Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=us-ascii EnterpriseDB has a product called Migration Toolkit (MTK) = that can do this.


John

On Feb = 12, 2020, at 8:25 AM, <soumik.bhattacharjee@kpn.com> <soumik.bhattacharjee@kpn.com> wrote:

Hi Experts,
 
Greetings!!
 
Did anyone have some use = cases for migrating Oracle to PostgreSQL in context to DWH(Data = warehousing ) considering 5TB to 8TB database size (Source-Oracle)
 
 
Thanks..

= --Apple-Mail=_A1B494E7-689F-42C6-835E-FB77B890C0AB--