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
prashanthgs
Messages: 89
Registered: May 2005
Location: chennai
Member
Hi,

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 : 10.2.0.4
OS : AIX

Thanks and Regards,
Prashanth



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: Thu Dec 08 16:05:52 CST 2016

Total time taken to generate the page: 0.09482 seconds