Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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 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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux