[Spacewalk-list] Database full

[Evan Frey]

That worked perfectly, thanks!  Also it got my boss to consider 
purchasing a full license for Oracle.  Are there any guides for 
migrating spacewalk from oracle xe to oracle standard?


On Fri, Mar 11, 2011 at 3:30 AM, Sander Grendelman wrote:

> On Thu, Mar 10, 2011 at 03:51:47PM -0500, Evan Frey wrote:
>> I recently had my database hit the 5G wall.  I deleted 5000+ 
>> packages,  12 channels, 6 kickstart and 6 distro trees but do not see 
>> the space  reclaimed.  Is there something I need to do (besides 
>> compacting the  database which has not worked) to true up my 
>> database?
>>
>
> You might want to try the "alter table <table> shrink space" command 
> on
> some large tables, you probably have to enable row movement first.
>
> It's probably a good idea to make a back-up before attempting this.
>
> Another option would be to do an export-import of your data.
>
> * Export your spacewalk tablespace.
> * Remove oracle XE and it's databases completely.
> * (Re)install oracle XE.
> * Import your spacewalk tablespace.
>
> Or you could cough up some money to oracle and use a standard edition
> one DB: http://www.oracle.com/us/products/database/std-one/index.html
>
> Regards,
>
> Sander Grendelman.
>
> _______________________________________________
> Spacewalk-list mailing list
> Spacewalk-list at redhat.com
> https://www.redhat.com/mailman/listinfo/spacewalk-list