OraFAQ Forum: Server Administration » Freeing a tablespace

Home » RDBMS Server » Server Administration » Freeing a tablespace (Oracle 9i release 9.2.0.7.0)

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

Freeing a tablespace [message #454997]

Sun, 09 May 2010 16:08

Amine
Messages: 375
Registered: March 2010

Senior Member

Hi all,
Here is my problem : I create a tablespace named ts_photos.
I create then a table on this tablespace.
Then I insert some blobs records.
The space grows up to 2 Gb.
I perform a truncate statment. Then the space grows up to 4Gb.
I re-insert the same records and the size stays in 4Gb.

The database in in archivelog mode. How can I return to the initial size (2Gb of effective data) : should I drop the tablespace and recreate it or is there another solution ?

Thank you in advance,

Amine

Report message to a moderator

Re: Freeing a tablespace [message #454998 is a reply to message #454997]

Sun, 09 May 2010 16:32

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Current disk space costs less than $1 (one US Dollar) per GB.
How much time & effort & system resources will you expend to reclaim 2GB?

If you do nothing eventually the "free" space will be consumed.

[Updated on: Sun, 09 May 2010 16:33]

Report message to a moderator

Re: Freeing a tablespace [message #454999 is a reply to message #454998]

Sun, 09 May 2010 16:40

Amine
Messages: 375
Registered: March 2010

Senior Member

Well,
I want this space back, i want to do this effort : How do I proceed ?

Report message to a moderator

Re: Freeing a tablespace [message #455000 is a reply to message #454999]

Sun, 09 May 2010 16:44

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

The classic & most straight forward way is to create a new tablespace of smaller size.
Move objects from old tablespace into new tablespace.
The drop old & now empty tablespace.
Lots of movement for limited or no progress.
Oracle won't know or care that you did this.

Report message to a moderator

Previous Topic:	upgrading to 10g 10.2.0.2.0 or higher
Next Topic:	downgrade oracle from vers 10.2.0.4 TO 10.2.0.3 &change compatible init param from 10.2.0.3to 10

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun May 19 13:41:40 CDT 2024