Oracle installation: ORA-00972 identifier is too long

14 Mar 2006


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

Thorne Lawler

tags

participants (1)