TABLE PARTITION ON 10g version "10.2.0.4.0"

Jan 31, 2023 10:38AM

appsdb > SELECT partition_name, high_value FROM ALL_TAB_PARTITIONS WHERE TABLE_NAME='YOU_NOTIFICATION_T_TESTING';

PARTITION_NAME HIGH_VALUE

------------------------------ --------------------------------------------------------------------------------

YOU_NOT_T_JAS_2022 TO_DATE(' 2022-10-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA

YOU_NOT_T_2022_ULTD MAXVALUE

"--I'M TRYING TO MAKE PARTITION ON EXESTING PARTITION BY THIS COMMAND--"

ALTER TABLE NEWCOLSYS.YOU_NOTIFICATION_T_TESTING

SPLIT partition YOU_NOT_T_2022_ULTD AT (TO_DATE('01-OCT-2022','DD-MON-YYYY'))

INTO (PARTITION YOU_NOT_T_OND_2022,

PARTITION YOU_NOT_T_2022_ULTD)

UPDATE GLOBAL INDEXES;

"AND GETTING THIS ERROR"

SPLIT partition YOU_NOT_T_2022_ULTD AT (TO_DATE('01-JAN-2022','DD-MON-YYYY'))

Managing Databases using Enterprise Manager (MOSC)