| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Re: how to modify the storage params of a partition
Thanks!
It worked once I could figure out the table that it belonged too.
SAP hides a lot of information and the developers don't ever
tell me what is going on. They only scream when something goes wrong.
On Thu, 29 Dec 2005 16:59:24 +0100, "Michel Cadot" <micadot{at}altern{dot}org> wrote:
>
>"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
>
 |
 |