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)
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
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
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
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
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
As you wrote we have about 400/500 partitions in real life. So time problem is
much smaller, but still it is and in one place of aur application we have
decided to help DB and we're indicating in query exact partition we need. What
pushed me to do this test? Just curiosity I think. After I saw