Partition split

From: Michael Calisi <oracle455_at_gmail.com>
Date: Wed, 20 Jan 2016 16:29:15 -0500
Message-ID: <CAJkYCMFQAVwEODfMta-PD7Rd6qP4nnhg+SjONi_C5Wkbst4ZRQ_at_mail.gmail.com>

steps I used to split the partition. The mistake I made was on CH2016Q4, you can see the output from the attach.. My question how can I change that lat partition with the correct date range.

STEPS Taken

ALTER TABLE CORRESPONDENCE_HISTORY
SPLIT PARTITION CHUNSENT at (TO_DATE('2016-04-01 00:00:00','YYYY-MM-DD HH24:MI:SS'))
INTO
(

partition CH2016Q1,
PARTITION CHUNSENT
);
ALTER TABLE CORRESPONDENCE_HISTORY
SPLIT PARTITION CHUNSENT at (TO_DATE('2016-07-01 00:00:00','YYYY-MM-DD HH24:MI:SS'))
INTO
(

partition CH2016Q2,
PARTITION CHUNSENT
);
ALTER TABLE CORRESPONDENCE_HISTORY
SPLIT PARTITION CHUNSENT at (TO_DATE('2016-10-01 00:00:00','YYYY-MM-DD HH24:MI:SS'))
INTO
(

partition CH2016Q3,
PARTITION CHUNSENT
);
ALTER TABLE CORRESPONDENCE_HISTORY
SPLIT PARTITION CHUNSENT at (TO_DATE('2016-11-01 00:00:00','YYYY-MM-DD HH24:MI:SS'))
INTO
(

partition CH2016Q4,
PARTITION CHUNSENT
);

CH2016Q4 should of been

ALTER TABLE correspondence_history
SPLIT PARTITION CHUNSENT at (TO_DATE('2017-01-01 00:00:00','YYYY-MM-DD HH24:MI:SS'))
INTO
(

partition ch2016q4,
PARTITION CHUNSENT
);

My question how can I make this change?

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Jan 20 2016 - 22:29:15 CET