Re: Data migration from Access to Oracle
From: DriftWood <drift_wood_at_my-deja.com>
Date: Tue, 05 Dec 2000 17:33:05 GMT
Message-ID: <90j8sh$csv$1_at_nnrp1.deja.com>
"It is a kind of good deed to say well; and yet words are not deeds. -William Shakespeare"
Date: Tue, 05 Dec 2000 17:33:05 GMT
Message-ID: <90j8sh$csv$1_at_nnrp1.deja.com>
I would suggest one of two possible solutions. The easiest is to use the Oracle ODBC driver to export the table directly into the appropriate schema. BEFORE you do that double check the table and column names to be all UPPER CASE and not to include invalid (for Oracle) characters such as spaces (replace these with an underscode if you like).
The other alternative if you have a lot of migrating to do is to download the Oracle Migration Workbence from OTN (technet.oracle.com -- registration is free) and use it to do the migration for you.
-cheers
DW
"It is a kind of good deed to say well; and yet words are not deeds. -William Shakespeare"
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Tue Dec 05 2000 - 18:33:05 CET