Tiki does not install clean on Oracle

• Error

many object names too long for oracle which has max size of 30 for any object (column, table, sequence, etc.)

able to modify some items such as sequence and trigger that are internal to db and not in tiki code.

initial oracle-1.9-oci8.sql had many errors including the use of datatype integer and auto-increment which doe not exist in oracle. additional insert to blob column not formed to use oracle utl_raw.cast_to_raw. oracle quote in sql field insert should be two quotes ('') instead of backslash quote (\')

main tables still not available
tiki_content_templates_sections
tiki_forums
because outbound_mails_for_inbound_mails column
tiki_live_support_message_comments

is there a workaround that if I change the object name in the database to be <=30, that the code will not abort.

- Usage of "CLOB" in Oracle different from "Text" in MySQL, so usage of every table has to be checked.
(especially where LOB-Index is used as a reference (e.g. tiki_languages))

- Oracle can not use CLOBs for indices so search functionality has to be checked (fulltext index?)

Oracle support dropped.
Sorry.

This bug has been demonstrated on show2.tiki.org

Please demonstrate your bug on show2.tiki.org