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

Home -> Community -> Usenet -> c.d.o.misc -> Q: how to modify the storage params of a partition

Q: how to modify the storage params of a partition

From: Vince Laurent <vincelaurent_at_REMOVETHISsbcglobal.net>
Date: Thu, 29 Dec 2005 14:47:17 GMT
Message-ID: <njt7r110alnmpodfh9m83aqui1sqjitk2u@4ax.com>


I was hoping someone might be able to help me with this one:

   I tried to:

        alter table "sapr3"."b0000153001" modify partition
"SAPR3"."/BIC/B00001530010000000003" storage ( next 20480k);

but it came back with:         

ERROR at line 1:
ORA-14049: invalid ALTER TABLE MODIFY PARTITION option

to put it all together (so you can see where the * hit):

SQL> alter table "sapr3"."b0000257000" modify partition
"SAPR3"."/BIC/B00002570000000000002" storage ( next 20480k);
alter table "sapr3"."b0000257000" modify partition
"SAPR3"."/BIC/B00002570000000000002" storage ( next 20480k)

                                                          *
ERROR at line 1:
ORA-14049: invalid ALTER TABLE MODIFY PARTITION option

OK... maybe not, but the '*' was under the second '.':

"sapr3"."/BIC/B00...

           *

How do I modify the storage params of a partition?

Thanks!
Vince



Come race with us!
http://www.mgpmrc.org Received on Thu Dec 29 2005 - 08:47:17 CST

Original text of this message

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