MS Access to Oracle

The inexpensive route would be to write a script in Access Basic that receives a list of mdbs from a table or file directory. You could then crank out the necessary table definitions in a text file and run it through SQL*PLUS. Erwin is a pretty good case tool but I think it runs between 1500 and 2000. I have done a lot of data conversions between Access and Oracle; it can be quite messy.

Things to look out for:

        Access can have split field names <field name> where Oracle requires an underscore <field_name>.

        Access can have a number for a field name <1> where Oracle can not have a field name begin with a number. If you have imported data from spreadsheets into Access with no field names, you will run into this problem. Erwin will ignore the number fields during it's conversion.

If you are just begining to work with Oracle, you will want to review the administrator sections on creating tablespaces and segments. Access will grow and grow till you fill up the entire disk. Oracle allows for specific allocation of table and index sizes, so you have to be much more aware of what your data is doing, otherwise you will be hounded by un-extendable segments.

Regards,

Park Received on Mon Feb 12 1996 - 00:00:00 CET