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 CAM2ukhLtUd5crRs3=akmOAw9e0YTvg333RUTDpv7johDruYGBg@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
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@gmail.com> đã viết:
On Thu, Aug 24, 2023 at 3:49 PM duc hiep ha <haduchiep@googlemail.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

pgsql-general by date:

Previous
From: Luca Ferrari
Date:
Subject: Re: ora2pg -c ora2pg.conf -t COPY -a tablename not working properly
Next
From: Erik Wienhold
Date:
Subject: Re: ora2pg -c ora2pg.conf -t COPY -a tablename not working properly