[xwiki-devs] Oracle Database Index

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? Thanks for any help Glenn Everitt -- View this message in context: http://www.nabble.com/Oracle-Database-Index-tp16945142p16945142.html Sent from the XWiki- Dev mailing list archive at Nabble.com.