While migrating using sqldeveloper-3.1.07.42 to oracle 11g release 2
it is capitalising all the table names and SP names.
is there any way aviable to preserve the case of table name and SP name
Edited by: 944768 on Dec 19, 2012 11:58 PM
I believe that this one could help: In SQL Developer, click Tools, then Preferences, then Migration: Identifier Options, and ensure that the setting is correct for the Is Quoted Identifier On option (that is, that the setting reflects the database to be migrated).
But I will double-check it.
I did some research. No good news. There is an Enhancement Request open to get this improved in SQL Developer. Please read the following note from My Oracle Support: How To Migrate Non-Oracle Databases To Oracle With Case Sensitive Object Names Using SQL*Developer ? (Doc ID 1292434.1)
< contents of the MOS document removed by a moderator >
< MOS documents are only available to people with MOS credentials >
< publishing such content via a free public forum such as this one is in violation of your MOS privileges >