Re: migrate from Access with SQL*Plus

From: Noel <tomekb_at_s_o_f_t_m_a_n.pl>
Date: Thu, 30 Dec 2004 16:55:47 +0100
Message-ID: <cr18kk$8v$1_at_atlantis.news.tpi.pl>


Dnia 12/30/2004 4:53 PM, Użytkownik sky_diver__at_excite.com napisał:

> I am migrating an Access database to a set of Oracle tables. I have
> already created the Oracle tables and now need to get the data over. I
> downloaded the Oracle Migration Workbench, but it seems its a little
> overkill. The OMW assumes you haven't created the Oracle tables yet.
> Do you know of any resources which will show me how to load the tables
> with SQL*Plus?
>

I would move access tables one by one into Oracle, using for example ODBC connection.
Then i would write INSERT INTO SELECT statetment to move data over the tables, then i would delete temporary access tables from Oracle.

-- 
Noel
Received on Thu Dec 30 2004 - 16:55:47 CET

Original text of this message