tag:blogger.com,1999:blog-20612393.post2558493896986759414..comments2023-09-29T21:26:11.876+07:00Comments on Surachart Opun's Blog: Create Index: ORA-01450: maximum key length (6398) exceededSurachart Opunhttp://www.blogger.com/profile/05646896104906516714noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-20612393.post-86206214062510194402008-06-23T22:05:00.000+07:002008-06-23T22:05:00.000+07:00thank you for your comment.I tried to think about ...thank you for your comment.<BR/><BR/>I tried to think about the key length when we create index.<BR/><BR/>anyway, <BR/><BR/>SQL> create tablespace TEST2 datafile '/.../test2.dbf' size 100M AUTOEXTEND ON NEXT 10M MAXSIZE unlimited LOGGING BLOCKSIZE <B>32k</B> EXTENT MANAGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE MANAGEMENT AUTO;<BR/><BR/>So,<BR/><BR/>SQL> create index idx_temp01 on temp01(data1,Surachart Opunhttps://www.blogger.com/profile/05646896104906516714noreply@blogger.comtag:blogger.com,1999:blog-20612393.post-49830666395654479852008-06-23T19:52:00.000+07:002008-06-23T19:52:00.000+07:00Did you try playing with the "blocksize" parameter...Did you try playing with the "blocksize" parameter in the "create tablespace" statement...<BR/><BR/>SQL> select dbms_metadata.get_ddl('TABLESPACE','INDEX01') <BR/> 2 from dual;<BR/><BR/>DBMS_METADATA.GET_DDL('TABLESPACE','INDEX01')<BR/>----------------------------------------------------------------------------<BR/><BR/> CREATE TABLESPACE "INDEX01" DATAFILE<BR/> '/u01/oracle/oradata/ONTW/Marco Gralikehttps://www.blogger.com/profile/12810709424310804316noreply@blogger.com