Dear all,
I want to know wether it can not use funcion when in create partition tables?
create table tb_hxl_user_rh
(
statedate number,
provcode number not null,
usernumber varchar2(13) not null,
rem1 varchar2(1024),
create_date date,
create_by number,
last_update_date date,
last_update_by number
)
partition by range (statedate)
(
partition HXL_USER_20110516 values less than (to_number(to_char(TO_DATE(' 2011-05-17 00:00:00', 'YYYY-MM-DD HH24:MI:SS'),'YYYYMMDD')))
);
ORA-14019: partition bound element must be one of: string, datetime or interval
literal, number, or MAXVALUE