Just resolved the issue on my own for the installation! The constraints were created before the insert. Then we tried several times the insert, so the sequence were not initialised.
After a re_run of: 1) otrs-schema.oracle.sql 2) initial_insert.sql 2) otrs-schema-post.oracle.sql All the data and structure is inserted fine. But my second question is still to be answered, does someone allready running OTRS 2.x on Oracle with Success, what are the things to care about? Thank you! Cordialement, Bastien Leblanc - Administrateur Peoplesoft CAPGEMINI int: 30 01 69 ext: 01 56 33 01 69 -----Message d'origine----- De : [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] De la part de EXT / CAP GEMINI LEBLANC Bastien Envoyé : lundi 16 octobre 2006 18:01 À : otrs@otrs.org Objet : [otrs] Installation on Oracle 9.2 Hi, I am trying to install OTRS 2.1 for my client under Oracle 9.2. The problem comes with the initial insert script. All the insert statements are based on the "AUTO_INCREMENT" status of the tables. But this doesn't exist in Oracle. I found one mail in the mailing list archives about someone writing a patch. My question is, is there someone who allready wrote a patch for these insert (and maybe also for the rest of the code?) Second question, do you recommand using Oracle anyway? Thank you for your answer Regards, Bastien Leblanc - Peoplesoft Administrator CAPGEMINI _______________________________________________ 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 orr consulting for your OTRS system? => http://www.otrs.com/
