This manual provides supplementary reference information about migrating a database from Microsoft Access 97, 2000, XP (2002), 2003, or 2007 to Oracle. It describes several differences between Microsoft Access and Oracle. It also outlines how those differences are dealt with by the Oracle SQL Developer during the conversion process.


This reference guide is intended for anyone who is involved in migrating a Microsoft Access database to Oracle using SQL Developer.

You should be familiar with relational database concepts. You should also be familiar with the operating system environments where you are running Microsoft Access and Oracle.

Documentation Accessibility

For information about Oracle's commitment to accessibility, visit the Oracle Accessibility Program website at

Access to Oracle Support

Oracle customers have access to electronic support through My Oracle Support. For information, visit or visit if you are hearing impaired.

Related Documents

For information about using Oracle SQL Developer, see Oracle SQL Developer User's Guide and the SQL Developer online help.

For information about installing Oracle SQL Developer, see Oracle SQL Developer Installation Guide.

Oracle error message documentation is only available in HTML. If you only have access to the Oracle Documentation CD, you can browse the error messages by range. Once you find the specific range, use your browser's "find in page" feature to locate the specific message. When connected to the Internet, you can search for a specific error message using the error message search feature of the Oracle online documentation.

To download free release notes, installation documentation, white papers, or other collateral, go to the Oracle Technology Network (OTN) at

The documentation section of the OTN Web site is located at


The following text conventions are used in this document:

Convention Meaning
boldface Boldface type indicates graphical user interface elements associated with an action, or terms defined in text.
italic Italic type indicates book titles, emphasis, or placeholder variables for which you supply particular values.
monospace Monospace type indicates commands within a paragraph, URLs, code in examples, text that appears on the screen, or text that you enter.