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 1oH3aB-0005uz-Vz for pgsql-admin@arkaria.postgresql.org; Thu, 28 Jul 2022 13:29:44 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oH3aA-00074f-H0 for pgsql-admin@arkaria.postgresql.org; Thu, 28 Jul 2022 13:29:42 +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 1oH3a9-00074W-S4 for pgsql-admin@lists.postgresql.org; Thu, 28 Jul 2022 13:29:42 +0000 Received: from sonic312-23.consmr.mail.ne1.yahoo.com ([66.163.191.204]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1oH3a5-0006FZ-Kk for pgsql-admin@lists.postgresql.org; Thu, 28 Jul 2022 13:29:41 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1659014973; bh=cx0Rt3O1L+fFQeOzZXETxOV+pYPj8at5M5wl4Axckc8=; h=Date:From:Reply-To:To:Cc:In-Reply-To:References:Subject:From:Subject:Reply-To; b=CrRQkg/mQ/N+89hzDa9z7TUzOQm9JIjM/nhIIJaryXA/6qam0+wVeCqZ1DzoWu8ZZgg0ZJCOO4rHNL55JrkS5+qgS+J3Lp+XNCzpxgfgexIJKUuIR40ImcfqOzsv99kBZKDQx2HCGWZYvek1xaU00zdhyACdNbHzaFrCbNp5GFxa8qxECALN5REDNAZcITMMMppSCDoDzTHvLscRDIxl9tsz/CpKOdGXobQaSvkllQ1VWY9reBLVQHge1/8A6lcIIUMnXCYeiH7evAz89HgU5bWRRVwDbqpLhHI4WLYs7FOVUyV8yljCJLFAw7WwHuSBcF1vc9UEeYpY97qlIB9CpQ== X-SONIC-DKIM-SIGN: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1659014973; bh=qSwCn2Z+IHvsARonB6pzm2OxPmkX9ZX+oE6DMVvoIw5=; h=X-Sonic-MF:Date:From:To:Subject:From:Subject; b=WjoJE+xXo1yEDhh/YnYRKB0eDnGhIEuCb4RWbghImEQr75tPGgJc2owT4CCEMsZRsc4tahA0NBnSjKYQEfJNzVyWpmD/MmrOf2kkz+vySsk0g/3MDNsPkhSo7C7ZFyvyuYC19WrMjTykG4oShlN6eyFXeKf8dgeH2W53lvhxLAW9sgXnfGJQIelA1o+jI9yaIFRDI7ZIYEYdY8UoErxZIZ7grQWHGq/fwlgmv5sGWZ4NRxSOW24NpRiDq/MITF0X6o5ds+d09awV7siuzEdFAGX6ZDRZixdQnIAU2tQFY7d9dJ4GhLgqYi54zg0U5KKSyKs58Itt2JKFmfRc0do+0A== X-YMail-OSG: FXAYXt8VM1lVT5pg8TTn62Q_vV8Y7pll5bjGjyVLp4F2QzWnXfaoAFDl3N.4Dp2 Sm3.SybgmPZpm_bUs03_F7hHtM_f_MSBBVFA_e4h6oTzRRVomsfFh9iQOWcJ0kKRNLeJkBd0.8oF zf0spbS2lnmeCgKvgrMcR_u1bcMj_AVE4VsYjYhjLfLmw9MowxTJ4CrUtOxTQ6GZ_4HssH6bRqVF W4ulfj3RhtirNzdu8iPAXXI5.ZcPjGS9ya7nYfaRhFiMxO.T6sKC6iR1n6OnyDPxes5s7XjRQT0_ B2KvNVB28WWU3cTlcXoZnM45NkIlXwKLhjJKGvPTuUr36BOoHsqa9j9iDJVZolE_A1RKJkGAFcCF SpqzMnOc0GRu5lu1VRntI66Vp_HN4nyZQT03bNzZHxt7JIr83Jmm4yO4vBA_da83DK8tX58vo7zq VV.8khysvXTujUwllJFH6hRgtvm1tcFXGniAMBtoWq68IHC.RUANkkpW.woTJjPFuU9BKsIcxSCF GUSU3SLWzu09Ur6_ByfUDKk0S_FACVuEtclduNnYryXb6hEc_d6M8zUXxi0OUcvXNXzRthClExnL i_e_JWYeJnYQweEwme14nGBLvn1MgyilxEyp2Cm54f.nKD0XXBuLZzgH.Glh3wxUV06s5lLwIMCg tXFPTst.EPfBh5wsvTW.xd8Qemd7QZB4p4LXjLp6fwCqkEA1YNvKvfuDDu2Mvhs6SETjb0UNc9fu uH9lVsrAT16gKaERrqw_cZsZr2IqISdXKjFkTIhbUmub9qMKf_HXhWp2Ugvm6jOaSTyOKSBAx44H u65TnagtwbBGmPLeJEXNR6fFLjIJGoyN45Pd.HBzD4GoT_8pAlxg0dFZAy_QXvRYEmENQr5G3dZc kGli.FxKCRB8O32xk.r5e.xnJBL_jYqXmRu_8SnS2RGkBi7KllNSBIAqZAh05pK5zEbiTQncVwH_ UXvsCeefap1F9B8qJ02DXms4hQw8iwmap4J6dJgBexpPPiCvHZob92B3oLYytRBwFSCMjUY0YoXL BrI2tDsgjFAfDzinii8KjCQWEgIWidS9WhPMTOiRB62x703ON6NyuE1YxdbCfLhodE2cRnTK1DDI FwHRzZ7kHkSftb45KnztO0dc7QfKTeBXKP4Ft24Q9PEboshKS.hNwjGRsfAuWKu9qYwUe_KlePEa dk1Mzc.0TK1tVo9cqFLPi4yG4jaPb.mqqAf1.5eKU0OHvFNpIrAyvqGoygOf4XCLuEmDkT0BM.iM 2xv1HySujD.IVwXUK5VwBiT9IbsGqWlI_O8xjm_SFZpQ1y_.U0gZ6u9eSsSnmsdKJUw_CtyJDhAp Jem7Hq65se5uXJQZhcn1NxH0Xzw2tBzTj835znUgNr95u0MIcPMp_LJC81yl.qAd09InLFYCoqzI ucs_DAvqzCCfxHIBsQ8kbp_A1NqP5ueyOwKTfG8tDsFqnesuE4b9EUsns.1r96Y46jCZS5.VZ7v9 7KUzcn6jqWjB_5rjstJHVfCnVA8rZiCxINfoRCdi6JWg4ZmQOiZ5cduVSoC.SrMAibhvY8SPbR7G SWw6CEAJeJdRx0Qjcny2vISzwJojBY48wQ_XDeq5uDdAIiscxOjP82Nr28jLUHejfg4hPy_lv.Hc S68zOw9Hejw1BvtXi0YgVL1nDGtJt5kEVQTvUEr.7aMHegxsFPF6TpMKwctZFdcRNOi_FlURqQ_G Dan4stDv08R89KveSEC.Me_WYlQXvk9prUyUid_zmzUlmbaMJGArfLdOGjDD4poqyLSPkb_Ht7PB Btyl1IrzXhUOsDjlRuQoUxaurh7pk.K_ojRkIIMH67FE1JjDaH_yMrwRyob1qqXcxXAIyJiAs.T4 USDWaD8O6YBrxWOhWNF775XFmTdITsTcRhQEm4Ga55G6KV461BK7fMykMTlKb2GR0FezNeOBf0xv uWfty4MBIJP77K85c8iVaGV5EtijoIbF4H2QpUUeukK6xV9MPD2MKx0sruKEBkldyfTHHMMetOZb VaaGlr3jV9vWTQred5SZ_.VP2DIhuDX8V4HkSdLPB2svQZA4reEEpB3NnaqOi28Kiaehnk7aeTPJ fLLf2C8xNrgkYIoujCGx3kSLWVvAx7fM9doLvgGLHIwdGB.Brd_Q.rCYdL5Ifie67eWpU1UZKz8b xgHPX58AW.SaH4kUkdLPP0AuasfVsAtiNaJHojESzBgoumO9mykxmX4zrrrXNGRKwNl9evobWaKl mCD.QFqKebSmp3iYlD4djNODspngquBQUmd9lILewgC7f8C_qt5a2vk6HvzWDxS8zT7w9mBj05s_ 4PT.mo83HOANDbmGYgbPBQ.bmnPY8LvnzC0WbS__CPbcC53dzDsXW1EC6OpX_1qYug8THXmT3fbH 8OEb_jTnzIAbr1zvlD6mklgSF82UGhuhevHcs2iQkTq5e19Ts39fIGKFHwslD22bezsrtiA0bT2_ xThHuZh_sKdY5xTuf1ZW1KiEo2YaoU6HEh1PMzvbBdJfyjc03R.tLw0Pe89SX4zN_6dB6nnY3ZOf eTP0ZvSBRBAF3IeUXeTIgh70Z6RMkNzOAftzOjffIGy3o6G6U8UreKo9Vok3hNL.FLfrtvu6ZvNH qYn7jz0xIxu5YJA-- X-Sonic-MF: Received: from sonic.gate.mail.ne1.yahoo.com by sonic312.consmr.mail.ne1.yahoo.com with HTTP; Thu, 28 Jul 2022 13:29:33 +0000 Date: Thu, 28 Jul 2022 13:29:26 +0000 (UTC) From: Pepe TD Vo Reply-To: Pepe TD Vo To: juanjo.santamaria@gmail.com, "Dischner, Anton" Cc: pgsql-admin Message-ID: <2097661791.3351141.1659014966420@mail.yahoo.com> In-Reply-To: References: <31df7c7aa56a44cf8e23aca8b3f80513@MITMB5.helios.med.uni-muenchen.de> Subject: Re: Oracle data to PG MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_3351140_393497109.1659014966418" X-Mailer: WebService/1.1.20447 YahooMailAndroidMobile Content-Length: 3902 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ------=_Part_3351140_393497109.1659014966418 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable As Anyon said.I use SQL Developer dump into csv and import to Postgres plsq= l or pgadmin. Sent from Yahoo Mail on Android=20 =20 On Thu, Jul 28, 2022 at 8:19, Juan Jos=C3=A9 Santamar=C3=ADa Flecha wrote: =20 On Thu, Jul 28, 2022 at 10:56 AM Dischner, Anton wrote: =C2=A0 we are searching for a way to import a dump from an Oracle Installation int= o PostgreSQL. =C2=A0 Ist not administrated by us, so foreing table or connect as an user (as ora= 2pg seems to need) is not an option. =C2=A0 Why don't you have the Oracle people dump the data you need into a CSV file= and COPY it into Postgres? Regards, Juan Jos=C3=A9 Santamar=C3=ADa Flecha =20 ------=_Part_3351140_393497109.1659014966418 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable As Anyon said.
I use SQL Developer dump into csv and import to Postgres= plsql or pgadmin.


Sent from Yahoo Mail on Android
On Thu, Jul 28, 2022 at 8:19,= Juan Jos=C3=A9 Santamar=C3=ADa Flecha
<juanjo.santamaria@gmai= l.com> wrote:

On Thu, Jul 28, 2022 at 10:56 AM Dischner, Anton <Anton.Dischner@med.uni-muenchen.de> wrote:
=
<= div id=3D"yiv7220891962yqtfd11313" class=3D"yiv7220891962yqt1262881229">

 

we are searching for a way to import a = dump from an Oracle Installation into PostgreSQL.

 

Ist not administrated by us, so= foreing table or connect as an user (as ora2pg seems to need) is not an op= tion.

 

Why don't you have the Oracle people dump the da= ta you need into a CSV file and COPY it into Postgres?

Regards,

Juan = Jos=C3=A9 Santamar=C3=ADa Flecha
------=_Part_3351140_393497109.1659014966418--