Deleting from sys.aud$

From: GaryA <garyinri_at_yahoo.com>
Date: Wed, 23 Dec 2009 08:13:16 -0800 (PST)
Message-ID: <d018d6e7-f7a6-4951-bfdd-3345566ae2cf_at_c34g2000yqn.googlegroups.com>

Hoping someone can explain why I am running into the issue seen below. I do a select count(*) from sys.aud$ and get one number, but when I do a delete using the same where condition I get a substantially different number of records to be deleted.

---

SQL> select count(*) from sys.aud$ where userid = 'MIKE1';

  COUNT(*)

---

     33570

SQL> delete from sys.aud$ where userid = 'MIKE1';

2 rows deleted.

SQL> rollback work;

Rollback complete.

SQL> select count(*) from sys.aud$;

  COUNT(*)

---

    147042

SQL> delete from sys.aud$;

12154 rows deleted.

SQL> rollback work;

Rollback complete.

---

Can anyone offer a reason as to why I am seeing such differing results?

Thank you.
Gary Received on Wed Dec 23 2009 - 10:13:16 CST