Re: Porting Access tables into Oracle

Hi Jane,

I did this using the Oracle Migration Workbench (free download). I'm not sure if that's the tool you say you've already tried, but I found it fantastic.

I'm not sure what you mean by a "Binary" datatype in Access. In any event though, you can control the conversion of datatypes. For instance, with text files, you can dictate if you want them to become VARCHAR2 or CLOB's.

The tool constructs sequences and before insert triggers in place of the Access "Autonumber" datatype (I know you said you don't have those tho'..the point is, the tool is well adapted to migrating Access to Oracle).

Further, it allows you to create a complete script including SQL*Loader files for the data..this makes it easy to provide documentation to the client if need be.

That tool would be my choice should I have to do this again.

However, if you don't need the data, and don't have a lot of tables, it may be quickest to simply create the tables in Oracle from scratch.

I must admit that the OMW tool saved me many days of work though.

Best regards,

Steve

Jane wrote:

> I've a Access 2002 MDB file which containing just tables.
> I tried a porting tool by Oracle before, but it said some data type are not
> supported, so I can't use it.
>
> The types i m using are just Binary, Text, ineteger and decimals
>
> How can I port these tables into Oracle Server without the need to create
> the tables in Oracle manually ( Oracle 9i) ??
>
> The data can be ignored, I only need the schema.
>
> Thanks
Received on Thu Aug 21 2003 - 12:03:10 CDT