ora2pg | free tool used to migrate an Oracle database | Database library

by darold Perl Version: v23.2 License: GPL-3.0

X-Ray Key Features Code Snippets Community Discussions(7)Vulnerabilities Install Support

kandi X-RAY | ora2pg Summary

ora2pg is a Perl library typically used in Database, PostgresSQL, Oracle applications. ora2pg has no bugs, it has no vulnerabilities, it has a Strong Copyleft License and it has medium support. You can download it from GitHub.

NAME Ora2Pg - Oracle to PostgreSQL database schema converter. DESCRIPTION Ora2Pg is a free tool used to migrate an Oracle database to a PostgreSQL compatible schema. It connects your Oracle database, scans it automatically and extracts its structure or data, then generates SQL scripts that you can load into your PostgreSQL database. FEATURES Ora2Pg consist of a Perl script (ora2pg) and a Perl module (Ora2Pg.pm), the only thing you have to modify is the configuration file ora2pg.conf by setting the DSN to the Oracle database and optionally the name of a schema. Once that's done you just have to set the type of export you want: TABLE with constraints, VIEW, MVIEW, TABLESPACE, SEQUENCE, INDEXES, TRIGGER, GRANT, FUNCTION, PROCEDURE, PACKAGE, PARTITION, TYPE, INSERT or COPY, FDW, QUERY, KETTLE, SYNONYM. INSTALLATION All Perl modules can always be found at CPAN (Just type the full name of the module (ex: DBD::Oracle) into the search input box, it will brings you the page for download.

Support

Quality

Security

License

Reuse

Support

ora2pg has a medium active ecosystem.

It has 865 star(s) with 315 fork(s). There are 76 watchers for this library.

It had no major release in the last 12 months.

There are 100 open issues and 1431 have been closed. On average issues are closed in 16 days. There are 1 open pull requests and 0 closed requests.

It has a neutral sentiment in the developer community.

The latest version of ora2pg is v23.2

Quality

ora2pg has 0 bugs and 0 code smells.

Security

ora2pg has no vulnerabilities reported, and its dependent libraries have no vulnerabilities reported.

ora2pg code analysis shows 0 unresolved vulnerabilities.

There are 0 security hotspots that need review.

License

ora2pg is licensed under the GPL-3.0 License. This license is Strong Copyleft.

Strong Copyleft licenses enforce sharing, and you can use them when creating open source projects.

Reuse

ora2pg releases are available to install and integrate.

Installation instructions are not available. Examples and code snippets are available.

Top functions reviewed by kandi - BETA

kandi's functional review helps you automatically verify the functionalities of the libraries and avoid rework.
Currently covering the most popular Java, JavaScript and Python libraries. See a Sample of ora2pg

Get all kandi verified functions for this library.

ora2pg Key Features

No Key Features are available at this moment for ora2pg.

ora2pg Examples and Code Snippets

No Code Snippets are available at this moment for ora2pg.

Community Discussions

Trending Discussions on ora2pg

Can I migrate a partitioned table to a non-partitioned table in Oracle with the CREATE TABLE statement?

Debugging a Google Dataflow Streaming Job that does not work expected

Is there a way to install ora2pg tool on a Linux machine without having Perl installed first?

ora2pg fails to connect but sqlplus works

How to extract public DBlink with ora2pg

Oracle Version requirements for ORA2PG tool to migrate from Oracle to PostgreSQL

Recursive in Postgresql 12.2

QUESTION

Can I migrate a partitioned table to a non-partitioned table in Oracle with the CREATE TABLE statement?

Asked 2022-Feb-14 at 09:46

I have an Oracle 11g partitioned table with 10 partitions for ten years of data, each on its own tablespace partitioned by range. Each year-partition contains 12 monthly-partitions.

I would like to convert this table to a non-partitioned table, before migrating all the database to Postgresql 10.7 with ora2pg.

I've read that I could first backup this table by expdp and then import it using PARTITIONS_OPTIONS parameter option of impdp.

But is it also possible to use this following statement as a strict equivalent ?

...

ANSWER

Answered 2022-Feb-14 at 07:19

Syntax you posted doesn't exist in Oracle (there's no if not exists clause there).

Therefore, you'd

Source https://stackoverflow.com/questions/71108272

QUESTION

Debugging a Google Dataflow Streaming Job that does not work expected

Asked 2022-Jan-26 at 19:14

I am following this tutorial on migrating data from an oracle database to a Cloud SQL PostreSQL instance.

I am using the Google Provided Streaming Template Datastream to PostgreSQL

