| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Deleted rows reappear after 30 mins! Help
A copy of this was sent to ramdan_at_mailexcite.com (ramdan)
(if that email address didn't require changing)
On 1 May 1999 08:09:06 -0500, you 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?!?!?!
Someone/something else has access to the tables. Either enable auditing to see who is inserting/updating/deleting the table or code up an auditing trigger that save who did what and when.
Rows do not 'come back' by themselves -- nor do they disappear by themselves. something else is as work here.
Thomas Kyte
tkyte_at_us.oracle.com
Oracle Service Industries
Reston, VA USA
--
http://govt.us.oracle.com/ -- downloadable utilities
 |
 |