PROBLEM WHILE CRETAING AN INDEX WITH PARTITIONS FOR AN EXISTING TABLE [message #283745] |
Wed, 28 November 2007 01:30  |
mr.rajeshyadav
Messages: 48 Registered: November 2007
|
Member |
|
|
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.
|
|
|
|