Query Fails for particular date

From: Nagaraj S <nagaraj.chk_at_gmail.com>
Date: Tue, 21 Jul 2009 23:09:36 +0530
Message-ID: <e921f8570907211039o30eabc08x2faff32158f16d52_at_mail.gmail.com>

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.



http://www.freelists.org/webpage/oracle-l Received on Tue Jul 21 2009 - 12:39:36 CDT

Original text of this message