Re: how to modify the storage params of a partition

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Thu, 29 Dec 2005 16:59:24 +0100
Message-ID: <43b407de$0$19239$626a54ce@news.free.fr>

"Vince Laurent" <vincelaurent_at_REMOVETHISsbcglobal.net> a écrit dans le message de news: njt7r110alnmpodfh9m83aqui1sqjitk2u_at_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

Partition name must not be prefixed by owner name.

Regards
Michel cadot Received on Thu Dec 29 2005 - 09:59:24 CST