Re: Converting MS-Access to Oracle

If you do it manually.....
Try exporting the tables to oracle schema via ODBC.....The table will be created and populated with data. TO control what table space the object goes into set the default tablespace for the user in oracle to which you want to export to then export those objects from access. You will have to build indexes and primary keys....manually. STORAGE and PARALLEL parameters are the default of the tablespace.....

Hint: make sure all the names of columns and tables in ACCESS are UPPER_CASE no spaces! Also make sure the length of some of the fields are ok fro the data as well as datatypes....use only TEXT and NUMBERS.....if possible

Brad

Thanh Vo wrote:

> Hi folks
> we have existing MS-Access database.
> we want to convert it to Oracle server
> and access it via ODBC.
> Is there any tool, free or commercial ?
> Thanks
Received on Wed Oct 07 1998 - 15:32:27 CDT