Thanks @Jonathan Lewis <jonathan@xxxxxxxxxxxxxxxxxx> - much appreciated.
Chris
On Wed, Feb 26, 2020 at 12:55 PM Jonathan Lewis <jonathan@xxxxxxxxxxxxxxxxxx>
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@xxxxxxxxxxxxx <oracle-l-bounce@xxxxxxxxxxxxx> on
behalf of Chris Taylor <christopherdtaylor1994@xxxxxxxxx>
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@xxxxxxxxx<mailto:christopherdtaylor1994@xxxxxxxxx>>
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
