OraFAQ Forum: Server Administration » how to increase size of a tablespace

Home » RDBMS Server » Server Administration » how to increase size of a tablespace

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

how to increase size of a tablespace [message #112727]

Mon, 28 March 2005 23:49

dassudip
Messages: 22
Registered: February 2005
Location: Delhi

Junior Member

Can I increase the size of a table space without adding a datafile with it?
If so please tell me how to do that ???

Regards,

Sudipta

Report message to a moderator

Re: how to increase size of a tablespace [message #112766 is a reply to message #112727]

Tue, 29 March 2005 04:03

deepa_balu
Messages: 74
Registered: March 2005

Member

Your tablespace will be containing atleast one datafile.
So you can set the Datafile Autoextend property to ON if u want to increase the size.

Report message to a moderator

Re: how to increase size of a tablespace [message #113350 is a reply to message #112727]

Fri, 01 April 2005 09:51

ntnboi
Messages: 17
Registered: April 2005
Location: Italy - Rome

Junior Member

Hi,
for oracle 8i and up.
ex:
Actual size of tablespace 500000 kb, I want increase it at 600000 kb

I connect to instance with DBA privilege user and execute follow commands:

ALTER DATABASE DATAFILE '/path/datafile_of_tabelspace.dbf' RESIZE 600000K;

Regards.

Report message to a moderator

Previous Topic:	how to change location of archive file for already running 24x7database in archive mode?
Next Topic:	Index usage - script

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Feb 13 09:36:23 CST 2025