SQL> create table test(aaa varchar(4000), bbb varchar(3000));
Table created.
SQL> create index idx_test on test(aaa,bbb);
create index idx_test on test(aaa,bbb)
*
ERROR at line 1:
ORA-01450: maximum key length (6398) exceeded
SQL> alter system set db_cache_size=20M;
System altered.
SQL> alter system set db_16K_cache_size=4M;
System altered.
SQL> create tablespace zhangqiaoc_16k datafile '/u01/oracle9/app/oracle/oradata/SOURCE9/tbs16K.dbf' size 50M blocksize 16k;
Tablespace created.
SQL> create index idx_test on test(aaa,bbb) tablespace zhangqiaoc_16k;
Index created.
可以看出,ORACLE限制索引列的数据必须要在一个数据块内,估计是为了效率考虑
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/8242091/viewspace-612675/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/8242091/viewspace-612675/