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

Other related posts: