ORA-08103 : object no longer exists

From: <hpcheong_at_my-dejanews.com>
Date: Fri, 14 Aug 1998 04:50:40 GMT
Message-ID: <6r0fn0$57d$1@nnrp1.dejanews.com>

when i try to do a select statement with condition. eg.
select xxx from tableA where yyy=yyy and zzz=zzz.

it will throw ora-08103-- object no longer exists.

tableA has got 1200 record and only 23 record is affected is the command is issue.

BUT if we do the query separately, it's ok.

what i have done is i do an export, drop the table and re-import it back. UNSUCESSFUL!

then i drop the indexes corncerning the two column and rebuild it back again on the same tablespace (UNSUCESSFUL) as well as a different tablespace (STILL UNSUCESSFUL).

i realise that if the indexes to this two column is dropped, the syntax can be issue but when the indexes is back, the error occurs again.

please help...it's urgent!

thanks a lot!

rgds,
evelyn

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Thu Aug 13 1998 - 23:50:40 CDT