Search Postgresql Archives

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

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

 



Yes i can access the target table on Postgres, because i have to create it as strukture on the posgres before transfer data. Actually in the past i have done it successfully many time. The Problem here is some thing happened in between in my computer, or there is a bug on Ora2pg.

Vào Th 5, 24 thg 8, 2023 vào lúc 23:34 Erik Wienhold <ewie@xxxxxxxxx> đã viết:
> On 24/08/2023 15:49 CEST duc hiep ha <haduchiep@xxxxxxxxxxxxxx> wrote:
>
> Further updated to the below Post. Shortly question:
>   * Saving data to file using the following Command is fine:
>     ora2pg -c ora2pg.conf -t COPY -o data.sql schema/data/
>   * Direct copy data from Oracle to Postgres doesn't work
>     (command: ora2pg -c ora2pg.conf -t COPY -a tablename).
>     Everything Else works fine. Connection to Oracle and Postgres using
>     DBD::Pg, DBD::Oracle are set correctly.

Can you access table "tablename" when connecting with Postgres via psql and
the connection settings from ora2pg.conf?  Maybe privileges are missing or
the table is not on the search path.

--
Erik

[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