RE: migrating sybase to oracle

"This makes the Oracle object names case-sensitive"
 
Which is in my opinion a very bad thing to do, and potentially
unnecessary unless the application code calls to Oracle were case
sensitive.  If the application was case sensitive I would vote for
modifying the code to use uppercase.
 

-- Mark D Powell -- 
Phone (313) 592-5148 

 


________________________________

        From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Thomas Day
        Sent: Wednesday, March 25, 2009 2:19 PM
        To: oracledbaquestions@xxxxxxxxx
        Cc: oracle-l@xxxxxxxxxxxxx
        Subject: Re: migrating sybase to oracle
        
        

        i don't have any answers to your specific questions but I did
help someone else migrate sybase to Oracle several years ago.  one of
his problems was that oracle object names are case-insensitive while
sybase object names are case-sensitive.  The way around this was to put
all the object names in double quotes (").  This makes the Oracle object
names case-sensitive.

Other related posts: