Any way to APPEND the whole table into your Oracle table, then RTRIM within Oracle? Forgive me if I'm over-simplifying.
>We have to migrate data from an asortment of Fox databases to Oracle.
>At present, as the Fox tables range from 2 DOS - VFP 5, we use ans external view to the fox table (IN 1) and an external view to the oracle table (IN 2). As Fox is fixed width, we are using the following p-code to do it.
>
>Select 1
>do while !EOF()
>scatter memvar
>insert into oratbl(b,c,d,...)
> values(RTRIM(b), RTRIM(c)....)
>select 1
>skip 1 in 1
>loop
>TABLEUPDATE(oratbl)
>The problem is, it takes an average of 2 seconds a record. We just did a SMALL table with 18000 records. I'm sure you can do the math, it ran all weekend.
>Can anyone suggest a faster way?
Kogo Michael Hogan
"Pinky, are you pondering what I'm pondering?"
I think so Brain, but "Snowball for Windows"?
Ideate Web Site