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

Thanks Christian! _________________________________ Thorne Lawler Systems Administrator t: +61 3 8329 2026 f: +61 3 9326 7588 e: thorne.lawler@microlistics.com.au Microlistics A Dawson Group Company www.microlistics.com.au _________________________________ Christian Schoepplein wrote:

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