HELP! Disappearing rows!?! DB corrupt?

Please help me!

We have an Oracle 7.1.1.3 workgroup server running on Novell 3.12.
A couple of weeks ago I had to shut down the instance brutally because a DML statement took over 3 hours and slowed the server down.

Since that day, from one table (100 rows, 3 cols, 2 foreign keys, no triggers) rows keep disappearing (about 2 a day).

I have recreated the table because I thought it might have suffered. The problem continued, so I revoked the right to modify that table from all users of the client software (only on client side, but the clients are pretty safe).

Has anybody out there had similar problems? Any ideas about recovery tools in case the database is corrupted?

I appreciate any ideas!

Thanks,

Till
Hamburg Received on Tue Dec 05 1995 - 00:00:00 CET