| partition-key using function issue [message #520011] |
Thu, 18 August 2011 03:20  |
andy huang
Messages: 498
Registered: July 2011
|
Senior Member |
|
|
Dear all,
It can not use function in partition-key, right?
create table tb_hxl_user_rh
(
statedate number(8),
provcode number not null,
usernumber varchar2(13) not Null
)
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[Updated on: Thu, 18 August 2011 04:03] by Moderator Report message to a moderator |
|
|
|
|
|
| Re: partition-key using function issue [message #520019 is a reply to message #520016] |
Thu, 18 August 2011 03:59  |
andy huang
Messages: 498
Registered: July 2011
|
Senior Member |
|
|
hi,
The STATEDATE column is number type defined by user,but user really want it to representate DATE,so I need to change date to number.
If i do not do this,the STATEDATE can store values such as 20110532, it is not a valid date.
|
|
|
|
|
|
|
|
|
|
| Re: partition-key using function issue [message #520040 is a reply to message #520025] |
Thu, 18 August 2011 04:51 |
John Watson
Messages: 8931
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
You need to upgrade to 11g, then you can partition on a virtual column with a function:orcl> create table parts(c1 varchar2(10), c1upper as (upper(c1)))
2 partition by range (c1upper)
3 (partition p1 values less than ('A'),
4 partition p2 values less than ('B'));
Table created.
orcl> |
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
