Q: Modify Index Subpartition NOPARALLEL ? (Drawing a blank)
Date: Wed, 26 Feb 2020 10:50:37 -0500
Message-ID: <CAP79kiTA1awDL2es0xgYNOKMj63VQnwR_r=MaNg+U7NUiSYsqg_at_mail.gmail.com>
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-lReceived on Wed Feb 26 2020 - 16:50:37 CET