OraFAQ Forum: Server Administration » Reclaiming Diskspace in Linux from Oracle tablespace after truncate table

Home » RDBMS Server » Server Administration » Reclaiming Diskspace in Linux from Oracle tablespace after truncate table

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Reclaiming Diskspace in Linux from Oracle tablespace after truncate table [message #185820]

Thu, 03 August 2006 14:57

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

BlackSwan
Messages: 26766
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

Report message to a moderator

Re: Reclaiming Diskspace in Linux from Oracle tablespace [message #185827 is a reply to message #185822]

Thu, 03 August 2006 15:33

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

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

What can be done depends upon Oracle version & HWM in tablespace, too.

Report message to a moderator

Previous Topic:	Oracle Installation
Next Topic:	Using of Blobs - possible performance issues

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 09:53:25 CDT 2024