Comparing an Oracle Database 18c Express Edition with an Oracle Database 11g

Hello,

I need to compare a test db (which is an Oracle Database 18c Express Edition Release 18.0.0.0.0) with a production db (which is an Oracle Database 11g Release 11.2.0.1.0). The problem is that the Schema Compare marks as different the functions, the procedures, the triggers and the packages even if the only difference between them is that the objects from production have the NONEDITIONABLE keyword in the header objects. Is there a setting that can be made in the Schema Compare for Oracle so that the NONEDITIONABLE keyword should be skipped from compare ? Or it is a bug in the Schema Compare ?

Thank you,
Andreea

Best Answer

  • Sergio RSergio R Posts: 600 Rose Gold 5
    Accepted Answer
    Hi Andreea,

    There isn't an option to ignore this keyword.

    Though we understand that this keyword is not valid in 11G, Schema Compare is not designed to automatically remove incompatible keywords (if the incompatibility is cuased by comparing different versions of the database), as a result of this we do not consider this to be a bug.

    If you wish to you can suggest this as a future improvement on our uservoice channel: https://redgate.uservoice.com/forums/174014-oracle-tools
    That channel is managed by the product management team who use it as an important source when deciding what features to add or enhance in the tool.

    Kind Regards,

    Sergio
    Product Support Engineer
    Redgate Software Ltd
    Please see our Help Center for detailed guides on how to use our tools

Answers

Sign In or Register to comment.