That was my initial thought, but when I log into the database using the rt user with sqlplus, as the account that runs the apache daemon no less, I can issue a 'desc attachments' command and a 'desc "Attachments"' command and both return the table structure.
----- Original Message ----- From: "Joop van de Wege" <[email protected]> To: "Nick Yonko" <[email protected]> Cc: [email protected] Sent: Tuesday, June 2, 2009 11:14:19 PM GMT -08:00 US/Canada Pacific Subject: Re: [rt-users] RT on Oracle - ORA-04043 object Attachments does not exist Nick Yonko wrote: > I am getting an error when rt-mailgate sends an email to RT saying that the > Attachments object does not exist. The email is received and the details of > it are written to the database, however the body of the email is missing. > Has anyone dealt with this? I am on Oracle 10.2.0, running RT on openSuSE > 11.1 using the full administrator install of the Oracle client. Can you login into the database using sqlplus with user rt_user/... and do a: desc attachments This should output the table structure of the Attachments table. Looks like you're missing one table. What could be the case, no pun indented, is that somehow the table was created using quotes which means Oracle is then case sensitive. Regards, Joop _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [email protected] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
