Home » RDBMS Server » Server Administration » Release Space (Oracle 10g, AIX - OS)
Release Space [message #361959] Fri, 28 November 2008 15:10 Go to next message
Messages: 89
Registered: May 2005
Location: chennai

We had a table named A with millions of rows occupying more space. We truncated the table and found that OS space - (Data file) not released after truncation of this table. Still it occupies the space.

How to release the space?

oracle version :

Thanks and Regards,

Re: Release Space [message #361961 is a reply to message #361959] Fri, 28 November 2008 15:43 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Expected behavior.
You need to resize the datafile ( if you are in dire need to get space).
Search the forum/docs/google for exact procedures.
Previous Topic: Index problem after import using imp
Next Topic: account locked
Goto Forum:

Current Time: Mon Oct 24 13:22:46 CDT 2016

Total time taken to generate the page: 0.09808 seconds