RE: Query Fails for particular date
Date: Tue, 21 Jul 2009 22:21:52 +0200
Message-ID: <4814386347E41145AAE79139EAA398980C71FCD9C3_at_ws03-exch07.iconos.be>
my first thought would be a corrupt block. Did you run dbverify on the datafile(s) in which the table is existing?
regards,
Freek D'Hooge
Uptime
Oracle Database Administrator
e-mail: freek.dhooge_at_uptime.be
tel. +32 (0)3 451 23 82
http://www.uptime.be
disclaimer
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
To: oracle-l
Subject: Query Fails for particular date
Hi Gurus,
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
Kindly advice.
-Naga
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Jul 21 2009 - 15:21:52 CDT