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.
-Naga
Other related posts: