ora2pg

ora2pg copied to clipboard

Adaptive data_limit

1

Hello, I suggest a enhanced behavior by adding an adaptive data limit parameter. In my last migration, I had many big tables but some of them had the avg_row_len at...

chmanu

DBLinks and oracle_fdw

2

In Oracle a have View to access to other table via dblink. ``` CREATE OR REPLACE FORCE VIEW BLANKS_V ( BLANK_ID, BLANK_SERIES, BLANK_NUMBER, BLANK_TYPE_ID, OLD_BLANK_STATUS, NEW_BLANK_STATUS, CHANGE_DATE, CONTRACT_NUMBER, RECORD_DATE, OPER_TYPE,...

denoley

Issue with sequence id/FK constraint during table load

3

Hello, I am seeing a lot of these errors when trying to load data. $ psql ph_tst01 < CREDENTIAL***_data.sql SET SET SET ERROR: cannot truncate a table referenced in a...

skizilbash

Sequences not exporting from MYSQL due to regression

1

Hi Team, I observed that after a recent commit, sequences are not getting exported properly for MYSQL. Earlier `int auto_increment` used to export as `serial` Now its getting exported as...

shubham-yb

DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(p1sp0) a' at line 1 at /usr/local/share/perl5/Ora2Pg.pm line 14662

3

I have a MySQL database that has a variety of table partitioning defined(including subpartitions). When I am trying to export data it is failing because of subpartitions present in the...

sanyamsinghal

Hi Seniors, We are trying to migrate data from Oracle database where a column in a table is a user defined datatype which intern points to type as table. While...

elangodba

NULL_EQUAL_EMPTY generates invalid code

1

The null_equal_empty configuration currently generates invalid code if the argument is a number. some_dbk is not null gets translated to (some_dbk and some_dbk::text '') This give the error that a...

duursma

Option TEST_DATA doesn't work

2

Hi ! I use ora2pg v23.0 to migrate an Oracle database (11.2.0.3) to a PostgreSQL database (11) ; it works but when i try to use "TEST_DATA" option, i have...

cyberioio

Wrong conversion of data from Oralce XMLTYPE to postgres XML by ora2pg

1

Good morning Mr Darold, I hereby inform you because in the conversion of a procedure within a package from oracle to pg via ora2pg, the type of variable/input parameter XMLTYPE(Oracle)...

RuiFilipeGoncalvesPereira

Hi folks, I have a set of polygons inside a oracle table which represent circles. I am trying to import these into postgres 12 using ora2pg. The circle is represented...

riccardoklinger