Hmm, I thought Oracle 10 got rid of those constraints. Did the error also spit out the query used for the command that failed?
I have an install working on Oracle 8, so I know its possible, one just has to be careful with the names. Part of the problem is that any type (such as dmHTML) that has an array of associated types has an extra table. So if dmHTML has associated types aObjects, then there is a table created that is dmHTML_aObjects. So you have to be careful to not let that combined length be over 30 chars. That doesn't answer your question directly, but I know its possible to install on oracle, but I can't remember now if I had to change some definitions to get rid of long names. Tomek On Fri, Mar 6, 2009 at 5:37 AM, pedrobl <[email protected]> wrote: > > > Trying to install farcry 5.1.0 on a system with Solaris, Coldfusion 7 > and Oracle 10, I get the following error when creating tables: > "RULES): Creating ruleRichText table." > > Error details: > Detail ORA-00972: identifier is too long > ErrorCode 42000 > Message Error Executing Database Query. > NativeErrorCode 972 > > It seems like oracle table names can't be longer than 30 characters. > Any ideas? TIA, > > Pedro. > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "farcry-dev" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/farcry-dev?hl=en -~----------~----~----~----~------~----~------~--~---
