[Spacewalk-list] Spacewalk + Oracle XE =>ORA-12952: The request exceeds the maximum allowed database size of 4 GB

[Santi Saez]

Hi!

We're getting continuously this error via mail:

SQL Error generated: (12952, 'ORA-12952: The request exceeds the maximum 
allowed database size of 4 GB\nORA-06512: at "SPACEWALK.RHN_SERVER", 
line 231\nORA-06512: at line 1\n')

What can I do to solve this? Any tips to purge/compact XE database?

root at spacewalk:~
# du -sh /usr/lib/oracle/xe/oradata/XE/*
3,7M    /usr/lib/oracle/xe/oradata/XE/control.dbf
571M    /usr/lib/oracle/xe/oradata/XE/sysaux.dbf
361M    /usr/lib/oracle/xe/oradata/XE/system.dbf
149M    /usr/lib/oracle/xe/oradata/XE/temp.dbf
501M    /usr/lib/oracle/xe/oradata/XE/undo.dbf
4,1G    /usr/lib/oracle/xe/oradata/XE/users.dbf

I can't register new clients.. thanks!!

Regards,

-- 
Santi Saez
http://woop.es