Re: migrate from Access with SQL*Plus

From: ana <anacedent_at_hotmail.com>
Date: Thu, 30 Dec 2004 09:39:46 -0800
Message-ID: <33isq5F3v7rrrU1_at_individual.net>


<sky_diver__at_excite.com> wrote in message news:1104422003.958810.224290_at_c13g2000cwb.googlegroups.com...
> 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?

Also you might need to exercise caution regarding the case of table & column names.
Simply put, you'll want to UPPER the Table & Column names in Oracle. Received on Thu Dec 30 2004 - 18:39:46 CET

Original text of this message