Postgres Pro
Downloads
Home   >   mailing lists

Re: ora2pg -c ora2pg.conf -t COPY -a tablename not working properly - Mailing list pgsql-general

From duc hiep ha
Subject Re: ora2pg -c ora2pg.conf -t COPY -a tablename not working properly
Date
Msg-id CAM2ukh+p_rSSrfnOrERyk2SKWcmx5Kz5NT3DrZZZkGToQXPQFA@mail.gmail.com
Whole thread Raw
In response to Re: ora2pg -c ora2pg.conf -t COPY -a tablename not working properly  (Luca Ferrari <fluca1978@gmail.com>)
Responses Re: ora2pg -c ora2pg.conf -t COPY -a tablename not working properly
List pgsql-general
Tree view
Hi, 

I've just found the root cause! In this command:
ora2pg -c ora2pg.conf -t COPY -a tablename
I have created and changed the name of table in postgres. It will not work like that if i don't put replace_table option in config file.

Thanks all, my case can be closed now

Best
Hans

Vào Th 6, 25 thg 8, 2023 lúc 21:53 Luca Ferrari <fluca1978@gmail.com> đã viết:
On Thu, Aug 24, 2023 at 6:19 PM duc hiep ha <haduchiep@googlemail.com> wrote:
> [2023-08-24 18:07:14] Collecting 0 tables information in DBA_TABLES took:  0 wallclock secs ( 0.00 usr +  0.00 sys =  0.00 CPU)

I suspect there is a permission problem here.
Are you really sure this same configuration works in offline mode?
What have you changed since the last time it worked?

pgsql-general by date:

Previous
From: Dominique Devienne
Date:
Subject: Re: LDAP Authentication
Next
From: Ron
Date:
Subject: Re: Will PostgreSQL 16 supports native transparent data encryption ?