Re: Deleted rows reappear after 30 mins! Help

Did you or DBA check the alert log?

ramdan wrote:

> 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?!?!?!

--

Best Regards,

Reid Lai
Oracle 7.3 Certified Database Administrator (OCP)

• The above opinions are mine and do not represent any official
• standpoints of my employer or third-party organizations.