We help IT Professionals succeed at work.

How to purge database

Perherman
Perherman asked
on
9,188 Views
Last Modified: 2013-12-19
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
Comment
Watch Question

CERTIFIED EXPERT
Top Expert 2008
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Author

Commented:
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?

Author

Commented:
There is no link to any tasks for example...

Author

Commented:
The version of the database is  Oracle Database 10g Express Edition Release 10.2.0.1.0 - Beta
CERTIFIED EXPERT
Top Expert 2008

Commented:
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.
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.