Hi!
Another fresh installation (war 11.10.2) on sles12r5 (tomcat9) + oracle 11gr2 database. Using documentation. The one step requres to create indexes. Every string in provided script gives me an error:
SQL> create index xwl_value on xwikilargestrings (xwl_value(50));
create index xwl_value on xwikilargestrings (xwl_value(50))
*
ERROR at line 1:
ORA-00904: "XWL_VALUE": invalid identifier
SQL> create index xwl_value on xwikilargestrings (xwl_value);
create index xwl_value on xwikilargestrings (xwl_value)
*
ERROR at line 1:
ORA-02327: cannot create index on expression with datatype LOB
How to create required indexes in oracle database? Maybe it already created during flawour installation? Simple count of already created indexes show us that 117 indexes are already created…
SQL> select count(1) from user_indexes where TABLE_NAME like 'XWIKI%';
COUNT(1)
----------
117
Regards, Vadim