Hi Graziano, On Wed, Jul 23, 2003 at 03:20:30PM +0200, Ruffoni Graziano wrote:
I would like to install OTRS using Oracle DB and I've got some problems. The first error has been during the generation of SQL script for schema cration using Torque 3.0.2 due to an error in otrs-schema.sql with the <app-data> TAG, I've solved removing it. After this I've got errors creating tables because some tables names are Oracle keywords: comment
That means it's not possible to is a column named comment?
session
This is the session table, you can drop it (it's just used for the database session backend. default is the IPC (RAM) session backend).
and some index names are too long: index_customer_preferences_user_id index_ticket_loop_protection_sent_to index_ticket_loop_protection_sent_date
You can cut the index names... but what is the max. length? PS: It would be better to move on the dev-mailing list to discuss this kind of topic. :)
Thanks graziano
-Martin -- Martin Edenhofer - <martin at edenhofer.de> - http://martin.edenhofer.de/ --