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)
FLOA
On 8/13/19 10:34 AM, Daulat Ram wrote:
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
-
On Tue, Aug 13, 2019 at 10:23 AM Daulat Ram 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 9000.
Apparently this is an oracle problem because it acceppted data longer
than its type, so my guess would
Hi team ,
I am getting the below error while fetching the data from Oracle 12c using
ora2pg.
DBD::Oracle::st fetchall_arrayref failed: ORA-24345: A Truncation or null fetch
error occurred (DBD SUCCESS_WITH_INFO: OCIStmtFetch, LongReadLen too small
and/or LongTruncOk not set)ERROR no statement e
On Mon, Aug 12, 2019 at 5:03 PM Luís Roberto Weck
mailto:luisrobe...@siscobra.com.br>> wrote:
If you modify last_user_event_2 to select user and event info in
the view, and just put there where clause directly on the view
which is not joined to anything, instead of on the "extra cop
Hi.
Just a short message, confirming that after we've altered the tables to have
matching
types, deletes now take 1 ms, instead of 5 sec. Indexes are being used now.
Thanks for assistance.
Regards
Kristian
ps. would be nice with some warnings or indications in analyze output when this
happens
On Tue, Aug 13, 2019 at 8:46 AM Thomas Kellerer wrote:
> I stumbled across this question on SO:
> https://stackoverflow.com/questions/56517852
>
> Disregarding the part about Postgres 9.3, the example for Postgres 11
> looks a bit confusing.
>
> There is a script to setup test data in that questi
