data corruption

From: helter skelter <helterskelter_at_gmail.com>
Date: Tue, 21 Jul 2009 09:46:37 +0200
Message-ID: <h43san$48i$1_at_mx1.internetia.pl>

Hi, I've got some strange situation:

desc table_1;

trans_id	number
load_time	timestamp(6) nullable

select trans_id, load_time
from table_1
where trans_id in (133,167,199);

trans_id load_time
133
167
199

select trans_id, load_time
from table_1
where trans_id in (133,167,199);
and load_time is null

trans_id load_time
133

...something wrong, so I tried:

select trans_id, to_char(load_time)
from table_1
where trans_id in (133,167,199);

trans_id load_time
133

167		77/08/07 08:51:00,000000
199		77/07/17 12:51:00,000000

Additionally:

select trans_id, to_char(load_time,'DD-MM-YYYY') from table_1
where trans_id in (133,167,199);

ORA-01877: string is too long for internal buffer

But:
select trans_id, to_char(load_time,'DD-MM') from table_1
where trans_id in (133,167,199);

trans_id load_time
133

167		07-08
199		17-07

Can somebody tell me what is going on ? :)

I've checked tablespace with rman 'valiadte backup check logical tablespace ...' and there is no block corruption in v$database_block_corruption, no other errors in alert_log

oracle 10.2.0.4, rhel5

thanks Received on Tue Jul 21 2009 - 02:46:37 CDT