darold/ora2pg

View on GitHub

Ora2Pg is a free tool used to migrate an Oracle database to a PostgreSQL compatible schema. It connects your Oracle database, scan it automatically and extracts its structure or data, it then generates SQL scripts that you can load into PostgreSQL.

Stars: 1.2k
Forks: 378
Open beginner issues: 0
Indexed issues: 102

Dominant language: Perl
License: GPL-3.0
Last GitHub push: Aug 6, 2026
Latest indexed: Sep 20, 2026
Contributing guide: No contributing guide
Code of conduct: No code of conduct
Beginner labels: No beginner labels indexed
PR merge metrics: No merged PRs in 30d

Beginner friendly Everything

Open All

102 open issues indexed

GENERATED ... AS IDENTITY (options) wrapped in an extra pair of parentheses, fails to load in PostgreSQL Open

Difficulty 2/5 1-3 hours Newbie friendliness 58/100

darold/ora2pg#1978 · Opened Aug 25, 2026
A companion scanner for gaps ora2pg leaves behind (not a bug, just sharing) Open

Difficulty 5/5 Over a week Newbie friendliness 20/100

darold/ora2pg#1977 · Opened Aug 20, 2026
upgrade Open

Difficulty 1/5 Under an hour Newbie friendliness 35/100

darold/ora2pg#1973 · 1 comment · Opened Jul 18, 2026
REGEX problem in REPLACE_QUERY Open

Difficulty 4/5 3-5 days Newbie friendliness 35/100

darold/ora2pg#1972 · Opened Jul 17, 2026
concat with REQUEST_QUERY with || on no existing oracle field Open

Difficulty 4/5 3-5 days Newbie friendliness 30/100

darold/ora2pg#1971 · Opened Jul 17, 2026
problem with replace_query on multil line Open

Difficulty 3/5 1-2 days Newbie friendliness 55/100

darold/ora2pg#1970 · Opened Jul 17, 2026
I've Question for replace_query Open

Difficulty 4/5 3-5 days Newbie friendliness 35/100

darold/ora2pg#1969 · Opened Jul 15, 2026
Ora2Pg v25 generates invalid foreign keys for Oracle reference partitions when DISABLE_PARTITION is enabled Open

Difficulty 2/5 1-3 hours Newbie friendliness 76/100

darold/ora2pg#1965 · Opened Jun 3, 2026
create table without using psql Open

Difficulty 3/5 1-2 days Newbie friendliness 35/100

darold/ora2pg#1964 · 3 comments · Opened Apr 30, 2026
one oracle column into two postgres colum, Open

Difficulty 4/5 3-5 days Newbie friendliness 35/100

darold/ora2pg#1962 · 1 comment · Opened Apr 4, 2026
replace columns and select as, same functionnality Open

Difficulty 3/5 1-2 days Newbie friendliness 45/100

darold/ora2pg#1961 · Opened Apr 4, 2026
import_all.sh does not reload FK constraints after data load when DROP_FKEY=1 Open

Difficulty 2/5 1-3 hours Newbie friendliness 76/100

darold/ora2pg#1960 · Opened Mar 29, 2026
Can i have oracle and postgres in subselect query inside select ? Open

Difficulty 4/5 3-5 days Newbie friendliness 35/100

darold/ora2pg#1959 · 1 comment · Opened Mar 28, 2026
SCHEMA directive with multiple schemas does not to generate output.sql file appropriately for TYPE COPY Open

Difficulty 3/5 1-2 days Newbie friendliness 45/100

darold/ora2pg#1958 · 1 comment · Opened Mar 24, 2026
Query to identify columns that may be boolean Open

Difficulty 4/5 3-5 days Newbie friendliness 25/100

darold/ora2pg#1956 · 1 comment · Opened Mar 16, 2026
Switch to force double quotes around object names Open

Difficulty 4/5 3-5 days Newbie friendliness 35/100

darold/ora2pg#1955 · 1 comment · Opened Feb 25, 2026
Support "as sysdba" syntax with wallet authentication (SEPS) Open

Difficulty 2/5 1-3 hours Newbie friendliness 48/100

darold/ora2pg#1953 · Opened Feb 13, 2026
Direct data copy with PG_DSN automatically preserves table case Open

Difficulty 4/5 3-5 days Newbie friendliness 38/100

darold/ora2pg#1951 · 2 comments · Opened Jan 17, 2026
Ora2Pg 在转换 CONNECT BY PRIOR 时未完全移除 PRIOR Open

Difficulty 3/5 1-2 days Newbie friendliness 45/100

darold/ora2pg#1950 · Opened Jan 13, 2026
Package name conversion or rename Open

Difficulty 4/5 3-5 days Newbie friendliness 35/100

darold/ora2pg#1949 · Opened Jan 13, 2026
Workaround for TRUNC() and regexp_match() Open

Difficulty 4/5 3-5 days Newbie friendliness 35/100

darold/ora2pg#1948 · Opened Jan 9, 2026
using ora2pg with AWS DMS Open

Difficulty 5/5 Over a week Newbie friendliness 25/100

darold/ora2pg#1946 · 2 comments · Opened Dec 6, 2025
Issues for partitions and subpartitions migration Open

Difficulty 4/5 3-5 days Newbie friendliness 35/100

darold/ora2pg#1940 · Opened Nov 6, 2025
TYPE CONVERSION: FLOAT(126) being converted to DOUBLE PRECISION(126) Open

Difficulty 2/5 1-3 hours Newbie friendliness 55/100

