AS anyone had any experience migration Ingress to Oracle? All I have in the Copy.Out file (this gives me the data structure for the tables) and the exported flatfiles. My problem is the out put of the files. ie for charactor data length of 6 the out put would be:

6ABCDEF

The same field if only 6 chars in length would be:

5ABCDE

The file is table delimieated but how do I use the terminated by whitespace clause if the is one field that could hold sentences with spaces in the string?

Any help or ideas would be gretly appricated.


Gary M