| ORA-14037: partition bound of partition "P3" is too high [message #501445] |
Tue, 29 March 2011 04:20  |
rangan.s
Messages: 75
Registered: February 2008
Location: chennai
|
Member |
|
|
HI ,
I am getting error while doing partitioning
CREATE TABLE EMD_FILE_LOAD_DETAILS_PR
(
FILE_REFERENCE_ID,FILE_NAME,FILE_TYPE,FILE_GROUP_NAME,
RECEIVED_TIME,LOAD_START_TIME,LOAD_END_TIME,RECORD_COUNT,
RECORDS_LOADED,RECORDS
_ERROR,ACKNOWLEDGEMENT_CREATION_TIME,PAYER_ID,FILE_STATUS,
ACKNOWLEDGEMENT_NAME,PROCESS_COMPLETED,LOAD_DATE
)
PARTITION BY RANGE (LOAD_DATE)
(
PARTITION P3 VALUES LESS THAN (TO_DATE('29-03-2011 02:18:54', 'DD-MM-YYYY HH:MI:SS')),
PARTITION P4 VALUES LESS THAN (TO_DATE('29-03-2009 02:18:54', 'DD-MM-YYYY HH:MI:SS')),
PARTITION P5 VALUES LESS THAN (TO_DATE('29-03-2007 02:18:54', 'DD-MM-YYYY HH:MI:SS'))
)
ENABLE ROW MOVEMENT AS
SELECT * FROM PR_EMD_FILE_LOAD_DETAILS;
ORA-14037: partition bound of partition "P3" is too high
Thanks
Rangan Sampath
[Updated on: Tue, 29 March 2011 04:32] by Moderator Report message to a moderator |
|
|
|
| Re: ORA-14037: partition bound of partition "P3" is too high [message #501446 is a reply to message #501445] |
Tue, 29 March 2011 04:31  |
 |
Michel Cadot
Messages: 68764
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
ORA-14037: partition bound of partition \"%s\" is too high
*Cause: High bound of the partition whose name (explicitly specified
by the user) is displayed in this message did not collate
lower than that of the following partition, which is illegal.
*Action: Ensure that high bound of every partition (except for the last
one) collates lower than that of a following partition.
Change the order of partition definition.
Regards
Michel
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
