-
1. Re: Oracle DB - ORA-00972: identifier is too long
vrockai Nov 27, 2012 11:08 AM (in response to uwew)Hi,
This is a known issue and it was resolved today. The problem is caused by adapting the feature "Isolated-database configuration". To learn more about isolated more see:
http://docs.jboss.org/exojcr/1.15.0-GA/developer/en-US/html_single/#d0e2612
It's easy to fix, you just have to add new property to JCR workspace configuration for some workspaces:
https://github.com/gatein/gatein-portal/commit/03dd1652b92fc16ec0f04ded5afae8ea309f38c6
If the "db-tablename-suffix" property is not specified the indentifier names are based on the workspace name. If the workspace name is too long, you got the ORA-00972 error. If the "db-tablename-suffix" property is set (to some shorter variant), the value from property is used in oracle identifier names.
Hope this helps,
Viliam
-
2. Re: Oracle DB - ORA-00972: identifier is too long
uwew Nov 28, 2012 2:35 AM (in response to vrockai)Thanks Viliam!
Your solution works.
Kind Regards,
Uwe