OraFAQ Forum: SQL & PL/SQL » Increase Diskspace

Home » SQL & PL/SQL » SQL & PL/SQL » Increase Diskspace

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

Increase Diskspace [message #20028]

Thu, 25 April 2002 08:33

Lissa Wong
Messages: 4
Registered: March 2002

Junior Member

How do I increase the amount of diskspace available on a particular table?

Report message to a moderator

Re: Increase Diskspace [message #20030 is a reply to message #20028]

Thu, 25 April 2002 09:29

ora_guy
Messages: 4
Registered: April 2002

Junior Member

Probably you can try

ALTER TABLE Command.

Report message to a moderator

Re: Increase Diskspace [message #20038 is a reply to message #20028]

Thu, 25 April 2002 13:48

ora_guy
Messages: 4
Registered: April 2002

Junior Member

To modify data block space usage parameters (PCTFREE, PCTUSED)

ALTER TABLE Emp_tab
PCTFREE 30
PCTUSED 60;

Report message to a moderator

Re: Increase Diskspace [message #20040 is a reply to message #20028]

Thu, 25 April 2002 14:44

Mike
Messages: 417
Registered: September 1998

Senior Member

Hi,

You can use the command:
ALTER TABLE table_name ALLOCATE EXTENT;

But to be sure that it is what you want it would be good if you could say what you mean by "increase the amount of diskspace available on a particular table". I'm also wondering for what you need that because it is automaticly done by Oracle.

Report message to a moderator

Previous Topic:	& problem in sql query....
Next Topic:	Analytic SQL

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 23 17:09:48 CDT 2024