On Apr 28, 2008, at 8:28 PM, Glenn Everitt wrote:
This page describes how to create indexes for a MySQL 4 or 5 database
http://platform.xwiki.org/xwiki/bin/view/AdminGuide/Database+Administration#...
and I can create indexes on Oracle 10 with the exception of:
create index xwl_value on xwikilargestrings (xwl_value(50)); create index xwd_parent on xwikidoc (xwd_parent(50)); create index xwd_class_xml on xwikidoc (xwd_class_xml(20));
which are clob and varchar columns. xwd_class_xml CLOB(4000) xwd_parent VARCHAR(1533) xwl_value CLOB(4000)
Does anyone know how indexes should be created for these columns in Oracle?
I don't know the answer but it would be nice if you could update the page with Oracle information when you find out :) Thanks -Vincent