Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Can't set maxextents
Remove "="
At 01:10 PM 6/6/00 -0800, Jonathan Gennick wrote:
>What could be preventing me from executing the following:
>
>SQL> truncate table chu_church;
>
>Table truncated.
>
>SQL> alter table chu_church storage (maxextents=1);
>alter table chu_church storage (maxextents=1)
> *
>ERROR at line 1:
>ORA-02221: invalid MAXEXTENTS storage option value
>
>I've been testing something, and I must have done this exact
>same thing 20 times during the past two days. Why am I
>suddenly not able to do it? Any ideas?
>
>Jonathan
>
>_____________________________________________________
>jonathan_at_gennick.com
>http://gennick.com
>Brighten the Corner Where You Are
>--
>Author: Jonathan Gennick
> INET: jonathan_at_gennick.com
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
Received on Tue Jun 06 2000 - 15:47:02 CDT