Home » RDBMS Server » Server Administration » Shrink DB (Oracle9i)
Shrink DB [message #339076] Wed, 06 August 2008 12:50 Go to next message
patdev
Messages: 56
Registered: August 2008
Member
Hi

I am new to this and need to know what should be done to prevent it to get full.

I have databsae and some tablespace is filled up to 95% used space and want to shrink so it has space to grow.

What process need to be followed please guide!!

thanks
Pat
Re: Shrink DB [message #339077 is a reply to message #339076] Wed, 06 August 2008 12:52 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/88153/0/
Please read & follow posting guidelines as stated in URL above
Re: Shrink DB [message #339079 is a reply to message #339077] Wed, 06 August 2008 12:59 Go to previous messageGo to next message
patdev
Messages: 56
Registered: August 2008
Member
where should i post it then?

Thanks
Pat
Re: Shrink DB [message #339085 is a reply to message #339079] Wed, 06 August 2008 13:14 Go to previous messageGo to next message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
If you don't want the database to get full, don't put any data in it. Confused
Re: Shrink DB [message #339086 is a reply to message #339076] Wed, 06 August 2008 13:23 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
ALTER TABLE YOUR_TABLE COMPRESS;
Re: Shrink DB [message #339088 is a reply to message #339086] Wed, 06 August 2008 13:37 Go to previous messageGo to next message
patdev
Messages: 56
Registered: August 2008
Member
But how can i shrink TableSpace!! please guide!!
Re: Shrink DB [message #339090 is a reply to message #339076] Wed, 06 August 2008 13:44 Go to previous message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
>But how can i shrink TableSpace!!
Can not be done.
To reduce tablespace size:
1) create new tablespace.
2) move all objects out of old tablespace
3) drop old tablespace
It is easier to add more disk space.
Previous Topic: Save point Information.
Next Topic: Datafiles without .dbf extension
Goto Forum:
  


Current Time: Thu Dec 08 10:09:01 CST 2016

Total time taken to generate the page: 0.05584 seconds