>>I used Upsizing wizard to port data from VFP-5.0 to Oracle 7.3
>>I was able to port partially. The following errors occured.
>>
>>1. Char data type is not in reality converted to VARCHAR2 into oracle
>>i.e. a field of width char(30) having 'Satya' is ported as 'Satya '
>>with spaces .
>>
>>2. A table with column name SECTION was exported as SECTION_
>>
>>3. logical data type is exported as numeric 1 or 0 .
>>But I want them to be char 1 or 0 . i.e. '1' or '0' .
>>
>>4. Even memo fields are having 400 charecters , VARCHAR2(500) is not sufficient and not even VARCHAR2(2000). They need to be essentially declared as long .
>>
>>5. I already have the structure in Oracle. I want VFP rows only to be copied to oracle and not structure. But the table in oracle is being over written .
>>
>>And some other errors , which I manipulated in Oracle.
>>
>>Any body, having solutions can mail me at,
>>
>>spvedulla@hotmail.com
>> or
>>spvedula@rocketmail.com
>
>You can do as Edward explained, or...
>
>If you have access to the server Oracle is on, and you have sufficient rights on the server to execute Oracle's SQL-Loader utility, and your Oracle table structures (field order and Oracle column data types are equivalent) then:
>You can create comma delimited text files with each table's data. You would have to do some conversion on your logical fields to make the data '0' or '1'. You would also have to handle memo fields as well. Upload these .txt files to the server and use SQLLDR to load the data into the Oracle tables.
>
>With each .txt file for SQLLDR, you can have a parameter file (.par) and a control file (.ctl). The control file is referenced by the .par file. The syntax on the server is: SQLLDR parfile=filename.par
>
>If you want to pursue this method, I can e-mail you examples of .par and .ctl files.


I also used that method. Nut my main problem is ,

1. if the data say text field contains " (quotes).

2. and major thing is if the field contains 'enter key' which was used in
memo fields mainly.

I was not able to solve the enter key problem in memo fields. I put one quote extra i.e. "" if " is there.


Please send the examples to me , so that I could solve that problem.

Thanks for your keen interest .

My e-mail address is spvedulla@hotmail.com
or
spvedula@rocketmail.com