migrate from Access with SQL*Plus

[Guest]

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?

[Noel]

Dnia 12/30/2004 4:53 PM, U¿ytkownik sky_diver_@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

[Ana C. Dent]

<sky_diver_@excite.com> wrote in message
news:1104422003.958810.224290@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.

[psm]

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_@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?