> 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
