Query Fails for particular date

  • From: Nagaraj S <nagaraj.chk@xxxxxxxxx>
  • To: oracle-l <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 21 Jul 2009 23:09:36 +0530

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.


Other related posts: