>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

If Oracle structure already exists then you, probably, could create Remote Views and populate them with VFP data. At least here you could check datatypes, etc. programmatically.