Home » SQL & PL/SQL » SQL & PL/SQL » PROBLEM WHILE CRETAING AN INDEX WITH PARTITIONS FOR AN EXISTING TABLE
PROBLEM WHILE CRETAING AN INDEX WITH PARTITIONS FOR AN EXISTING TABLE [message #283745] Wed, 28 November 2007 01:30 Go to next message
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.
Re: PROBLEM WHILE CRETAING AN INDEX WITH PARTITIONS FOR AN EXISTING TABLE [message #283746 is a reply to message #283745] Wed, 28 November 2007 01:32 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

First use "code" tags
http://www.orafaq.com/forum/t/88153/0/

Cause: In the VALUES LESS THAN clause for the highest (last) partition of a GLOBAL index, MAXVALUE must be specified for all columns

Action: Ensure that VALUES LESS THAN clause for the last partition of a GLOBAL index has MAXVALUE specified for all columns

[Updated on: Wed, 28 November 2007 01:33]

Report message to a moderator

Previous Topic: dividing time when two hour gap found
Next Topic: Username
Goto Forum:
  


Current Time: Tue Feb 18 10:28:04 CST 2025