Home » RDBMS Server » Server Administration » Reclaiming Diskspace in Linux from Oracle tablespace after truncate table
Reclaiming Diskspace in Linux from Oracle tablespace after truncate table [message #185820] Thu, 03 August 2006 14:57 Go to next message
vsrwon
Messages: 2
Registered: August 2006
Location: LA
Junior Member
Hi Dear Guys:

I have database which has a tablespace that was growing larger in size.I checked the segments and saw one table was growing day by day(this table can be truncated, no worries about the data in it!)

Tablesize=10GB.

My diskspace where this datafile exist:

/u01 - 60GB Avail,58GB Used,300M Free 99% Used.

Now please let me know your ideas on how can we release the 10GB just by removing all rows from this table.
(This table has constraints and indexes on it and will be used for the next runs to insert fresh data)


Thanks for your time in advance

surya
DBA

[Updated on: Thu, 03 August 2006 14:58]

Report message to a moderator

Re: Reclaiming Diskspace in Linux from Oracle tablespace after truncate table [message #185822 is a reply to message #185820] Thu, 03 August 2006 15:08 Go to previous messageGo to next message
BlackSwan
Messages: 25042
Registered: January 2009
Location: SoCal
Senior Member
The short answer is "NO way"
A longer answer is "Not easily"
It appears you are lacking in understanding how tablespaces function.
I suggest you take some time & read the fine Concepts Manual
http://download-west.oracle.com/docs/cd/B19306_01/server.102/b14220/toc.htm
Re: Reclaiming Diskspace in Linux from Oracle tablespace [message #185827 is a reply to message #185822] Thu, 03 August 2006 15:33 Go to previous messageGo to next message
vsrwon
Messages: 2
Registered: August 2006
Location: LA
Junior Member
Thanks for your notes.
I am looking how can we release logical space to physical level that can be used for some other things or in oracle itself.Sorry If I am wrong somewhere.

Thanks a lot
Surya
DBA

[Updated on: Thu, 03 August 2006 15:37]

Report message to a moderator

Re: Reclaiming Diskspace in Linux from Oracle tablespace after truncate table [message #185855 is a reply to message #185820] Thu, 03 August 2006 17:56 Go to previous message
BlackSwan
Messages: 25042
Registered: January 2009
Location: SoCal
Senior Member
What can be done depends upon Oracle version & HWM in tablespace, too.
Previous Topic: Oracle Installation
Next Topic: Using of Blobs - possible performance issues
Goto Forum:
  


Current Time: Wed Dec 07 07:08:33 CST 2016

Total time taken to generate the page: 0.11654 seconds