Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How can i change the MAXEXTENTS ??

Re: How can i change the MAXEXTENTS ??

From: EXE <exe_at_exesolutions.com>
Date: Tue, 18 Aug 1998 23:21:03 -0700
Message-ID: <35DA6ECF.73F00544@exesolutions.com>


Madhu Cherukuri wrote:

> Unfortunately you can not change the maxextents of a table

This is not correct. The syntax for changing MAXEXTENTS is:

ALTER TABLE schema_name.table_name STORAGE (MAXEXTENTS some_numeric_value);

Regards,

Daniel A. Morgan Received on Wed Aug 19 1998 - 01:21:03 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US