Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

create partition-table issue

AndySkyAug 18 2011 — edited Aug 18 2011
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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 15 2011
Added on Aug 18 2011
9 comments
841 views