Home » RDBMS Server » Server Administration » Managing Tablespaces (Oracle 10g)
Managing Tablespaces [message #517064] Fri, 22 July 2011 03:59 Go to next message
snehalgandhi
Messages: 36
Registered: February 2011
Location: Ahmedabad
Member
I have deleted lots of data from existing tables in one tablespace. Can anyone guide me to shrink or coalesce the size of the tablespace.
Re: Managing Tablespaces [message #517066 is a reply to message #517064] Fri, 22 July 2011 04:03 Go to previous messageGo to next message
Michel Cadot
Messages: 59076
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
First: ALTER TABLE SHRINK SPACE (if you are in ASSM).

Then do you want to reduce the tablespace size or not?

Regards
Michel
Re: Managing Tablespaces [message #517067 is a reply to message #517066] Fri, 22 July 2011 04:22 Go to previous messageGo to next message
snehalgandhi
Messages: 36
Registered: February 2011
Location: Ahmedabad
Member
I just want to reclaim the space....
I am not in ASSM
Re: Managing Tablespaces [message #517068 is a reply to message #517067] Fri, 22 July 2011 04:46 Go to previous messageGo to next message
Michel Cadot
Messages: 59076
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
I just want to reclaim the space....

Explain. Which space? Tables? Tablespace? What do you want EXACTLY.

Regards
Michel
Re: Managing Tablespaces [message #517069 is a reply to message #517068] Fri, 22 July 2011 04:54 Go to previous messageGo to next message
snehalgandhi
Messages: 36
Registered: February 2011
Location: Ahmedabad
Member
I have deleted some data from a table.....Tablespace Free space should increase...? right ?
Re: Managing Tablespaces [message #517075 is a reply to message #517069] Fri, 22 July 2011 06:23 Go to previous messageGo to next message
Michel Cadot
Messages: 59076
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Tablespace Free space should increase...? right ?

No, some place are freed inside the tables.

Regards
Michel
Re: Managing Tablespaces [message #517079 is a reply to message #517075] Fri, 22 July 2011 06:44 Go to previous messageGo to next message
snehalgandhi
Messages: 36
Registered: February 2011
Location: Ahmedabad
Member
I have deleted lots of data from existing tables in one tablespace. Can anyone guide me to shrink or coalesce the size of the tablespace. I am not in ASSM...
Re: Managing Tablespaces [message #517082 is a reply to message #517079] Fri, 22 July 2011 06:51 Go to previous message
Michel Cadot
Messages: 59076
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can only use ALTER TABLE MOVE in this case, either in the same tablespace or in another one.
Or you could use the old exp/truncate/imp way.

Regards
Michel


Previous Topic: how to apply composite key on a table
Next Topic: v$ views
Goto Forum:
  


Current Time: Tue Sep 16 02:32:38 CDT 2014

Total time taken to generate the page: 0.10179 seconds