What are the challenges you face when working across database platforms? Take the survey

How cancel auto change uppercase to lowercase of schema name

When i import database to working folder by "Source Control for Oracle" software, it's automatically changes case of the schema name from upper case to the lower case in all packages, procedures etc.
How to disable this option?


  • Options
    Eddie DEddie D Posts: 1,789 Rose Gold 5
    Hi, thank you for your forum post.

    Source Control for Oracle does change the case. It occurs quite early in the comparison processes that take place while populating data from the schema or repository. I believe this action is taken to make the comparison easier. Sadly there is no option to turn off this action.

    I believe that Oracle will upper cases all nonquoted identifiers, you could argue that the Redgate Tools are following this practice.

    If you would like to see an option that turns off this automatic change of case for the schema name, please submit a new feature suggestion in the Oracle Tools User Voice Forum:

    Eddie Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
Sign In or Register to comment.