Пишу скрипт но возникла проблемма с format а именно @0# и @0
вот пример:
$month=1
$day=28
$year=2009
format =
alter table SECURITYEVENTS_TS split partition MAXPEND at (^0#/@0#/@### 00:00:00) into (partition P_@###@0@0 partition MAXPEND);
$month,$day,$year,$year,$month,$day
.
write ;
alter table SECURITYEVENTS_TS split partition MAXPEND at (001/028/2009 00:00:00) into (partition P_20091020 partition MAXPEND);
alter table SECURITYEVENTS_TS split partition MAXPEND at (01/28/2009 00:00:00) into (partition P_20090128 partition MAXPEND);
гуглил но ненашел ответа.