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), ) ...
![]() |
| | LinkBack | Thread Tools | Display Modes |
|
#1
| |||
| |||
| 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. |
![]() |
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
| |
| ||||
| 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.




Linear Mode
