doesn't the new 2.0 install script limit all the index and foreign key
names to something really small, like 18 characters? Elias did that
work so that the db scripts would work for Derby and DB2 and I believe
they are shorter than 30 characters.
-- Allen
Henri Yandell wrote:
On 10/30/05, Brad Smith <[EMAIL PROTECTED]> wrote:
Good afternoon -
I had one of my oracle developers look at create-raw.sql with an eye
towards making a db_oracle9.properties file. His major concern is that
the word Comment is a reserved word for Oracle and might be difficult to
work around (without hacking the source code of course).
His other concern is that Oracle still has a 30 character limit on
database object names. Some of the indexes (indicies?) created for
roller's database have names longer than 30 characters.
What would the potential be for revising the application so that the
Comment table is renamed?
+1 to do this before 2.0. Leave 1.3 as is.
And to revise the length of some of the
database object names?
Less important; they're not in the source code so the Oracle version
of the create db can either shorten them, or we can fix it in the long
term.
Hen
