Hi all,
we are planning on migrating a Sybase ASE database to Oracle 11g by using SQL Developer. Although for IBM DB2 and MS Access,the documentation clearly states SQL Developer's native behavior when encountering Oracle reserved words in the source db, this is not clearly stated for Sybase.
IBM DB2
Reserved words differ between Oracle and IBM DB2. Some Oracle reserved words are
valid object or column names in IBM DB2. Use of reserved words as schema object
names makes it impossible to use the same names across databases. SQL Developer
appends an underscore and a numeric digit (_n) to the end of the name of an IBM DB2
object that is an Oracle reserved word.
MS ACCESS
The following table lists, in tabular format, words that are reserved in Oracle. SQL
Developer appends an underscore to any object names that conflict with these
reserved words.
Can anyone share their experience in migrating from Sybase to Oracle with SQL Developer and let us know what the default behavior is? (underscore as a suffix, underscore as a prefix, _n, etc)
Thanks
Tony