OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » shrink table space (oracle 10g)

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

shrink table space [message #464193]

Tue, 06 July 2010 16:20

att7809yahoocom
Messages: 1
Registered: July 2010

Junior Member

hi all i am trying to shrink tablespace of 100gb which has objects.

i tried coalesce,
then i try to shrink and also tried to resize the datafile with no luck

error message can't resize

please help

thanks in advance

Report message to a moderator

Re: shrink table space [message #464195 is a reply to message #464193]

Tue, 06 July 2010 17:15

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>error message can't resize

Not valid/standard Oracle error.
It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/
You can not shrink tablespace smaller than MAX(BLOCK_ID)

Report message to a moderator

Re: shrink table space [message #464219 is a reply to message #464195]

Wed, 07 July 2010 00:25

Michel Cadot
Messages: 68774
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

You have to first see which space you have in the tablespace files querying dba_free_space.
Then you can try to move the objects (alter table, alter index).
Ot you can export the objects, drop them from the tablespace, shrink the tablespace files and reimport the objects.
Take care of grants in this case.

There are other ways depending on many things like the availabkle space in the tablespace and in your disks.

Regards
Michel

Report message to a moderator

Previous Topic:	Invalid MView's in DBA_OBJECTS
Next Topic:	DBWR and LGWR

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jan 18 06:13:25 CST 2026