• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 9085
  • Last Modified:

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
0
Perherman
Asked:
Perherman
  • 3
  • 2
1 Solution
 
schwertnerCommented:
Try this!

It is excerrpt from

http://download.oracle.com/docs/cd/B25329_01/doc/admin.102/b25107/storage.htm

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.

0
 
PerhermanAuthor 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?
0
 
PerhermanAuthor Commented:
There is no link to any tasks for example...
0
 
PerhermanAuthor Commented:
The version of the database is  Oracle Database 10g Express Edition Release 10.2.0.1.0 - Beta
0
 
schwertnerCommented:
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.
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now