Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jQX0q-0006hY-2C for pgsql-admin@arkaria.postgresql.org; Mon, 20 Apr 2020 14:03:04 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jQX0o-0007FP-V4 for pgsql-admin@arkaria.postgresql.org; Mon, 20 Apr 2020 14:03:02 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jQX0o-0007FI-7W for pgsql-admin@lists.postgresql.org; Mon, 20 Apr 2020 14:03:02 +0000 Received: from sonic308-1.consmr.mail.bf2.yahoo.com ([74.6.130.40]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1jQX0l-0005sF-DU for pgsql-admin@lists.postgresql.org; Mon, 20 Apr 2020 14:03:01 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1587391375; bh=BWGLqhUn/rWY7PQy9a5N59Ngvz7eHY615C5Zanj9bR8=; h=Date:From:Reply-To:To:In-Reply-To:References:Subject:From:Subject; b=HE1977lZQUuCFThnEfnfhhaGWPV5sYcxAOh2VqAGFtSRFS9Ic3ZilHOzTwwrrkHZQebTxQasXpR0rX0bCE5WCggXKgHy6BFrvg8BE+GV6QzU5GAE37ERprHe6VXHHbZfqmjaf44v8hITCYrMlPZzCHCq2WLLi6pM4LV1n/atNKjRmse3Q6MdpEHBTaHaG/SWweB9Jyg0fnMZ86qGYORub2OCEPMLdGqTBp50xRKC2ZJeEt3nyNgupsOVX3ge+sVonH7oDlkGHpoMOJOVm2dFPDWY3LWRlkaRdhJxi5zqMUuYLM2MR8InMDZVWi+lkYinmwyTKWZB3d3YoDKv/y56Cg== X-YMail-OSG: cIAsscIVM1mXeSXYHdgh7p_vQvKWxWgUovABlkUcq_3x6C2K4WfXDgxsc0dTetT uyoFt.i48T.d0Skh4ClpUEYiOH8wedl1rCrx_828rGCcC.Eg5v7miKRfV358wOwdMzyS1r28jaC1 3_V1gSfQ8x3ei_WFGQADQqijo2gKamyuoHcAyRSYswMJp8XU_q_i5V6Mxv_RjNNNaPh40tJm4Eoe sVzOEjGbnq0NWcs.kri.pZJKLe3mIrwoO3S5B4zb9s2FPRlfZQ9Ly1Sp_iEALNEhpXF1bEYk_ZUR qQQkgxn.Gd46x0THvph839V0QaQrjNfJCxzJgtZ_Y4QulwshMolsTRt.vNpuChU2zWY0p4Auu.SX ZRxbPBlq9ue.VPmnmM.4mcCBga.IP.5ia8TrggfYL6A_oKuvQuddsVP1JlHhZ3bsYyWecqIZIwPD mNRjiuULElILwn2HjLJ.egbIw1WALVNI4jzvUEIGP61PRyLIarxY43JPEMeDszPd7VaqlmjdY90P .KATeXmK_WhevEEyLG6X4PSaLqXFft1jWO7iAKfdI6m.sk9Pa2F6RmaMkopok38qdnuQvavd9ty4 aVkJHVc4x3MqES7Zvrd7RmumYzFy_8RzX.jLV0G1lwPy.XsTKkMtG5GWCAhds80AgGDyGkfXEw2G umv2dDHkT.ZD3.0HFKdyeHEpOe2j0Ly2yu_LGve17wMO5eR9JwwnLsIPxtVvr.iq6ej69_OiG_mF tlVChaObsgbU_aYa15aF6lDWDq3_KBlVAGgs22bk6M0l0YkWIMHue9VrA4wh8iB_jySEnYxYU2Z3 xN2zOCRveycYWkp82Vl07Rz5L6qBSlhImdO5p.7b87YDxXA4UPczTSBR2r7oLDo4xxdoxBe0qqJR wrmwbeRsKvuxRRN1xjOc5eQCxbwywbODINdhvGkwxHkQNC6r7lNo8MW_xF.2_Yjft9vCp3978Veq 9HqM.bUZ.RZ9NvxS5HAJzsw7mi1XASe2xjymlaepHy0DOPVpZiPrNkJ19mTImtp1nkBGrMWvtFcb BLxsGxmOe1oABvzqYchQ..8To6LLP6tsYqN33YQfdgVCsdZurKFopluk7TB7m3Hfhlz1zFhb9o9m kEGpN0pc3YLIdhOIgVcgq0JccxP5fJbtUHPDfuXIbpNr1oifOGBASD88NCMo7n3J5AYCznakFzpS tJ3M7vems6EYWVrczVoaOuN4DoN3KCizTObypWdaM296iCBOdOSFBqjG58IaXvhx84RobbqFjvtn uXBSC6YcVmdfxUyBt2.HaGFxXP6Ky7NYU9_xxw2B0VBDjhJhuwzCp3FYarWqeZeI2Ex18jDhcNAY gqLxpJ4kgdyuNL0KNVw0.Qv1_xfjnR.FrTRR2V_GqFXE- Received: from sonic.gate.mail.ne1.yahoo.com by sonic308.consmr.mail.bf2.yahoo.com with HTTP; Mon, 20 Apr 2020 14:02:55 +0000 Date: Mon, 20 Apr 2020 14:02:53 +0000 (UTC) From: Pepe TD Vo Reply-To: Pepe TD Vo To: pgsql-admin@lists.postgresql.org, Thomas Kellerer Message-ID: <172687860.2288957.1587391373846@mail.yahoo.com> In-Reply-To: References: Subject: Re: Exporting TBs of data in Oracle schema/database into CSV format to migrate into PostgreSQL MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_2288956_1595961976.1587391373845" X-Mailer: WebService/1.1.15651 YMailNorrin Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/80.0.3987.163 Safari/537.36 Content-Length: 7082 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk ------=_Part_2288956_1595961976.1587391373845 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Mr. Kellerer, we can access Oracle table within Postgres?=C2=A0 How?=C2=A0 Need to create= a database link and/or how can both talk to each other? My data is from production, can turn off the foreign key.=C2=A0 Is there a = way to copy data from Oracle to Postgres faster?=C2=A0 Should I export the = Oracle data table via dump file as text/csv and insert it into Postgres?=C2= =A0 Can we use an oracle dump file? thank you. Bach-Nga No one in this world is pure and perfect.=C2=A0 If you avoid people for the= ir mistakes you will be alone. So judge less, love and forgive more.To call= him a dog hardly seems to do him justice though in as much as he had four = legs, a tail, and barked, I admit he was, to all outward appearances. But t= o those who knew him well, he was a perfect gentleman (Hermione Gingold) **Live simply **Love generously **Care deeply **Speak kindly.*** Genuinely = rich *** Faithful talent *** Sharing success=20 On Monday, April 20, 2020, 09:28:18 AM EDT, Thomas Kellerer wrote: =20 =20 Prashant Kulkarni schrieb am 20.04.2020 um 13:53: > Hi Team, > > Please can you let me know the menthds/tools/approches to export > large amount of data (TBs) present in the schemas into the > CSV/delimated format as we have to import that into PostgreSQL > later. > > I tried for options like SQL Developer/Toad but those are not > feasible for vast data size, these tool are OK for GBs of data to > export. > > Kindly let me know if you have any solution to complete this task. Using a foreign table would remove the need to dump and transfer the data to begin with. Then you could access the Oracle table directly from within Postgres: insert into some_table (...) select ... from oracle_fdw_table; =20 ------=_Part_2288956_1595961976.1587391373845 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Mr. Kellerer,
<= div dir=3D"ltr" data-setdir=3D"false">
we can access Oracle table within Postgres?  How?  Ne= ed to create a database link and/or how can both talk to each other?<= /span>

<= div dir=3D"ltr" data-setdir=3D"false">My data is from production, can turn = off the foreign key.  Is there a way to copy data from Oracle to Postg= res faster?  Should I export the Oracle data table via dump file as te= xt/csv and insert it into Postgres?  Can we use an oracle dump file?

thank you.

Bach-Nga

No one in this w= orld is pure and perfect.  If you avoid people for their mistakes you = will be alone. So judge less, love and forgive more.
To call him a dog hardly seems to do him justice though in as = much as he had four legs, a tail, and barked, I admit he was, to all outwar= d appearances. But to those who knew him well, he was a perfect gentleman (= Hermione Gingold)

**Live simply **Love generously **Care deeply **Speak kindly.
*** Genuinely rich *** Faithful talent *** = Sharing success


=20
=20
On Monday, April 20, 2020, 09:28:18 AM EDT, Thomas Kell= erer <shammat@gmx.net> wrote:


Prashant Kulkarni schrieb am 20.04.20= 20 um 13:53:

> Hi Team,
>
> Please can y= ou let me know the menthds/tools/approches to export
>= large amount of data (TBs) present in the schemas into the
> CSV/delimated format as we have to import that into PostgreSQL
> later.
>
> I t= ried for options like SQL Developer/Toad but those are not
> feasible for vast data size, these tool are OK for GBs of data to> export.
>
> = Kindly let me know if you have any solution to complete this task.

Using a foreign table would remove the n= eed to dump and transfer
the data to begin with.

Then you could access the Oracle table directl= y from within Postgres:

insert into so= me_table (...)
select ...
from oracle_f= dw_table;

=

------=_Part_2288956_1595961976.1587391373845--