darold/ora2pg#1934 · Opened Oct 2, 2025
Add configuration parameter for the delimiter if PACKAGE_AS_SCHEMA is set to 0 Open

Difficulty 2/5 1-3 hours Newbie friendliness 45/100

darold/ora2pg#1933 · Opened Oct 1, 2025
Ora2Pg CREATE index queries conversion Open

Difficulty 4/5 3-5 days Newbie friendliness 25/100

darold/ora2pg#1928 · 1 comment · Opened Sep 4, 2025
Issue when transfer a package with procedure definition in function definition Open

Difficulty 4/5 3-5 days Newbie friendliness 28/100

darold/ora2pg#1924 · 2 comments · Opened Aug 18, 2025
export mysql schema; dbname/schema name contains - ; i.e. myapp-backup Open

Difficulty 3/5 1-2 days Newbie friendliness 35/100

darold/ora2pg#1922 · Opened Aug 12, 2025
Export data Limitation issue Open

Difficulty 5/5 Over a week Newbie friendliness 20/100

darold/ora2pg#1921 · 1 comment · Opened Aug 11, 2025
IMPORT configuration causes "Can't call method 'logit'" error in Ora2Pg v25.0 Open

Difficulty 3/5 1-2 days Newbie friendliness 38/100

darold/ora2pg#1919 · 3 comments · Opened Jul 17, 2025
COPY type with PG_DSN still outputs the setup on output.sql Open

Difficulty 3/5 1-2 days Newbie friendliness 48/100

darold/ora2pg#1918 · Opened Jul 11, 2025
Wrong conversion of Oracle procedure with PRAGMA AUTONOMOUS_TRANSACTION to PG procedure with AUTONOMOUS_TRANSACTION and PG_BACKGROUND active Open

Difficulty 4/5 3-5 days Newbie friendliness 30/100

darold/ora2pg#1917 · Opened Jul 7, 2025
Request to suggest on ora2pg upgrade from version: 23.1 to a stable version Open

Difficulty 5/5 Over a week Newbie friendliness 15/100

darold/ora2pg#1916 · 1 comment · Opened Jul 1, 2025
ora2pg incompatible with Oracle 8i 8.1.7.4.0 Open

Difficulty 2/5 1-3 hours Newbie friendliness 52/100

darold/ora2pg#1914 · 1 comment · Opened Jun 23, 2025
DBD::Oracle Open

Difficulty 4/5 3-5 days Newbie friendliness 25/100

darold/ora2pg#1909 · 1 comment · Opened Jun 19, 2025
ora2pg hangs on "inspecting object". Open

Difficulty 4/5 3-5 days Newbie friendliness 25/100

darold/ora2pg#1902 · Opened Jun 4, 2025
How to use Query Type? Open

Difficulty 3/5 1-2 days Newbie friendliness 35/100

darold/ora2pg#1898 · 2 comments · Opened May 26, 2025
lo_import roll back issues Open

Difficulty 5/5 Over a week Newbie friendliness 20/100

darold/ora2pg#1897 · Opened May 20, 2025
ora2pg is not exporting sequence schema? Open

Difficulty 3/5 1-2 days Newbie friendliness 42/100

darold/ora2pg#1896 · Opened May 15, 2025
Rows with geometry data seems to be truncated in psql dump file. Open

Difficulty 4/5 3-5 days Newbie friendliness 35/100

darold/ora2pg#1895 · 2 comments · Opened May 9, 2025
DATA_TYPE mapping not working for date(n) Open

Difficulty 3/5 1-2 days Newbie friendliness 48/100

darold/ora2pg#1894 · Opened May 2, 2025
FORCE_IDENTITY_BIGINT not working Open

Difficulty 4/5 3-5 days Newbie friendliness 35/100

darold/ora2pg#1892 · Opened Apr 28, 2025
[ora2pg - 24.3] Oracle source DB TEST_DATA with PARALLEL_TABLES > 1: ORA-03113: end-of-file on communication channel Open

Difficulty 4/5 3-5 days Newbie friendliness 45/100

darold/ora2pg#1890 · 2 comments · Opened Apr 14, 2025
DROP_FKEY not working Open

Difficulty 4/5 3-5 days Newbie friendliness 35/100

darold/ora2pg#1886 · 2 comments · Opened Apr 7, 2025
How to achieve CDC using ora2pg Open

Difficulty 4/5 3-5 days Newbie friendliness 25/100

darold/ora2pg#1866 · 1 comment · Opened Feb 25, 2025
How to add enhanced logging to include detailed progress, performance, and error handling Open

Difficulty 5/5 Over a week Newbie friendliness 25/100

darold/ora2pg#1864 · 1 comment · Opened Feb 20, 2025
Support DEFAULT ON NULL for Oracle to PostgreSQL. Open

Difficulty 4/5 3-5 days Newbie friendliness 35/100

darold/ora2pg#1859 · Opened Feb 3, 2025
OUT parameters are not converted in EXECUTE command Open

Difficulty 4/5 3-5 days Newbie friendliness 35/100

darold/ora2pg#1855 · 4 comments · Opened Jan 17, 2025
COPY DATA from Oracle to Postgres empty logfile Open

Difficulty 4/5 3-5 days Newbie friendliness 25/100

darold/ora2pg#1853 · 1 comment · Opened Jan 14, 2025
FATAL: The access token has expired. Please acquire a new token and retry Open

Difficulty 4/5 3-5 days Newbie friendliness 35/100

darold/ora2pg#1851 · 1 comment · Opened Jan 10, 2025

darold/ora2pg

Get new issues in your inbox