Exporting Microsoft Access Tables to Oracle

From: <rgbautista_at_hotmail.com>
Date: 2000/07/22
Message-ID: <8lbgb3$n79$1@nnrp1.deja.com>#1/1

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