Oracle User Object Comparison Question

[Global Client Solutions Support]

What objects do you query in Oracle to do the user object comparison?

Oracle DataPump causes every Object Name to be in Double Quotes which throws off the comparison. We are trying to work through this with Oracle support but they are indicating it is a problem with PL/SQL Developer. Any help you can provide would be very appreciated.

 

[Marco Kalter]

It depends on the object type. For PL/SQL objects we query the all_objects and all_source views.

 

[Global Client Solutions Support]

When you are creating copies of a schema from production for development or staging using DataPump it causes a problem where every PL/SQL object has double quotes around the name of the object and the User Object Compare shows these as not matching. Is there any way you can handle this in PL/SQL Developer because Oracle doesn't seem interested in changing it.

 

[Marco Kalter]

We'll consider an option for this. I have added this to the list of enhancement requests.