Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Deleted rows reappear after 30 mins! Help
Hi,
I know this is trivial but did you have committed the statement ?
Ciao
Matze
On 1 May 1999 08:09:06 -0500, ramdan_at_mailexcite.com (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?!?!?!
Received on Wed May 05 1999 - 03:26:48 CDT