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,
and b.ps_dat_org = '18-AUG-07';
from sysadm.sysadm_paymen_teac a, sysadm.sysadm_paymen_recb
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.
-Naga
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Jul 21 2009 - 12:39:36 CDT