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.