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-24 16:19:18 |
Message-ID: | CAM2ukhLtUd5crRs3=akmOAw9e0YTvg333RUTDpv7johDruYGBg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Thanks for you idea, here is the log file when i used -d flag:
D:\ora2pg\hans>ora2pg -c ora2pg.conf -t COPY -a codes1 -d
WARNING: target PostgreSQL version must be set in PG_VERSION configuration
directive. Using default: 11
[2023-08-24 18:07:13] Ora2Pg version: 24.0
[2023-08-24 18:07:13] Export type: COPY
[2023-08-24 18:07:13] Geometry export type: INTERNAL
[2023-08-24 18:07:13] ORACLE_HOME = C:\Oracle\product\12.2.0\client_1
[2023-08-24 18:07:13] NLS_LANG = AMERICAN_AMERICA.AL32UTF8
[2023-08-24 18:07:13] NLS_NCHAR = AL32UTF8
[2023-08-24 18:07:13] Trying to connect to database: dbi:Oracle:host=xx.xx
;sid=xx.xx;port=1521
[2023-08-24 18:07:14] Isolation level: SET TRANSACTION ISOLATION LEVEL READ
COMMITTED
[2023-08-24 18:07:14] Force Oracle to compile schema HANS before code
extraction
[2023-08-24 18:07:14] Retrieving table information...
[2023-08-24 18:07:14] Collecting 0 tables in DBA_OBJECTS took: 0 wallclock
secs ( 0.00 usr + 0.02 sys = 0.02 CPU)
[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)
[2023-08-24 18:07:14] ORACLE_HOME = C:\Oracle\product\12.2.0\client_1
[2023-08-24 18:07:14] NLS_LANG = AMERICAN_AMERICA.AL32UTF8
[2023-08-24 18:07:14] NLS_NCHAR = AL32UTF8
[2023-08-24 18:07:14] Trying to connect to database:
dbi:Oracle:host=xx.xx;sid=xx.xx;port=1521
[2023-08-24 18:07:14] Isolation level: SET TRANSACTION ISOLATION LEVEL READ
COMMITTED
[2023-08-24 18:07:14] Retrieving partitions information...
[2023-08-24 18:07:14] Collecting 0 indexes in DBA_INDEXES took: 0
wallclock secs ( 0.00 usr + 0.00 sys = 0.00 CPU)
[2023-08-24 18:07:15] Total time to export data from 0 tables (0
partitions, 0 sub-partitions) and 0 total rows: 1 wallclock secs ( 0.00
usr + 0.02 sys = 0.02 CPU)
[2023-08-24 18:07:15] Fixing function calls in output files...
it was collecting 0 tables, i don't see the connection part to Posgrest
database
maybe do you see some thing strange here?
the output without -d flag:
D:\ora2pg\hans>ora2pg -c ora2pg.conf -t COPY -a codes1
WARNING: target PostgreSQL version must be set in PG_VERSION configuration
directive. Using default: 11
[========================>] 0/0 tables (100.0%) end of scanning.
Fixing function calls in output files...
Thanks
Hans
Vào Th 5, 24 thg 8, 2023 vào lúc 22:55 Luca Ferrari <fluca1978(at)gmail(dot)com>
đã viết:
> On Thu, Aug 24, 2023 at 3:49 PM duc hiep ha <haduchiep(at)googlemail(dot)com>
> wrote:
> >
> > do i have to completely delete the Ora2pg and install it again!? or some
> other softaware running on the computer have prevented this transfer's
> process.
>
> I don't think so.
> Does the -d flag helps in finding out the problem?
>
> Luca
>
From | Date | Subject | |
---|---|---|---|
Next Message | Erik Wienhold | 2023-08-24 16:34:25 | Re: ora2pg -c ora2pg.conf -t COPY -a tablename not working properly |
Previous Message | Luca Ferrari | 2023-08-24 15:55:09 | Re: ora2pg -c ora2pg.conf -t COPY -a tablename not working properly |