Re: Strange ROWID problem

If I follow this, you have multiple copies of the same rowid - not to mention multiple same primary keys. Must be corruption.

Select rowid, count(*)
from mytable
group by rowid
having count(*) > 1;
This should always produce no rows. Ditto for PK.

This might be a long shot but if you suspect the
"<" operator with rowid, try ROWIDTOCHAR or similar.
Does it behave the same?

Check if you have anlayze table validate structure in v7...

Perhaps the easiest fix is to open a pl/sql cursor to fetch by rowid then delete any found after the first occurance of each, but this is too weird. It shouldn't happen. Steve
--
"The floggings will continue until morale improves."
Received on Mon Jul 13 1998 - 17:08:05 CDT