RE: Query Fails for particular date
Date: Tue, 21 Jul 2009 22:21:52 +0200
my first thought would be a corrupt block. Did you run dbverify on the datafile(s) in which the table is existing?
Oracle Database Administrator
tel. +32 (0)3 451 23 82
From: oracle-l-bounce_at_freelists.org [oracle-l-bounce_at_freelists.org] On Behalf Of Nagaraj S [nagaraj.chk_at_gmail.com]
Sent: 21 July 2009 19:39
Subject: Query Fails for particular date
We receive error ,while we run the below sql query for a particular date 18-AUG-07. We did a restore of these table partitions last month, So we are in doubt of any data corruptions. Query runs fine for all other days except for 18-AUG-07. SQL> select
......... . ............. .....
and b.ps_dat_org = '18-AUG-07';
from sysadm.sysadm_paymen_teac a, sysadm.sysadm_paymen_recb
ERROR at line 13:
ORA-08103: object no longer exists
http://www.freelists.org/webpage/oracle-l Received on Tue Jul 21 2009 - 15:21:52 CDT