What is the purpose of migrating Microsoft Access to RDBMS Oracle?

Answer 1

You migrate to a larger scale DB for reasons such as the limitations that access may have. Access is traditionally a desktop database,but it is used in large corporations that may require control of users and other features that will and can make life so much easier. Unfortunately, Access does have its limitations and its performance begins to degrade depending for example, when you have extremely large tables, the user population increases considerably, then access time suffers. Migrating to Oracle which is very competent and has a reliable RDBMS; can hold many more tables than Access and was built to handle a large volume of traffic which is not limited to only users, but processes many many more transactions than Access can. Hope this helps.