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

From: duc hiep ha <haduchiep(at)googlemail(dot)com>
To: Luca Ferrari <fluca1978(at)gmail(dot)com>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: ora2pg -c ora2pg.conf -t COPY -a tablename not working properly
Date: 2023-08-25 15:49:06
Message-ID: CAM2ukh+p_rSSrfnOrERyk2SKWcmx5Kz5NT3DrZZZkGToQXPQFA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)gmail(dot)com> đã
viết:

> On Thu, Aug 24, 2023 at 6:19 PM duc hiep ha <haduchiep(at)googlemail(dot)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?
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ron 2023-08-25 19:30:35 Re: Will PostgreSQL 16 supports native transparent data encryption ?
Previous Message Dominique Devienne 2023-08-25 15:19:32 Re: LDAP Authentication