OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Shrink DB (Oracle9i)

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

Shrink DB [message #339076]

Wed, 06 August 2008 12:50

patdev
Messages: 73
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

Report message to a moderator

Re: Shrink DB [message #339077 is a reply to message #339076]

Wed, 06 August 2008 12:52

BlackSwan
Messages: 26766
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

Report message to a moderator

Re: Shrink DB [message #339079 is a reply to message #339077]

Wed, 06 August 2008 12:59

patdev
Messages: 73
Registered: August 2008

Member

where should i post it then?

Thanks
Pat

Report message to a moderator

Re: Shrink DB [message #339085 is a reply to message #339079]

Wed, 06 August 2008 13:14

ThomasG
Messages: 3211
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

Report message to a moderator

Re: Shrink DB [message #339086 is a reply to message #339076]

Wed, 06 August 2008 13:23

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

ALTER TABLE YOUR_TABLE COMPRESS;

Report message to a moderator

Re: Shrink DB [message #339088 is a reply to message #339086]

Wed, 06 August 2008 13:37

patdev
Messages: 73
Registered: August 2008

Member

But how can i shrink TableSpace!! please guide!!

Report message to a moderator

Re: Shrink DB [message #339090 is a reply to message #339076]

Wed, 06 August 2008 13:44

BlackSwan
Messages: 26766
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.

Report message to a moderator

Previous Topic:	Save point Information.
Next Topic:	Datafiles without .dbf extension

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jul 08 15:13:21 CDT 2024