ora2pg

ora2pg copied to clipboard

Mysql migration

1

Hi, I have been trying to use ora2pg for mysql migration Created initial configuration and template Updated ora2pg conf file with Mysql and PG DSN Export_schema.sh runs ok When I...

mgole001

geometry wrongly exported when there is a "hole" in the geometry

1

Version tested: 24.3 Example of oracle geometry:  Example of the postgreSQL geometry exported using ora2pg 24.3: 

carlos-guilherme-araujo-alb

Hi Darold, Thank you for your supporting. We're having trouble with lob tables. When we used the lo_import command to export the data, we were able to do it correctly....

guptasai675

Get `server closed the connection unexpectedly` error during COPY of oracle BLOB to postgresql bytea

1

I have 2 different database one is dev and the other one is test. While copying dev database to the same postgresql db there is no issue. but while copying...

taneraruk

When generating a new project the resulting powershell export script contains an if else more akin to bash. It should be: if ($etype -eq "TABLE") { $blob_to_lo="" } else {...

robinpringle

OUT OF MEMORY EVEN THOUGH SERVER HAS OVER 16GB FREE RAM

2

Trying to convert from a dump with over 800 tables. I have tried lowered the DATA_LIMIT all the way to 10 and it still doesn't work My server has 12...

NobleZirwaHara

Reading the ora2pg assessment report

6

Hi, Wanted to ensure i am reading the ora2pg assessment rwport correctly. Please confirm if below is accurate - 1. If the assessment report shows Procedure - Number =5, Estimated...

mgole001

[ORACLE]Slow export of BLOB and CLOB from

7

# VM specification: vCPUs 4 RAM 16 GiB # Table details: myTable size: 4 GB Blob. # Export duration: 8 hours. Max rows per second reached was 75 Command: ora2pg...

DonShamsan

Config option to override the NLS_TIMESTAMP_FORMAT or such encoding parameters used by Ora2pg

1

Hi @darold, I was wondering if there is a way to override all these default encoding parameters (mainly `NLS_TIMESTAMP_FORMAT`) ``` [centos@ip-10-9-14-120 yb-voyager]$ ora2pg -t SHOW_ENCODING -c Current encoding settings that...

priyanshi-yb

possibility to force transformation procedures to functions

4

My customer reported, so there is not possibility to ensure old behaviour of transformation procedures on modern postgres. PG_SUPPORTS_PROCEDURE is implicitly set for PostgreSQL v11+. Can be nice to have...

okbob