[rt-users] RT on Oracle - ORA-04043 object Attachments does not exist

[Joop van de Wege]

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