Deleted rows reappear after 30 mins! Help

From: ramdan <ramdan_at_mailexcite.com>
Date: 1 May 1999 08:09:06 -0500
Message-ID: <G1DW2.10579$ii.336135@newscene.newscene.com>

We have a table called segment_weights of following struc

segement        varchar2(50)
studyid            varchar2(50)
weight              number(4,4)

with 5000 rows.

We delete various values with:

delete from segment_weights where segment = '44' commit;

select * from segment_weights where segement = '44' returns no rows. thus rows deleted.

However 20-30 minutes later the rows reappear. There are NO triggers anywhere, and table does not have forgein keys or appears as forgein key anywhere. In addition we added 1000 rows, they were there when we checked, yet later on 50 were missing.

No one else has access to table and no process ran affecting tables. Any ideas?!?!?! Received on Sat May 01 1999 - 08:09:06 CDT