Re: migrate from Access with SQL*Plus

From: psm <psm_at_wanadoo.nl>
Date: Fri, 31 Dec 2004 09:13:03 +0100
Message-ID: <cr31lu$8i1$1_at_voyager.news.surf.net>


Create an extra schema, use OMW to migrate to this schema including all the unwanted stuff, use toad to create INSERT INTO scripts from the extra schema. Use SQLplus or toad to load these into your own schema. Dump the extra schema. Done.

sky_diver__at_excite.com wrote:

> 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?
>
Received on Fri Dec 31 2004 - 09:13:03 CET

Original text of this message