ora2pg -c ora2pg.conf -t COPY -a tablename not working properly

From: duc hiep ha <haduchiep(at)googlemail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: ora2pg -c ora2pg.conf -t COPY -a tablename not working properly
Date: 2023-08-24 09:52:50
Message-ID: CAM2ukhKfDfJpPPAtNOKdEcrDKr_d3uFEcDcB9gAEORnxyrcySw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello Friends,
i have an very strange issue that i have tried to fix in hours but couldn't
solve it. Could you please help me this case:

- I have installed ora2pg to migrate oracle table to postgres,
everything was working fine for several projects before
- recently i started a new project to mingrate tables from oracle to
postgres again in the same computer, and i did the same process as the
previous projects.
But when i copy the data from oracle table to postgres tabe by
following command, it doesn't work properly:
ora2pg -c ora2pg.conf -t COPY -a tablename
no data have been transfered to postgres. it shows: 0/0 tables(100%) end
of scanning.
- connection to both database is correct.
- The tables are existing on source and on target( structure table
)...
- i can create table structure from this config file

I have tried to fix it, but it didn't work, here are what i did:

1. try to install ora2pg again -> not work
2. try to transfer others tables -> have the same issue
3. try to install ora2pg on other computer -> everything works fine
4. Only one case when i transfered data to this table, it works but very
only some rows not all, not exactly what i want to transfer. Maybe this
data is stored on the Cachmemory not really from the source table...

Here ist my config file:

ORACLE_HOME C:\Oracle\product\12.2.0\client_1

ORACLE_DSN dbi:Oracle:host=xxx;sid=xx;port=1521

ORACLE_USER system

ORACLE_PWD xxx

SCHEMA Schemaname

ALLOW TZV_DATA

TYPE TABLE

PG_DSN dbi:Pg:dbname=xxxx;host=xxx;port=5432

PG_USER schemaname

PG_PWD xxx

LOG_ON_ERROR 1

STOP_ON_ERROR 0

could you please recommend me the possible causes of this? it is possible,
that perl does't work properly or in this computer has some other software
running, which prevent this transfer....?. or something else that I really
dont understand what happended

Thank you for you help in advance

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Luca Ferrari 2023-08-24 12:00:28 Re: ora2pg -c ora2pg.conf -t COPY -a tablename not working properly
Previous Message Dominique Devienne 2023-08-24 09:44:28 Re: Read only user permission