[otrs] Oracle installation: ORA-00972 identifier is too long

26 Mar 2006

      Hi OTRS folks,

Just sending this again in case it didn't reach the list the first time,
since I have had no reply, and haven't even received a copy of my own
message...

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
<<<<<
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
<<<<<

[otrs] Oracle installation: ORA-00972 identifier is too long

Thorne Lawler