Relational databases differ in naming conventions for tables, columns, and other objects. They also differ in how the object names are stored in the database and how they can be referred to in SQL queries and transactions. All database migration tools currently in use by customers, including SQL Developer, do a pretty good job of converting non-Oracle database schemas to Oracle. The most common issues that show up during a database migration to Oracle are discussed in the following sections.
The Oracle database has placed certain restrictions on what is allowed for naming/defining objects in the database and how these objects are subsequently accessed. Broadly, the object naming issues can be classified into four categories:
Use of special characters in object names
Use of reserved words in object names/definitions
Case-sensitive object names
Length of object names
SQL Developer assists in identifying, resolving these...