dbaspot
Tags Register FAQ Calendar Search Today's Posts Mark Forums Read

ORA-14021: MAXVALUE must be specified for all columns - Oracle Errors

This is a discussion on ORA-14021: MAXVALUE must be specified for all columns - Oracle Errors ; 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), ) ...


Home > Database Forum > Oracle Database > Oracle Errors > ORA-14021: MAXVALUE must be specified for all columns

Reply

 

LinkBack Thread Tools Display Modes
  #1  
Old 11-28-2007, 03:11 AM
Database Newbie
 
Join Date: Nov 2007
Posts: 1
mr.rajeshyadav is on a distinguished road
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


Similar Threads

Thread Thread Starter Forum Replies Last Post
How to move all tables to a new filegroup in sql 2005 Database Administrator sqlserver-server 3 12-03-2007 08:50 AM
Federated DB Bad Query performance Database Administrator ibm-db2 7 11-06-2007 04:59 PM


All times are GMT -4. The time now is 03:38 AM.