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

Report message to a moderator

Re: Release Space [message #361961 is a reply to message #361959] Fri, 28 November 2008 15:43 Go to previous message
Mahesh Rajendran
Messages: 10707
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.

Report message to a moderator

Previous Topic: Index problem after import using imp
Next Topic: account locked
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jul 05 08:14:27 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.