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