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 ><<<<<<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...
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!
signature.asc
Description: Digital signature
_______________________________________________ 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/
