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 1jQXrA-0000AT-Es for pgsql-admin@arkaria.postgresql.org; Mon, 20 Apr 2020 14:57:09 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jQXr9-0006CA-D4 for pgsql-admin@arkaria.postgresql.org; Mon, 20 Apr 2020 14:57:07 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jQXr8-0006C3-Uk for pgsql-admin@lists.postgresql.org; Mon, 20 Apr 2020 14:57:07 +0000 Received: from sonic311-20.consmr.mail.sg3.yahoo.com ([106.10.244.37]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1jQXr6-0001S6-5D for pgsql-admin@postgresql.org; Mon, 20 Apr 2020 14:57:05 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.co.in; s=s2048; t=1587394619; bh=cwCk8Cr6OMtJGZxtlkvw9ixsV57NNPeUmjL6VxPA8Ys=; h=Date:From:Reply-To:To:In-Reply-To:References:Subject:From:Subject; b=Fio698j52yLnrZzxNz9uI0NXIKzdnbxRVecpRwkbwPp3S/gLsx0hjQTDe34Pl/7rIht6/pul/b5LWb31s49xZzvDM4qqGKvCM/QBeL/hp23kxWXscOzS92gY9p03/tCMsDNQHhjXhJNf71H//GRUkxO/avdfLxu2/w4SjrxjJmwtsjBKG8Yp7meav/DochlZi5YTU0GvO/m6cNa5IhY8vny43+Psm6Yl1afV5mrU9OECHaWLTjQZJg3Xnm2JA17SjFEJb+O3rimqcdiJtJEL+nEA3yvyB1odS5s5LIuUSlDOUif6h5dsK1jGyjQk0mgT/7eZtK0JYCsNLcUEHTsJfA== X-YMail-OSG: 7ljTciYVM1mVsSqOtwOVh5LVVG1Xda.Yw3sholr5QroXpYVrvDBVJvc4QlbjNOF EPDZLBEEHObCTz_hPnVEyDtNPOrJy7bZXpbjFu4RJ_5sA057j.lQO2fj6C8S9jUmxSpY2rFGhyJS 9pmmCxXrsneuMv5_hbJ_A7Bs9x2CdOJOF_RqvFKdLAtGAF8Pf14KJZ_Q6twmVDFiB84CiI3flvmw cs_lFOieVdw636BHPzeP3bD6nDtSe8LWz60vqP8oHaSITx_JS_DiDgftO31uBZOWvzAJiDJOrQdm 7PIfVziUjucKzwYVaNe3GjsqswnOjyVrAmtkvwn0_1ZFsWYF_msru_R74py3W0DN6zwtYKZkUCNZ DPvaQVqFkAGW3RQSU5TbBSgsGen3H4FsZKEi93_76i9LfjbyK4ydVTlPgcHv8P02iNnKXz.S2k.p jzqgH2eapOsKHjGb_AAew5yHM.yMQ4vwWhDFQD1HhyKS7lu7ufDIp5gIiL8tXHy7mELjKxBqkSiQ B90HopBboosR.jPhnBAw_GXfMnVqU1KKzree.n5eNa7iXZ1qf246jW1cu2bGYf6HzG2tnDeMIO_X 67d5i5fu9G2e7IZC2ZHbvMoYvmEhTA490Xk5uXuZlD6_STc1t26TTKL2EkFq7LS4FM2Fhw6VuYPK SYnWoHz.cADsbNGs9yCl2bOGQRDEKS0jNJ93uRT8ctlWO_qJMHtod7TaJ8.VQwemUOoCfNajCpKS 4oUl2dhABVCff6D_Kgsst9GgZMUBmL2Zb0XNMMC9Tz1_gHYoq8yg74YPMAg523FvIEkKaCkJUxco sQv63mctPcwKGjSqMVUw3QscF5UfSXmmHoc9AJbmgY_as6upmTT4BWu4q6IaXJWIlFO7m563VDwS 4XliQuT1dzlTNspNeOdxtip6enROMPfSkjUiYq1.p0Tn9CI2JBfCGlezpa6tRHUvCXDbKqyIoJqJ LEoUXmrp_NiKt8Q3b_pJDXVVfPodVxC13WzyaGIfD7PMhxMnRauKM8WgmkjnRW8Y5VobxfdSJ3ec f.MWwF9PRXCstd2DZ3EwPFXSdNCOzA__UU6Zlj8FYTDz2aR_cR9nvycLJN5qFT2b58IslBuFyzCm cfaazn9w7tTs78yO5mjJchxwD5lNeZM.rDFeiaWqUt8JbKA9RO2jcr4MNH_AjNy8s4ynEfJYdVAF RI2TbJPpSW2K1zTeZbEtbu3_cH9K.blLd_BGl1hcHh4lG992M4sWj0WW5EPIxlXNo0dodhbBwROm A5IhVHylZSiIpacuOYTM6Zz7ASFaygJyhHt.gPrndYTlEszoyf9ZSFmR.wGPrFoK9A9PZbs12zWf QusEe.B9ecSDUOgBh3eui Received: from sonic.gate.mail.ne1.yahoo.com by sonic311.consmr.mail.sg3.yahoo.com with HTTP; Mon, 20 Apr 2020 14:56:59 +0000 Date: Mon, 20 Apr 2020 14:56:58 +0000 (UTC) From: manish yadav Reply-To: manish yadav To: pgsql-admin , Prashant Kulkarni Message-ID: <1450224935.2308894.1587394618311@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_2308893_1626601160.1587394618310" X-Mailer: WebService/1.1.15651 YMailNorrin Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_5) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/12.1.1 Safari/605.1.15 Content-Length: 3502 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk ------=_Part_2308893_1626601160.1587394618310 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable You may consider pgloader for copying data from csv to PostgreSQL in a fast= er way(in parallel) =C2=A0and with explicit error details. Thanks and Regards, Manish Yadav =20 On Monday, 20 April 2020, 5:23:52 PM IST, Prashant Kulkarni wrote: =20 =20 Hi Team, Please can you let me know the menthds/tools/approches to export large amou= nt 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. Thanks. =20 ------=_Part_2308893_1626601160.1587394618310 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
You may consider pgloader= for copying data from csv to PostgreSQL in a faster way(in parallel)  = ;and with explicit error details.

Thanks and Regards,




=20
=20
On Monday, 20 April 2020, 5:23:52 PM IST, Prashant Kulk= arni <ppk10.prashant@gmail.com> wrote:


Hi Tea= m,

Please can you let me know the menthds/tools/ap= proches to export large amount of data (TBs) present in the schemas into th= e 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 solutio= n to complete this task.

Thanks.
------=_Part_2308893_1626601160.1587394618310--