Hi OTRS folks,
I am having difficulty installing OTRS into an Oracle DB. The
otrs-schema.oracle.sql script finishes, but produces some errors which
worry me:
>>>>>>COPY>>>>>>
CREATE INDEX article_message_id ON article (a_message_id)
*
ERROR at line 1:
ORA-01450: maximum key length (3218) exceeded
<<<<<<COPY<<<<<<
and
>>>>>>COPY>>>>>>
ALTER TABLE standard_response_attachment ADD CONSTRAINT
standard_response_attachment_PK PRIMARY KEY (id)
*
ERROR at line 1:
ORA-00972: identifier is too long
DROP SEQUENCE standard_response_attachment_seq
*
ERROR at line 1:
ORA-00972: identifier is too long
CREATE SEQUENCE standard_response_attachment_seq
*
ERROR at line 1:
ORA-00972: identifier is too long
CREATE OR REPLACE TRIGGER standard_response_attachment_seq_t
*
ERROR at line 1:
ORA-00972: identifier is too long
<<<<<<COPY<<<<<<
After this, initial_insert.sql bombs out horribly, so I assume it's
finding some discrepancy with the tables created by the above.
Particularly worrying is the "ORA-00972: identifier is too long", since
Oracle support says:
"Cause: The name of a schema object exceeds 30 characters. Schema
objects are tables, clusters, views, indexes, synonyms, tablespaces, and
usernames.
Action: Shorten the name to 30 characters or less."
Is there something I need to change? If so, where and how do I change it?
I have seen one query just like this posted by Florent Guiliani, and I
mailed F.G. directly but got no reply. The answer he recieved on-list
was a little cryptic...
Thanks in advance.
--
_________________________________
Thorne Lawler
Systems Administrator
t: +61 3 8329 2026
f: +61 3 9326 7588
e: [EMAIL PROTECTED]
Microlistics
A Dawson Group Company
www.microlistics.com.au
_________________________________
_______________________________________________
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
Support oder Consulting für Ihr OTRS System?
=> http://www.otrs.de/
