When trying to Reverse engineer and getting the error:
Source: CS3 - internal error
Script: XYZScript
Description: ORA-00942: table or view does not exist
Row: 1234
Column: 45
this Error is related to the DB access rights to certain tables or views.
It would it be good to know what the process is trying to access at the point it fails?
This would help in granting the correct access instead of having to give full DBA rights when running the Reverse engineer.
The error occurs while procedures and functions are being loaded.
(When looking at the log area, the "Reversing procedures and functions" informations are listed as last before the error occurs.)
The cause is that the user does not have permissions to load the procedures and functions.
WORKAROUND:
Please do not select Procedures and Functions in OTPs (What to Reverse step).
STATUS:
Enhancement request CR #55604 has been submitted to Development for consideration in future release of the Toad Data Modeler.
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy