[ic] testing latest install against oracle

[Jason]

Jason wrote:
> I am testing the mar-31 nightly build trying to get it running on RedHat 
> Linux and Oracle 9i. configure and makecat appear to work fine outside 
> of the small fixable problem with vlink.c not compiling automatically.
> 
> The real problem I run into is trying to startup interchange and make it 
> through the database create scripts. I noticed that the oracle config 
> files are different than the mysql config files. Is this because mysql 
> is under more active development?
> 
> I found the following problems at startup.
> 
> 1. creating indexes on the options table. The oracle configs ask for 
> indexes and columns that the mysql file does not. Limiting the indexes 
> to the indexes specified in the mysql file fixes the problem for oracle.
> 2. importing data to options table, 'inserted value too large for column'
> 2. variants table fails, 'default username feature not supported'
> 

Sorry for posting the last message in html.

Additionally, I updated the variants.ora file with ifdef SQLUSER and 
SQLPASS commands and got past the default user error. Then there was an 
error regarding the comment column. Apparently the comment column did 
not automatically get renamed to comment_field and was still a text 
datatype which fails. I updated to comment_field and varchar2(2000) and 
create/import worked.