ORA-01801: date format is too long for internal buffer

Hi all,

a query used to return 1248 records from 3 GB subPartitioned table, is return only few records and then broke with ORA-01801.

I checked the out put and saw that the column VON_ZT (DATE FORMAT) NOT NULL is a part of multi columns primary key, but the out put of this column is not in date format and some of them without data.

select * from table

where firma = '03'

   and datum >= trunc(sysdate, 'year') + 29

   and filiale = 3798;

FI

FILIALE DATUM

PERIOD TK

ABT_NR PE VON_ZT

BIS_ZT

WERT ERST_DATZ

-- ---------- --------- ------ -- ---------- -- --------- --------- ---------- ---------