split partition
I need some help in creating a script to auotmate partition spliting. when i try and create a script to use sysdate as what to split on i get a error, but if i use a string to split the partition everything works fine. Any ideas on why i can use sysdate for spliting a partition?
Version 10g
error ora-14019
WORKS
ALTER TABLE call
SPLIT PARTITION call_max_value at (sysdate-5) INTO (PARTITION call_3
TABLESPACE ts_data , PARTITION call_max_val);
DOESNT WORK
ALTER TABLE call
SPLIT PARTITION call_max_value at (to_date('30-05-2008','DD-MM-YYYY')) INTO (PARTITION call_3
TABLESPACE ts_data , PARTITION call_max_val);