Alfresco 4.0.d and Oracle DB

igomez — Tue, 28 Feb 2012 10:42:16 GMT

Hi.I was trying to deploy Alfresco 4.0.D Community with Oracle.Previously I had an Alfresco 4.0.B with Oracle DB patch ( http://forge.alfresco.com/gf/project/oracle/frs/ ) and it woked ok so I compared the DB structure of the 4.0.d and the 4.0.b version and I saw that the only change is the introduc

Re: Alfresco 4.0.d and Oracle DB

kevindorr — Wed, 14 Mar 2012 13:25:13 GMT

One thing that I've found useful over time is to ignore what the error message says and look up the Oracle error code that is returned, in this case ORA-00942. Sometimes what Oracle reports the error to be isn't always exactly what it means.

If you Google ORA-00942, there are a few pages that have some useful information - here is one that I found:
http://www.adp-gmbh.ch/ora/err/ora_00942.html

Based on that post, it looks like Oracle might return this error if you forgot to set the permissions correctly on you new index - you might give that a try and see if it helps!

Kevin Dorr
Alfresco

topic Alfresco 4.0.d and Oracle DB in Alfresco Archive

Alfresco 4.0.d and Oracle DB

Re: Alfresco 4.0.d and Oracle DB