Re: Exporting Microsoft Access Tables to Oracle

rgbautista_at_hotmail.com wrote:
>
> 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?

1. Export data into temp table, Assume that varchar field has name TMPSTR
2. Add numeric field TMPNUM (alter table add(TMPNUM number))
3. update TABLE set TMPNUM=to_number(TMPSTR)
4. move data to your table w/o TMPSTR
   • Best regards, Igor Ushkalo (igorus!) - igorus(at)mail.ru, ICQ #19972198