文章存档
相关博文
- ·
- ·
- ·
- ·
- ·
- ·
- ·
- ·
- ·
- ·
分类： oracle
2007-02-28 17:48:02
出现错误提示:
ora-01450: maximum key length (51) exceeded
查找ora-01450得到原因:
ora-01450: maximum key length (string) exceeded
cause:
the combined length of all the columns specified in a create index statement exceeded the maximum index length. the maximum index length varies by operating system. the total index length is computed as the sum of the width of all indexed columns plus the number of indexed columns. date fields have a length of 7, character fields have their defined length, and numeric fields have a length of 22. numeric length = (precision/2) 1. if negative, add 1.
action:
select columns to be indexed so the total index length does not exceed the maximum index length for the operating system. see also your operating system-specific oracle documentation.
建立索引字段太长, 查建表语句:
create table osm_dml_10.osm_tab_14 (
col_0 varchar2(646),
col_44 date,
col_45 varchar2(457),
constraint osm_tab_14_pk primary key(col_0)
) organization index
tablespace osm_tabp_2 nocompress pctthreshold 1 including col_44 overflow
/
应该是iot表建立主建索引错误了. 提示最大长度为51, 测试一下(oracle 9204):
create table osm_dml_10.osm_tab_14 (
col_0 varchar2(50),
col_44 date,
col_45 varchar2(457),
constraint osm_tab_14_pk primary key(col_0)
) organization index
tablespace osm_tabp_2 nocompress pctthreshold 1 including col_44 overflow
/
一样出错, 改为49就可以了.
---new test sql:
create table osm_dml_10.osm_tab_5
(
col_5 number(24, 0),
col_13 char(30),
col_14 date,
col_15 float,
col_16 number(24, 0),
col_17 char(351),
col_18 date,
constraint osm_tab_5_pk primary key(col_13, col_16))
organization index tablespace osm_tabp_0 nocompress pctthreshold 1 including col_5 overflow;
cause error: ora-01450: maximum key length (51) exceeded
i think the complex primary index must exceeded 51 bytes, modify 30 to 20 is correct.
ora-01450: maximum key length (51) exceeded
查找ora-01450得到原因:
ora-01450: maximum key length (string) exceeded
cause:
the combined length of all the columns specified in a create index statement exceeded the maximum index length. the maximum index length varies by operating system. the total index length is computed as the sum of the width of all indexed columns plus the number of indexed columns. date fields have a length of 7, character fields have their defined length, and numeric fields have a length of 22. numeric length = (precision/2) 1. if negative, add 1.
action:
select columns to be indexed so the total index length does not exceed the maximum index length for the operating system. see also your operating system-specific oracle documentation.
建立索引字段太长, 查建表语句:
create table osm_dml_10.osm_tab_14 (
col_0 varchar2(646),
col_44 date,
col_45 varchar2(457),
constraint osm_tab_14_pk primary key(col_0)
) organization index
tablespace osm_tabp_2 nocompress pctthreshold 1 including col_44 overflow
/
应该是iot表建立主建索引错误了. 提示最大长度为51, 测试一下(oracle 9204):
create table osm_dml_10.osm_tab_14 (
col_0 varchar2(50),
col_44 date,
col_45 varchar2(457),
constraint osm_tab_14_pk primary key(col_0)
) organization index
tablespace osm_tabp_2 nocompress pctthreshold 1 including col_44 overflow
/
一样出错, 改为49就可以了.
---new test sql:
create table osm_dml_10.osm_tab_5
(
col_5 number(24, 0),
col_13 char(30),
col_14 date,
col_15 float,
col_16 number(24, 0),
col_17 char(351),
col_18 date,
constraint osm_tab_5_pk primary key(col_13, col_16))
organization index tablespace osm_tabp_0 nocompress pctthreshold 1 including col_5 overflow;
cause error: ora-01450: maximum key length (51) exceeded
i think the complex primary index must exceeded 51 bytes, modify 30 to 20 is correct.
给主人留下些什么吧！~~