OraFAQ Forum: Server Administration » Managing Tablespaces

Home » RDBMS Server » Server Administration » Managing Tablespaces (Oracle 10g)

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

Managing Tablespaces [message #517064]

Fri, 22 July 2011 03:59

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.

Report message to a moderator

Re: Managing Tablespaces [message #517066 is a reply to message #517064]

Fri, 22 July 2011 04:03

Michel Cadot
Messages: 54181
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

Report message to a moderator

Re: Managing Tablespaces [message #517067 is a reply to message #517066]

Fri, 22 July 2011 04:22

snehalgandhi
Messages: 36
Registered: February 2011
Location: Ahmedabad

Member

I just want to reclaim the space....
I am not in ASSM

Report message to a moderator

Re: Managing Tablespaces [message #517068 is a reply to message #517067]

Fri, 22 July 2011 04:46

Michel Cadot
Messages: 54181
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

Report message to a moderator

Re: Managing Tablespaces [message #517069 is a reply to message #517068]

Fri, 22 July 2011 04:54

snehalgandhi
Messages: 36
Registered: February 2011
Location: Ahmedabad

Member

I have deleted some data from a table.....Tablespace Free space should increase...? right ?

Report message to a moderator

Re: Managing Tablespaces [message #517075 is a reply to message #517069]

Fri, 22 July 2011 06:23

Michel Cadot
Messages: 54181
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

Report message to a moderator

Re: Managing Tablespaces [message #517079 is a reply to message #517075]

Fri, 22 July 2011 06:44

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...

Report message to a moderator

Re: Managing Tablespaces [message #517082 is a reply to message #517079]

Fri, 22 July 2011 06:51

Michel Cadot
Messages: 54181
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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed May 22 07:01:54 CDT 2013

Total time taken to generate the page: 0.27069 seconds