I have a Oracle 12c database and I am trying to split partitions into another partitions.
Here is an examples:
ALTER TABLE MAXDATA.mfinc split PARTITION mfinc_48_201601 AT (47,202402) INTO (PARTITION mfinc_47_202401 TABLESPACE MMAX_mfinc_2024,PARTITION mfinc_48_201601 TABLESPACE MMAX_mfinc_2016);
ALTER TABLE MAXDATA.mfinc split PARTITION mfinc_48_201701 AT (47,202902) INTO (PARTITION mfinc_47_202901 TABLESPACE MMAX_mfinc_2029,PARTITION mfinc_48_201701 TABLESPACE MMAX_mfinc_2017);
We have a partition that is based upon level (48) and year_week. The first example is doing a splite on level 47 year_week 202402 which is like January week 2. It is basically from 2016 week 1 to 2024 week 2. The second one is from 201701 to 202902.
I added parallel, online and I still get the error. I created the TABLE SPACES as so from 2017 to 2029.
CREATE BIGFILE TABLESPACE MMAX_MINFINC_2016
DATAFILE '+DATA' SIZE 1000M
AUTOEXTEND ON NEXT 1000M
MAXSIZE UNLIMITED
LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO
CREATE BIGFILE TABLESPACE MMAX_MINFINC_2017
DATAFILE '+DATA' SIZE 1000M
AUTOEXTEND ON NEXT 1000M
MAXSIZE UNLIMITED
LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO
CREATE BIGFILE TABLESPACE MMAX_MINFINC_2029
DATAFILE '+DATA' SIZE 1000M
AUTOEXTEND ON NEXT 1000M
MAXSIZE UNLIMITED
LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO
Can someone please tell me why I am getting the ORA-14126: only a <parallel clause> may follow description(s) of resulting partitions error?
Any help will be appreciated.