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...
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...
Thanks to Oracle DataPump I now have double quotes in all of my code objects (except views). When I compare my newly imported DB objects to production they all show up as different because they now have
Create or Replace Function\ Package\ Procedure\ Trigger "OBJECT_NAME"
instead of
Create...