ORA-14021: MAXVALUE must be specified for all columns

This is a discussion on ORA-14021: MAXVALUE must be specified for all columns within the Oracle Errors forums in Oracle Database category; Hi, whwn i am trying to execute the query CREATE INDEX SCOTT . LINE_SERIES_INDEX ON SCOTT . VEHICLE_DETAILS ( LINE_SERIES_ID ) GLOBAL PARTITION BY RANGE ( LINE_SERIES_ID ) ( PARTITION LINE_SERIES_INDEX_P1 VALUES LESS THAN (5), PARTITION LINE_SERIES_INDEX_P2 VALUES LESS THAN (10), PARTITION LINE_SERIES_INDEX_P3 VALUES LESS THAN (15), ) it is displaying an error message like below ORA-14021: MAXVALUE must be specified for all columns i am using oracle 9. can any one can help on this regard. Thanks in advance Rajesh....

Go Back   Database Forum > Oracle Database > Oracle Errors

Database Forums

Register FAQ Calendar Search Today's Posts Mark Forums Read
  #1  
Old 11-28-2007, 03:11 AM
Default ORA-14021: MAXVALUE must be specified for all columns

Hi,

whwn i am trying to execute the query

CREATE INDEX "SCOTT"."LINE_SERIES_INDEX"
ON "SCOTT"."VEHICLE_DETAILS" ("LINE_SERIES_ID") GLOBAL
PARTITION BY RANGE ("LINE_SERIES_ID")
(
PARTITION "LINE_SERIES_INDEX_P1"
VALUES LESS THAN (5),
PARTITION "LINE_SERIES_INDEX_P2"
VALUES LESS THAN (10),
PARTITION "LINE_SERIES_INDEX_P3"
VALUES LESS THAN (15),
)

it is displaying an error message like below

ORA-14021: MAXVALUE must be specified for all columns

i am using oracle 9.

can any one can help on this regard.

Thanks in advance
Rajesh.
Reply With Quote
Reply


Thread Tools
Display Modes



All times are GMT -4. The time now is 04:40 PM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Integrated by bbpixel2008 :: jvbPlugin R1013.368.1

Search Engine Friendly URLs by vBSEO 3.1.0
vB Ad Management by =RedTyger=
In an effort to better serve ads to our visitors, cookies are used on Mydatabasesupport.com. For more information, check out our Privacy Policy.