Oracle Database Discussions

Using Oracle 10gR2 RAC +ASM (10.2.0.3) on SUSE Enterprise Linux Server 9 (x86_64).

I've issued the following commands:

DELETE FROM TRACE.TBA SUBPARTITION(YEAR_2007_MONTH_1);
DELETE FROM TRACE.TBA SUBPARTITION(YEAR_2007_MONTH_2);
DELETE FROM TRACE.TBA SUBPARTITION(YEAR_2007_MONTH_3);
DELETE FROM TRACE.TBA SUBPARTITION(YEAR_2007_MONTH_4);
DELETE FROM TRACE.TBA SUBPARTITION(YEAR_2007_MONTH_5);
DELETE FROM TRACE.TBA SUBPARTITION(YEAR_2007_MONTH_6);
DELETE FROM TRACE.TBA SUBPARTITION(YEAR_2007_MONTH_7);
DELETE FROM TRACE.TBA SUBPARTITION(YEAR_2007_MONTH_8);
DELETE FROM TRACE.TBA SUBPARTITION(YEAR_2007_MONTH_9);
DELETE FROM TRACE.TBA SUBPARTITION(YEAR_2007_MONTH_10);

COMMIT;

SELECT COUNT(1) FROM TRACE.TBA T WHERE T.YEAR = 2007 AND T.PERIOD = 4;

With the following Results (Similar results shown):
0 rows deleted.
0 rows deleted.
75556 rows deleted.
77428 rows deleted.
0 rows deleted.
149160 rows deleted.
156654 rows deleted.
153182 rows deleted.
158502 rows deleted.
Commit complete.

COUNT(1)
----------
75343


1 row selected.

The problem is with SUBPARTITION(YEAR_2007_MONTH_4). This partition won't delete.
I've also experienced this problem with the same table in the another partition.

What could be the problem? Oracle doesn't report any errors.

Thanks,
(BLL)