Link to home
Create AccountLog in
Avatar of Perherman
Perherman

asked on

How to purge database

I have reached my 4GB limit on the XE database, and when I try to delete data from a table I get error messages about the limit of 4GB.

I have now dropped several schemas, but the limit is still exceeded.

How do I purge the database to release the space previously held by the other schemas?

At the moment I can)t even drop a table, or empty a table without getting the error message:

ORA-12952: The request exceeds the maximum allowed database size of 4 GB

Thanks for help,

Per-Olof
ASKER CERTIFIED SOLUTION
Avatar of schwertner
schwertner
Flag of Antarctica image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of Perherman
Perherman

ASKER

It seems that I dont have the latest version of XE on the computer, the version no is 2.1.0.00.05 on the Screen, but I in my local documentation it says that I can only look at the tablespaces and how much space they have used, there is no mention of compacting or any of that which is written in the documentation that I see when I follow you link.

Should I upgrade the version to the new XE?
There is no link to any tasks for example...
The version of the database is  Oracle Database 10g Express Edition Release 10.2.0.1.0 - Beta
Hello,
definitelly you have  to use the latest version of Oracle XE.
The Starter versions are not completete and also have more then enough bugs.