Re: Split partition

> What kind of partition?

BY RANGE
> Split it with what statement?

alter table stat_tracking
split partition stat_tracking_p_current at (TO_DATE(' 2004-08-01 00:00:00 ', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) into ( partition stat_tracking_p_2004_07, partition stat_tracking_p_current );

Any idea ??

Thanks... Received on Thu Aug 05 2004 - 13:52:23 CDT