split partition in a range partition table
we have a range partitioned table which is partitioned by week and it has partitions by week (attached DDL for table, index) & has a maxvalue partition. we need to add partitions for the rest of the year and currently it only has partitions till July. Since it has maxvalue we need to split partitions as below -
ALTER TABLE rms13.week_data SPLIT PARTITION WEEK_DATA_MAX at (TO_DATE('2018-08-05 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) INTO (PARTITION WEEK_DATA_606, PARTITION MAXVALUE);
could you please let me know whether i need to rebuild the index (local) , this is the only index on the table and it is partitioned local index