Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: ALTER TABLE...ADD PARTITION...TABLESPACE <tablespace_name> fails
Jonathan Lewis wrote:
>
> Its a known bug with partitioned IOTs,
> appeared some time around 8.1.6, fixed
> in 8.1.7.1 (I think).
>
> The quoted workaround is to create the
> partition in the wrong tablespace and
> then move it. However there is another
> bug which can result in a 00600 error
> if you start moving several such partitions
> at the same time.
>
> --
> Jonathan Lewis
Hi.
how about just altering the user's default tablespace prior to and after the table creation?
Paul
> Neoteric5 wrote in message ...
> >I am trying to create a partitioned, Index Organized Table, with each
> >partition in a dedicated tablespace.
> >
> >But when I try to add a partition, the TABLESPACE clause is not working.
> >The ALTER TABLE...ADD PARTITION statement always creates new partitions in
> >the default
> >partition that the table was created in, rather than in the tablespace
> >specified in the ALTER
> >TABLE statement.
> >
> >What am I doing wrong? Does this work for others? (is my Oracle
> >installation broken?)
> >I am using 8.1.7EE on Linux 2.2.17.
> >
> >I don't want to create all partitions at table creation time once,
> >because of space and hardware limitations.
> >
> >I've attached a sample that fails in my Oracle environment.
> >
> >Thanks!
> >-Milo Chan
> >mail to mchan at vestant dot com
> >
Received on Sun May 13 2001 - 14:22:49 CDT
![]() |
![]() |