Search Results

Read the error message carefully and look at your script to find out why the done can't be found:
while read match
do <-----------+
sqlplus user/pwd@table <<EOF ...

describe is NOT a command known to the shell. I think you need to do the loop inside ORACLE.

What be the input data structure that db2 expects? Is it satisfied by your ORACLE dump?
Please post the target table definition and a reasonable part of the input file.

The file name you choose should not make any difference to your export or import commands. They are pretty much just a label to find the data. There is no inference on the 'bit after the dot' like...

Sonny,

How long is too long to run? How many indexes do you have on the table? How many constraints, including foreign keys do you have? How many row level triggers do you have and what do they...

You might be able to get the data into Oracle in a number of ways.

The Oracle command sqlldr to load the data from an input file
The Oracle command imp if the file format is compatible with...