At a high level this is what is expected:

Datastream exports in Avro format backfill and changed data into the specified Cloud Bucket location from the source Oracle database
This triggers the Dataflow job to pickup the Avro files from this cloud storage location and insert into PostgreSQL instance.

When the Avro files are uploaded into the Cloud Storage location, the job is indeed triggered but when I check the target PostgreSQL database the required data has not been populated.

When I check the job logs and worker logs, there are no error logs. When the job is triggered these are the logs that logged:

...

ANSWER

Answered 2022-Jan-26 at 19:14

This answer is accurate as of 19th January 2022.

Upon manual debug of this dataflow, I found that the issue is due to the dataflow job is looking for a schema with the exact same name as the value passed for the parameter databaseName and there was no other input parameter for the job using which we could pass a schema name. Therefore for this job to work, the tables will have to be created/imported into a schema with the same name as the database.

However, as @Iñigo González said this dataflow is currently in Beta and seems to have some bugs as I ran into another issue as soon as this was resolved which required me having to change the source code of the dataflow template job itself and build a custom docker image for it.

Source https://stackoverflow.com/questions/70703277

QUESTION

Is there a way to install ora2pg tool on a Linux machine without having Perl installed first?

Asked 2021-Oct-12 at 13:07

Usually the installation of "ora2pg" database migration tool on a Linux machine requires Perl, so I was wondering if there is an alternative way of installing the tool.

...

ANSWER

Answered 2021-Oct-12 at 13:07

ora2pg is written in Perl, so you cannot run it without installing Perl.

Source https://stackoverflow.com/questions/69538975

QUESTION

ora2pg fails to connect but sqlplus works

Asked 2021-Oct-07 at 00:52

I am using the setup from https://oracle-base.com/articles/19c/minimum-viable-oracle-database-19c-installation-on-ol8#download-software that does this:

...

ANSWER

Answered 2021-Oct-06 at 23:03

Service name of your pluggable database is ORCLPDB1, so use it instead of CDB service name(ORCLCDB):

Source https://stackoverflow.com/questions/69473541

QUESTION

How to extract public DBlink with ora2pg

Asked 2021-Apr-27 at 09:58

My understanding is that ora2pg is capable of extracting private Oracle DBLinks inside a schema. How about public DBlinks (in DBeaver, I see them under Global metadata/Public Database Links)?

If I specify a schema in the config file and run this command, no DBLink is found (as excpected, because no private DBLink is set inside this schema):

...

ANSWER

Answered 2021-Apr-27 at 09:58

Inside /config/ora2pg.conf, you just need to put PUBLIC for the schema name:

Source https://stackoverflow.com/questions/67216826

QUESTION

Oracle Version requirements for ORA2PG tool to migrate from Oracle to PostgreSQL

Asked 2020-Nov-10 at 20:58

I am trying to figure out what is the minimum and maximum versions or Oracle supported by ORA2PG tool for migrating Oracle database to PostgreSQL. I cannot locate it in their documentation. If someone has a link to this guidance, I will appreciate it. Thanks.

...

ANSWER

Answered 2020-Nov-10 at 20:58

I never used the tool, but - it seems that all it cares about is Oracle Client (or the Server itself) installed as ORA2PG needs "something" to use to establish connection to the database.

The lowest Oracle database version I found to be used with ORA2PG is 8i, while the highest is 18c. I presume that 19c would work as well as both 18c and 19c actually represent 12c releases (but Oracle decided to change the way it numbers the releases).

Therefore, I'd say that it covers all currently supported (by the Oracle corp.), as well as quite a few unsupported Oracle database versions.

Source https://stackoverflow.com/questions/64776087

QUESTION

Recursive in Postgresql 12.2

Asked 2020-Apr-29 at 13:40

I am using Ora2Pg tool to migrate from Oracle to Postgresql. My oracle code is

...

ANSWER

Answered 2020-Apr-29 at 13:40

That is a really poor translation for a hack in Oracle (and shows once more that automatic translation of procedural code very often leads to more work then manual translation)

The original Oracle query is a hack to split a delimited list into rows. This can be done a lot easier in Postgres:

Source https://stackoverflow.com/questions/61501037

Community Discussions, Code Snippets contain sources that include Stack Exchange Network

Vulnerabilities

No vulnerabilities reported

Install ora2pg

You can download it from GitHub.

Support

For any new features, suggestions and bugs create an issue on GitHub. If you have any questions check and ask questions on community page Stack Overflow .

Find more information at: