RE: Query Fails for particular date

From: D'Hooge Freek <>
Date: Tue, 21 Jul 2009 22:21:52 +0200
Message-ID: <>

my first thought would be a corrupt block. Did you run dbverify on the datafile(s) in which the table is existing?


Freek D'Hooge
Oracle Database Administrator
tel. +32 (0)3 451 23 82

From: [] On Behalf Of Nagaraj S [] 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.

-- Received on Tue Jul 21 2009 - 15:21:52 CDT

Original text of this message