-
What does with this creation happen???
I already tried to place the maxvalue in the place of the less then but it doesn't work.
how can I correct and to create this pk???
Look the copy of sqlplus
SQL> ALTER TABLE MAXSYS_VIEW_new ADD CONSTRAINT PK_MAXSYS_VIEW_new
2 PRIMARY KEY
3 (IDMARKET,IDNETWORK,NDATE,NTIME,IDINDIVIDUAL,IDTV)
4 USING INDEX
5 global PARTITION BY RANGE (idmarket)
6 (
7 PARTITION nacion_i VALUES LESS THAN (2) TABLESPACE Maxsys_p_nacion_I,
8 PARTITION saopau_i VALUES LESS THAN (513) TABLESPACE Maxsys_p_saopa_I,
9 PARTITION dfsacu_i VALUES LESS THAN (525) TABLESPACE Maxsys_p_dfsacu_I,
10 PARTITION bhrefo_i VALUES LESS THAN (606) TABLESPACE Maxsys_p_bhfore_I,
11 PARTITION riojan_i VALUES LESS THAN (615) TABLESPACE Maxsys_p_rioja_I,
12 PARTITION porflo_i VALUES LESS THAN (651) TABLESPACE Maxsys_p_poaflo_I
13 )
14 /
)
*
ERRO na linha 13:
ORA-14021: MAXVALUE must be specified for all columns
-
...
PARTITION bhrefo_i VALUES LESS THAN (606) TABLESPACE Maxsys_p_bhfore_I,
PARTITION riojan_i VALUES LESS THAN (615) TABLESPACE Maxsys_p_rioja_I,
PARTITION porflo_i VALUES LESS THAN (651) TABLESPACE Maxsys_p_poaflo_I
PARTITION maximum_i VALUES LESS THAN (MAXVALUE) TABLESPACE Maxvalue_...I
)
/
)
-
OK let try this way , and tank you for the attention.
-
Ok Worked correctly, thankful.
