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: | Whole Thread | Raw Message | 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
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 |