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