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