Re: Q: Modify Index Subpartition NOPARALLEL ? (Drawing a blank)

I realize now, that I think I made an assumption that rebuilding an index partition in parallel kept the parallel clause on the index partition.

But I'm betting that isn't true is it? Rebuilding the partition in parallel probably doesn't flip the degree/instances bit as that's on the index itself and not on the partition?

Thanks,
Chris

On Wed, Feb 26, 2020 at 10:50 AM Chris Taylor < christopherdtaylor1994_at_gmail.com> wrote:

> DB: 12.1.0.2
>
> I have a need to rebuild a bunch of indexes (partition and subpartitions)
> into a new tablespace.
>
> I have the rebuild working fine for subpartitions like so:
>
> alter index CTAYLOR.MY_INDEX01 rebuild subpartition SYS_SUBP42599
> tablespace USERS online parallel 8;
>
> What I cannot figure out is how to modify the subpartition back to
> NOPARALLEL.
>
> I've tried:
> alter index CTAYLOR.MY_INDEX01 modify subpartition SYS_SUBP42599
> NOPARALLEL;
> alter index CTAYLOR.MY_INDEX01 subpartition SYS_SUBP42599 NOPARALLEL;
>
> I know I can issue another rebuild stmt NOPARALLEL but that seems crazy.
> There has to be a simple way to modify the subpartition back to noparallel
> and I can't figure out from manuals how to get to it (sheepish).
>
> Any help?
>
> Thanks,
> Chris
>
>

--
http://www.freelists.org/webpage/oracle-l