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]

 



> 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