We are migrating from a rather huge MS Access database to a Oracle 7.3 Database
I am looking for direction as to any examples/case studies that I can use to understand this better
thanks in advance
Oracle has an excellent tool called the Oracle Migration Workbench. Basically and A to Z tool for migration many non-Oracle databases to Oracle. I believe its free too.
See technet.oracle.com under migration...
You could just create an ODBC connection to the Oracle database and go into access and do a "Save as/Export" to the ODBC Oracle database. The thing to be careful with is to make sure the exported table name is in uppercase or you may have problems accessing it.
Click Here to Expand Forum to Full Width