Any suggestion on how to resolve this issue. I have tried several options:

1. COALESCED the tablespace
2. Added an additional datafile
3. Extended the maxextents to unlimited
4. and added more space to default storage.

Any assistance is appreciated.

HERE's the query thats causing the error:

select a.*
from sys.aud$ a, ops$oracle.db_lastsid b
where a.timestamp# between b.last_time and b.this_time;