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...
Hi Darold, We are currently performing our migration in two phases: first for non-BLOB tables and then for BLOB tables, by specifying tables in the ALLOW parameter of the configuration...
Hi Darold, We are facing below error, please help us on this. 1) psql:/backend/migration/scripts/blob/procedure.sql:75: ERROR: syntax error at or near "," LINE 20: SELECT EXTRACT[kpacDraft, '//@Contact'].getClobVal()... As i observered In...
Hi Darold we are facing the below error, please help on this part 1)ERROR: unexpected end of function definition at end of input LINE 6: $BODY$ syntax ------- ``` CREATE...
Hi Gilles, I've got 98% columns of type NUMBER(1) in oracle to be used as boolean representatives (1:0), So I used REPLACE_AS_BOOLEAN NUMBER:1 which worked as expected, Some columns are...
I am getting a below error only for this project while all the other exports / imports are working fine. I checked the permission is correct. ERROR: project directory '/home/team/proj_user'...
DBD::pg:: db pg_putcopyend failed :ERROR: invalid byte sequence for encoding "UTF8": 0x00vg : 11 recs/sec Context: copy content, line 1 at /usr/local/share/perl5/Ora2pg.pm line 16849 FATAL : ERROR : invalid byte...
Hi everyone, I'm taking my first steps with this amazing tool. I'm trying to migrate an Oracle old database (of an old OTRS 5 instance). In this old database, that...
When `CREATE_SCHEMA` config is disabled, the sequence export still tries to create the schema, resulting in a permission failure if the Postgres user can't create the schema. This is an...
Description: I configured two directives in ora2pg: ` DEBUG 1 LOGFILE .../log/LOGFILE ora2pg_job_$(date +%Y%m%d_%H%M%S).log ` I expected the log files to be saved with a unique timestamp, such as ora2pg_job_20230220_142300.log....
i use follow command: ora2pg -c config/ora2pg.conf -t INSERT When I checked the data, I found that the bool values of 1 and 0 in mssql were changed to t...
