RE: ORA-24345: A Truncation or null fetch error occurred -ora2pg

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



H,

We are using  below the ora2pg version and the data types for tables.

bash-4.2$ ora2pg -v
Ora2Pg v20.0
bash-4.2$

SQL> SELECT distinct data_type FROM dba_tab_columns WHERE owner='GBOP;

DATA_TYPE
--------------------------------------------------------------------------------
TIMESTAMP(6)
FLOAT
CLOB
NUMBER
CHAR
DATE
VARCHAR2
BLOB

SQL>

We are getting the same issue for tables which are having blob, clob and char data types.

Thanks,
Daulat

-----Original Message-----
From: Luca Ferrari <fluca1978@xxxxxxxxx> 
Sent: Tuesday, August 13, 2019 8:32 PM
To: Daulat Ram <Daulat.Ram@xxxxxxxxxxxxxxx>
Cc: pgsql-performance@xxxxxxxxxxxxxxxxxxxx; pgsql-general@xxxxxxxxxxxxxxxxxxxx
Subject: Re: ORA-24345: A Truncation or null fetch error occurred -ora2pg

On Tue, Aug 13, 2019 at 10:23 AM Daulat Ram <Daulat.Ram@xxxxxxxxxxxxxxx> wrote:
> Initially did not have LongReadLen set, so I thought this was the cause. But, I have set LongReadLen, on the db handle, equal to 90000000.

Apparently this is an oracle problem because it acceppted data longer than its type, so my guess would be that in your table you have a
char(n) column that could be enlarged before the migration.
<https://support.oracle.com/knowledge/Siebel/476591_1.html>
Hope this helps.
And please report the version of ora2pg when asking for help.

Luca




[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux