Re: migrating data from SQL 7.0 to ORACLE

On Thu, 3 May 2001, KZeuchnospam_at_hotmail.com wrote:

>> The conversion process tells us that we are not allowed > to
>> have more than 1 column of type LONG in a table. Is ther a
>> possible work around for this restriction.

You can use a LOB column.

>> Also we had one column in the SQL 7.0 tables that was an
>> identity column(auto-incrementing numeric column). We noticed
>> that on the

 conversion
>> to ORALCE the field was converted to a column of type NUMBER .
>> Is there a method of creating a column that is and
>> auto-incrementing column aside

 from
>> ROWID?
Yes, sequences will accomplish this.

-- 
Galen
I don't want to be the rock.  Yeah, okay, what do you want to be?
I want to be the piece of glass.