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...
ora2pg -b /root/oracle2pg -d -c ora2pg_oracle.conf FATAL: _column_info() ORA-00904: "ST_SRID": invalid identifier (DBD ERROR: error possibly near indicator at char 7 in 'SELECT ST_SRID(c.SHAPE) FROM GIS.YIJILU c') DBI::db=HASH(0x1013c80)->disconnect invalidates 2...
FATAL: _column_info() ORA-00942: table or view does not exist (DBD ERROR: error possibly near indicator at char 49 in 'SELECT sdo_cs.map_oracle_srid_to_epsg(SRID) FROM DBA_SDO_GEOM_METADATA WHERE TABLE_NAME=:p1 AND COLUMN_NAME=:p2 AND OWNER=:p3') DBI::db=HASH(0x24ea320)->disconnect...
Hi, I'm working on migration of Oracle database to PostgreSQL using ora2pg on Windows server environnement. I want to copy a table "COMPTE" with 4 hash partitions "SYS_P421", "SYS_P422","SYS_P423" and...
Hi Darold, i have a bug from trigger convert (idk if it will affect others) Here's my Oracle Trigger - 1 ``` create or replace trigger "TDB_IBON_DTL" before delete on...
Hello, I was experiencing a problem when using WKT format export from Oracle, that I solved modifying the code of the file Ora2Pg.pm . The problem I think was caused...
We have two databases on the source Oracle server and we are trying to migrate from Oracle to Postgres using ora2pg. The two databases had the same tablespaces in Oracle...
Hello, what is he swearing at, how can I solve it, I have a solution, it is interrupted on this pole 
In my MySQL database, a partition table definition like: ``` mysql> show create table range_test; +------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Table | Create Table | +------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | range_test | CREATE TABLE `range_test` (...
In Ora2pg EXPORT_INVALID is by default disable and only export or convert objects that is VALID in Oracle. For Trigger, we have following conditions in the code, that fetch Trigger...
Hello, We have an issue in our data from Oracle database using ora2pg (v24.1 [edit]reproduced also on the 24.2[/edit]). We are currently using PG v14.8. We found that data stored...
