Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Can't set maxextents
Jonathan,
You don't need the "=" sign.
Just type
ALTER TABLE tablename STORAGE (MAXEXTENTS N);
Winnie
Jonathan Gennick <jonathan_at_gennick.com> on 06/06/2000 02:10:47 PM
Please respond to ORACLE-L_at_fatcity.com
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc: (bcc: Winnie Liu/HQ/ISC)
Subject: Can't set maxextents
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:
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
-- 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:38:02 CDT