RE: Query Fails for particular date

From: D'Hooge Freek <Freek.DHooge_at_uptime.be>
Date: Tue, 21 Jul 2009 22:21:52 +0200
Message-ID: <4814386347E41145AAE79139EAA398980C71FCD9C3_at_ws03-exch07.iconos.be>

my first thought would be a corrupt block. Did you run dbverify on the datafile(s) in which the table is existing?

regards,

Freek D'Hooge
Uptime
Oracle Database Administrator
e-mail: freek.dhooge_at_uptime.be
tel. +32 (0)3 451 23 82
http://www.uptime.be
disclaimer

From: oracle-l-bounce_at_freelists.org [oracle-l-bounce_at_freelists.org] On Behalf Of Nagaraj S [nagaraj.chk_at_gmail.com] Sent: 21 July 2009 19:39
To: oracle-l
Subject: 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
--

http://www.freelists.org/webpage/oracle-l Received on Tue Jul 21 2009 - 15:21:52 CDT