ora2pg
ora2pg copied to clipboard
darold
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 generate...
Good Evening Mr Darold, I hereby get in touch because I detected an error in the conversion of the Rownum clause, inside a package, from Oracle to Postgres, as visible...
The table structure of the Oracle database is as follows: ``` CREATE TABLE "SDE"."MARKET_GRID" ( "OBJECTID" NUMBER NOT NULL, "ttt" NVARCHAR2(10), "tttt" NVARCHAR2(50), "TOTAL_VALUE" NUMBER(19,8), "VALUE_DENSITY" NUMBER(19,8), "VALUE_PROPORTION" NUMBER(19,8), "TOTAL_VALUE_SCORE"...
In Ora2PG::GEOM::createPoint the line: `$self->logit("ERROR: SDO_ELEM_INFO for Point starting offset $sOffset inconsistent with ordinates length " . ($#{$coords} + 1));` is triggered regulary because the sOffset is tested against the...
On converting geometries from srid to epsg is seems that the correct epsg is found, but when using INTERNAL to convert, the conversion takes the srid from the geometry object...
Good evening Mr.Darold. We want to improve the following about ORa2pg. * Problem Ora2Pg doesn't convert objects containing "$". If there is an object containing "$", additional work such as...
I've tried several attempts installing and it always fails on other parts than Ora2pg itself. I've found a year old project which I will try next, but it would be...
I have a geometry collection consisting of a polygon followed by a linestring MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1,179,2,1) On conversion of the polygon the linestring is 'added' as a 'linear ring' as a result...
It detects 4 partitions but could not export DDLs for them and continues I am using the export_schema.sh script which comes with the standard ora2pg project. ``` [root@ip-10-9-80-202 sakila]# ./export_schema.sh...
I am getting this error `WARNING: an error occurs during data export. Please check what's happen.` with MySQL only during data export. This is not consistently reproducible, it occurs occasionally...
FATAL: file C:\ora2pg\ora2pg.conf.dist does not exists. occurs on window platform, v23.0 & 23.1 issue is code has been changed to install file C:\ora2pg\ora2pg_conf.dist on windows, but is not reflected in...
