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 1oGzJH-0001oR-MO for pgsql-admin@arkaria.postgresql.org; Thu, 28 Jul 2022 08:56:01 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oGzJG-0002vo-CE for pgsql-admin@arkaria.postgresql.org; Thu, 28 Jul 2022 08:55:58 +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 1oGzJF-0002vZ-Uq for pgsql-admin@lists.postgresql.org; Thu, 28 Jul 2022 08:55:58 +0000 Received: from mailout1.med.uni-muenchen.de ([138.245.1.11] helo=srvproofp2.srv.med.uni-muenchen.de) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oGzJ8-0003sl-Mo for pgsql-admin@lists.postgresql.org; Thu, 28 Jul 2022 08:55:57 +0000 Received: from pps.filterd (srvproofp2.srv.med.uni-muenchen.de [127.0.0.1]) by srvproofp2.srv.med.uni-muenchen.de (8.17.1.5/8.17.1.5) with ESMTP id 26S3uZXO023878 for ; Thu, 28 Jul 2022 10:55:49 +0200 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=med.uni-muenchen.de; h=from : to : subject : date : message-id : content-type : mime-version; s=gw1201801; bh=2oBmM3vpzHQE2EUSAI1MNYoAZr2qZ98SkXeFGy+iQV8=; b=Kud8JaEJSScBDpnAA/Yytpq8TcN6i4pkH9NjirgDWqJlYATz/HZa+F27X7jpGoOfxH+a SL9MN0WrACCNtaajUbIS/JpDW8EDtT5PcJhxwWV2eb+AW+Usj1MeHxXXrt1UvHZCS+2E vMrNjKCvIrmVeSLMoTlyXljbEdIrcUY/oRA= Received: from mailout1.med.uni-muenchen.de ([192.168.21.11]) by srvproofp2.srv.med.uni-muenchen.de (PPS) with ESMTPS id 3hjtg8mudt-1 (version=TLSv1.2 cipher=ECDHE-RSA-AES256-GCM-SHA384 bits=256 verify=NOT) for ; Thu, 28 Jul 2022 10:55:48 +0200 Received: from MITMB2.helios.med.uni-muenchen.de (unknown [172.17.9.90]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-SHA384 (256/256 bits)) (No client certificate requested) by mitseppm1.srv.med.uni-muenchen.de (Postfix) with ESMTPS for ; Thu, 28 Jul 2022 10:55:48 +0200 (CEST) Received: from MITMB5.helios.med.uni-muenchen.de (172.17.9.93) by MITMB2.helios.med.uni-muenchen.de (172.17.9.90) with Microsoft SMTP Server (TLS) id 15.0.1497.36; Thu, 28 Jul 2022 10:55:48 +0200 Received: from MITMB5.helios.med.uni-muenchen.de ([fe80::c8e0:aa38:4383:6cb8]) by MITMB5.helios.med.uni-muenchen.de ([fe80::c8e0:aa38:4383:6cb8%12]) with mapi id 15.00.1497.036; Thu, 28 Jul 2022 10:55:48 +0200 From: "Dischner, Anton" To: pgsql-admin Subject: Oracle data to PG Thread-Topic: Oracle data to PG Thread-Index: AdiiX8UvqT4aA++pQAin/d8FNavTQg== Date: Thu, 28 Jul 2022 08:55:48 +0000 Message-ID: <31df7c7aa56a44cf8e23aca8b3f80513@MITMB5.helios.med.uni-muenchen.de> Accept-Language: de-DE, en-US Content-Language: de-DE X-MS-Has-Attach: X-MS-TNEF-Correlator: x-ms-exchange-transport-fromentityheader: Hosted x-originating-ip: [172.17.13.18] Content-Type: multipart/alternative; boundary="_000_31df7c7aa56a44cf8e23aca8b3f80513MITMB5heliosmedunimuenc_" MIME-Version: 1.0 X-SM-outgoing: yes X-Proofpoint-GUID: L7d6KbnVx_zgpxI0DPRe4X5FVw_GEeXy X-Proofpoint-ORIG-GUID: L7d6KbnVx_zgpxI0DPRe4X5FVw_GEeXy List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --_000_31df7c7aa56a44cf8e23aca8b3f80513MITMB5heliosmedunimuenc_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Hi Team, we are searching for a way to import a dump from an Oracle Installation int= o PostgreSQL. Ist not administrated by us, so foreing table or connect as an user (as ora= 2pg seems to need) is not an option. We had a look into https://www.enterprisedb.com/blog/the-complete-oracle-to= -postgresql-migration-guide-tutorial-move-convert-database-oracle-alternati= ve especially: * Ora2pg-a robust migration tool that connec= ts to an Oracle database, extracts schemas and tables and generates SQL sc= ripts that can be loaded into Postgres. * Ora_migrator-an extension that uses an oracle_fdw foreign data wrap= per to extract data from an Oracle database. * Orafce-this extension allows you to implement a number of Oracle func= tions in Postgres. It also provides support for Oracle date formatting and= additional Oracle data types. * EDB Migration Portal-a web-based service for migrating from Oracle to= EDB Postgres Advanced Server that features Assessment= , Schema conversion and Compatibility reporting. we have to import data only. No indexes, PL/SQL or other stuff. Maybe it makes sense to install an Oracle Instance, import the data and the= n connect as a user and do the conversion. What are you hints and experiences to plan and accomplish this task? best Anton --_000_31df7c7aa56a44cf8e23aca8b3f80513MITMB5heliosmedunimuenc_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Hi Team,

 

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 con= nect as an user (as ora2pg seems to need) is not an option.

 

We had a look into https://www.enterprisedb.com/blog/the-complete-oracle-to-postgresql-migrati= on-guide-tutorial-move-convert-database-oracle-alternative

especially:

  • Ora2pg—a robust migration t= ool that connects to an Oracle database,  extracts schemas and tables = and generates SQL scripts that can be loaded into Postgres.
    • =
  • Ora_migrator—an extension that  uses  an oracle_fdw foreign= data wrapper to extract data from an Oracle database. 
  • Orafce—this extension allows you to implement a number of Oracle func= tions in Postgres.  It also provides support for Oracle date formattin= g and additional Oracle data types.
  • EDB Migration Portal—a web-based service for migrating= from Oracle to EDB Postgres Advanced Server that features Assessment, Schema conversio= n and Compatibility reporting. 

we have to import data only.

No indexes, PL/SQL or other stuff.

 

Maybe it makes sense to install an Oracle Instance, = import the data and then connect as a user and do the conversion.

 

What are you hints and experiences to plan and accom= plish this task?

 

best

 

Anton

 

 

 

 

--_000_31df7c7aa56a44cf8e23aca8b3f80513MITMB5heliosmedunimuenc_--