Martin Edenhofer wrote:
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?
It's possible only if you use "comment" in creation, insert and so on
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?
The max is 32
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/ --
_______________________________________________ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
I've another problem, in Oracle don't exist the autoincrement function, in all the tables there is an ID field of this type. The conseguence of this is that all the insert into this kind of tables without the ID field are wrong: ORA-01400: impossibile inserire NULL in ("OTRS"."TICKET_HISTORY"."ID") The solution may be the creation of a sequence and a trigger on all these tables that use the sequence value, I'm trying to implement this but it's a bit revolution on the creation schema script. bye graziano