RE: Query Fails for particular date

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@xxxxxxxxx
tel. +32 (0)3 451 23 82
http://www.uptime.be
disclaimer


From: oracle-l-bounce@xxxxxxxxxxxxx [oracle-l-bounce@xxxxxxxxxxxxx] On Behalf 
Of Nagaraj S [nagaraj.chk@xxxxxxxxx]
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

Other related posts: