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

Thanks _at_Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk> - much appreciated.

Chris

On Wed, Feb 26, 2020 at 12:55 PM Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk> wrote:

> That seems to be the case. There's no degree or instances column on
> indpart$ or indsubpart$, only on ind$.
>
> For testing purposes:
> If you do an explicit parallel , then query v$pq_tqstat you'll see the
> parallelism used
> Then reconnect and do a rebuild with no specification for parallelism then
> the degree for the previous rebuild won't re-appear.
>
> Regards
> Jonathan Lewis
>
> ________________________________________
> From: oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> on
> behalf of Chris Taylor <christopherdtaylor1994_at_gmail.com>
> Sent: 26 February 2020 17:50
> To: ORACLE-L
> Subject: 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<mailto: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