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

Hi Thorne, On Mon, Mar 27, 2006 at 10:40:23AM +1100, Thorne Lawler wrote:

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

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

Please check out the latest otrs-schema.oracle.sql and otrs-schema-post.oracle.sql file for the 2.0 branch from our cvs and try it with these files. We fixed some problems a while ago and the new files will be available in the next OTRS release. Please also see the CHANGES file in cvs for the different fixes Oracle. Best regards, Christian -- ((otrs)) :: OTRS GmbH :: Europaring 4 :: D - 94315 Straubing Fon: +49 (0) 9421 1862 760 :: Fax: +49 (0) 9421 1862 769 http://www.otrs.com/ :: Communication with success!