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 1j1wia-0003GS-Td for pgsql-admin@arkaria.postgresql.org; Wed, 12 Feb 2020 18:26:37 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1j1wiZ-0002at-LG for pgsql-admin@arkaria.postgresql.org; Wed, 12 Feb 2020 18:26:35 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1j1wiY-0002am-Qm for pgsql-admin@lists.postgresql.org; Wed, 12 Feb 2020 18:26:35 +0000 Received: from resqmta-ch2-05v.sys.comcast.net ([2001:558:fe21:29:69:252:207:37]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1j1wiW-00029Y-2v for pgsql-admin@postgresql.org; Wed, 12 Feb 2020 18:26:33 +0000 Received: from resomta-ch2-01v.sys.comcast.net ([69.252.207.97]) by resqmta-ch2-05v.sys.comcast.net with ESMTP id 1uf9j5qtv9yxw1wiSjUEoc; Wed, 12 Feb 2020 18:26:28 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=comcast.net; s=20190202a; t=1581531988; bh=0XZ0mD3Itnc1R5fQKR/4h7lvlDC51r5i2hlHA3PwpLY=; h=Received:Received:Content-Type:From:Mime-Version:Subject:Date: Message-Id:To; b=U8onCebUTa5AYj1pCqrT5n32BUMojF4jC3jcLkgfzJLV8WUYbdRn8FkIHiLjRFDxE W76waBS3eJd5eS6LMGMRk1grGEgp8q5Iah1yez/LJAAVlv5nyLTzBdbadQzKfr5tLI B5nKBAxNYOR8uUz4tCNwhGuxwOJF6XaJWVszSeKBOS7QrLBwjPg7GC8TmCcofUAw48 e5Jby/yXHedmKciGUqUFZRqde4Lcgh39wgEfcOJMP4ie4Q2J04JvbssUPM52fKD1dn tpTT/HS+OJBl9ezVtd1bwXIqi3c8JKW+/zLWNYVvbsomD8eWV71UepzfH+v7d/aQ2R rtPwbBUeFgDKQ== Received: from [10.232.190.195] ([73.110.38.95]) by resomta-ch2-01v.sys.comcast.net with ESMTPA id 1wiQj1Yz8yB3r1wiRjtvL7; Wed, 12 Feb 2020 18:26:28 +0000 X-Xfinity-VAAS: gggruggvucftvghtrhhoucdtuddrgedugedrieehgdduudeiucetufdoteggodetrfdotffvucfrrhhofhhilhgvmecuvehomhgtrghsthdqtfgvshhipdfqfgfvpdfpqffurfetoffkrfenuceurghilhhouhhtmecufedttdenucgoufhushhpvggtthffohhmrghinhculdegledmnecujfgurheptgfghfggufffkfhfjgfvofesrgejmherhhdtjeenucfhrhhomheplfhohhhnucghihgvnhgtvghkuceojhifihgvnhgtvghkfeestghomhgtrghsthdrnhgvtheqnecuffhomhgrihhnpegslhhoghhsphhothdrtghomhenucfkphepjeefrdduuddtrdefkedrleehnecuvehluhhsthgvrhfuihiivgeptdenucfrrghrrghmpehhvghloheplgdutddrvdefvddrudeltddrudelhegnpdhinhgvthepjeefrdduuddtrdefkedrleehpdhmrghilhhfrhhomhepjhifihgvnhgtvghkfeestghomhgtrghsthdrnhgvthdprhgtphhtthhopehpghhsqhhlqdgrughmihhnsehlihhsthhsrdhpohhsthhgrhgvshhqlhdrohhrghdprhgtphhtthhopehpghhsqhhlqdgrughmihhnsehpohhsthhgrhgvshhqlhdrohhrghdprhgtphhtthhopegrlhhlrghnuggrvhhishhjrhesghhmrghilhdrtghomhdprhgtphhtthhopehsohhumhhikhdrsghhrghtthgrtghhrghrjhgvvgeskhhpnhdrtghomh X-Xfinity-VMeta: sc=49.00;st=legit Content-Type: multipart/alternative; boundary=Apple-Mail-A688494C-2FF6-426C-90E3-254267015B80 Content-Transfer-Encoding: 7bit From: John Wiencek Mime-Version: 1.0 (1.0) Subject: Re: Oracle to PostgreSQL - DWH Date: Wed, 12 Feb 2020 12:26:26 -0600 Message-Id: References: Cc: soumik.bhattacharjee@kpn.com, pgsql-admin@lists.postgresql.org, pgsql-admin@postgresql.org In-Reply-To: To: Allan Davis X-Mailer: iPad Mail (17D50) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --Apple-Mail-A688494C-2FF6-426C-90E3-254267015B80 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Oracle compatibility mode is the default setting when you init an EPAS datab= ase. =20 Jihn Sent from my iPad > On Feb 12, 2020, at 10:24 AM, Allan Davis wrote: >=20 > =EF=BB=BF > EnterpriseDB also has an Oracle Compatibility mode--a version of the Postg= res database that has an Oracle look and feel to it. Between this and the M= igration Toolkit, 95% of Oracle "stuff" should move over without too much tr= ouble. >=20 > (disclaimer: I've been working for EnterpriseDB for two months) >=20 > -=3Dad=3D- >=20 >> On Wed, Feb 12, 2020 at 10:31 AM John Wiencek wro= te: >> EnterpriseDB has a product called Migration Toolkit (MTK) that can do thi= s. >>=20 >>=20 >> John >>=20 >>> 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 con= text to DWH(Data warehousing ) considering 5TB to 8TB database size (Source-= Oracle) >>> =20 >>> =20 >>> Thanks.. >>=20 >=20 >=20 > --=20 > Perchance to Scream - Being frightened has never been so much fun! >=20 > Photo Gallery >=20 > Isn't a good laugh worth a nickel...? --Apple-Mail-A688494C-2FF6-426C-90E3-254267015B80 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable Oracle compatibility mode is the default se= tting when you init an EPAS database.   

Jihn
Sent from my iPad

On Feb 12, 2020, at 10:24 AM, Allan Davis <allandavisjr@= gmail.com> wrote:

=EF=BB=BF
EnterpriseDB also has an Oracle Compa= tibility mode--a version of the Postgres database that has an Oracle look an= d feel to it.  Between this and the Migration Toolkit, 95% of Oracle "s= tuff" should move over without too much trouble.

(disclaimer:&= nbsp; I've been working for EnterpriseDB for two months)

-=3D= ad=3D-

On Wed, Feb 12, 2020 at 10:31 AM John Wiencek <jwiencek3@comcast.net> wrote:
EnterpriseDB has a product called Migration Toolkit (MTK) that ca= n do this.


John

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

Hi Experts,
 
Greetings!!
 
Did anyone have so= me use cases for migrating Oracle to PostgreSQL in context to DWH(Data wareh= ousing ) considering 5TB to 8TB database size (Source-Oracle)<= /span>
 
<= div style=3D"margin:0cm 0cm 0.0001pt;font-size:11pt;font-family:Calibri,sans= -serif"> 
Thanks..



--
Perchance to Scream - Being frightened has= never been so much fun!

Photo Gallery

Isn't a good laugh worth a nickel...?
= --Apple-Mail-A688494C-2FF6-426C-90E3-254267015B80--