How to purge database

Posted on 2007-10-04
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,

Question by:Perherman
    LVL 47

    Accepted Solution

    Try this!

    It is excerrpt from

    Compacting Storage
    If you notice that space remaining in the database is becoming low, you can compact storage. Compacting storage attempts to recover unused fragmented free space in the database. Depending on the state of the database, compacting storage may or may not recover unused space.

    Compacting storage occurs in the background, and does not require you to take any data offline. You can continue transactions and queries against the database while the operation is in progress. You can also check the status of the operation to see when it completes.

    To compact storage:

    Access the Database Home Page.

    See "Accessing the Database Home Page" for instructions.

    Click the Administration icon, and then click the Storage icon.

    If prompted for administrator credentials, enter the SYSTEM user name and password or another administrator user name and password, and then click Login.

    The Storage page appears.

    Under Tasks, click Compact Storage.

    The Compact Storage page appears.


    Author Comment

    It seems that I dont have the latest version of XE on the computer, the version no is 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 Comment

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

    Author Comment

    The version of the database is  Oracle Database 10g Express Edition Release - Beta
    LVL 47

    Expert Comment

    definitelly you have  to use the latest version of Oracle XE.
    The Starter versions are not completete and also have more then enough bugs.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    Subquery in Oracle: Sub queries are one of advance queries in oracle. Types of advance queries: •      Sub Queries •      Hierarchical Queries •      Set Operators Sub queries are know as the query called from another query or another subquery. It can …
    Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
    Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.
    This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now