Skip to Main Content

Oracle Developer Tools for Visual Studio

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ODT VS2022 Schema comparison - Errors in creation of object not mentioned in the Update Target Report.

I am using VS2022 17.14.5 with Oracle developer tools 23.8.1.0. I used Update Target to create a missing view in the target, but my target schema did not have the select grant on the underlying object in the view. The ‘Schema Compare Update Target Report’ did not mention any error. It stated that the view had been created. Also the Oracle Developer Tools Output reported the update was successful.

Sample end of report

The following objects are newly created.

RelationalView  
    MYSCHEMA.VWTestView  

Sample ODT Output

Updating Target Connection....
MYSCHEMA updated successfully.
---------------------- Done ----------------------

The report and output should have mentioned the creation of the view failed with error ORA-01031: insufficient privileges error.

Please look into fixing this by reporting failed updates (object name and error message) in the report and ODT output window.

Comments
Post Details
Added on Aug 2 2025
1 comment
57 views