How can we help you today? How can we help you today?

Schema names being identified using double quotes

When using Schema Compare - I have a strange situation where all objects for a particular owner are having the Owner being enclose in Double quotes:

CREATE OR REPLACE PACKAGE "PERFORMANCE".attribution_comparison_pkg IS


Wheras other schemas do not have this issue:

CREATE OR REPLACE PACKAGE performance_api.composites IS

We would the generated code to be consistent.

I know that we can ignore double quotes but I would want the generated script for new objects to not have double quotes.

Any help would be appreciated.

Terry Sullivan
0

Comments

1 comment

Sort by
  • Christian Perez
    Official comment

    Hi Terry,

     

    Thanks for reaching out to Redgate Support, sorry to hear you are having a little trouble with your Schema Compare for Oracle Behavior, I have a few pathfinder questions to try and figure out what we need to do here.

    Is the behavior you are reporting occurring when you generate the Deployment script for your comparison? Do you notice anything when reviewing the Comparison pane for the PERFORMANCE schema? I am reviewing options in the application and one option besides ignoring double quotes would be the option “ExcludeSchemaNames”, which if nothing else would force the generated code to be consistent.

     

     

    Christian Perez

Add comment

Please sign in to leave a comment.