28 Apr
2008
28 Apr
'08
8:45 p.m.
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