The reason behind the conversion is: the number field in Access database has
space in it. Access doesn't care. But Oracle is strict. Therefore, change
all blanks to 0 or null and then do the conversion. The data type change
will be gone. - victor
<rgbautista_at_hotmail.com> wrote in message
news:8lbgb3$n79$1_at_nnrp1.deja.com...
> I exported some Microsoft Access Tables to Oracle 8 using Oracle's ODBC
> Driver. The tables were properly exported including the data.
> However, I noticed that Oracle changed the numeric fields of some
> tables to varchar. I need these fields to be in numeric. When I
> attempt to change the data type using Schema Manager I get the
> error: "ORA-01439 column to be modified must be empty to change data
> type".
>
> Is there an easy way for me to export these tables properly or to
> change the data types easily?
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Sat Jul 22 2000 - 00:00:00 CDT
