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

[Miroslav Suchý]

Santi Saez wrote:
> 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!!

https://shop.oracle.com/pls/ostore/f?p=ostore:2:0::NO:RP,2:PROD_HIER_ID:4509958287721805720011
Or help us with development of PostgreSQL support.

-- 
Miroslav Suchy
Red Hat Satellite Engineering