Thanks Christian!
_________________________________
Thorne Lawler
Systems Administrator
t: +61 3 8329 2026
f: +61 3 9326 7588
e: [EMAIL PROTECTED]
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
<<<<<<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 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/
_______________________________________________
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/
