OraFAQ Forum: Server Administration » how to resize tablespace size?

Home » RDBMS Server » Server Administration » how to resize tablespace size?

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

how to resize tablespace size? [message #172625]

Wed, 17 May 2006 07:16

anandhi
Messages: 31
Registered: April 2006
Location: Chennai

Member

hi

I have a question on resizing tablespace.

i created a tablespace USERS with 10GB and it contains 5 datafiles with 2 GB size each.

The tablespace contains only one table with hardly fews 1000 of records.

Now i want to resize the tablespace to 6 GB?

How to do it?

Thanks
Anandhi

Report message to a moderator

Re: how to resize tablespace size? [message #172628 is a reply to message #172625]

Wed, 17 May 2006 07:23

Frank Naude
Messages: 4580
Registered: April 1998

Senior Member

See http://www.orafaq.com/faq/can_one_resize_tablespaces_and_data_files

Report message to a moderator

Previous Topic:	proble for temptable space growing
Next Topic:	Temp tablespace

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 12:55:01 CDT 2024