If a view has errors, the way to determine what is causing the error is to run the following syntax:
show errors view VIEW_NAME;
The result will indicate what is causing the error in the view.
ORA-04063: view "xxxxx" has errors Print
Modified on: Thu, 3 Mar, 2016 at 1:29 PM
Did you find it helpful? Yes No
Send feedbackSorry we couldn't be helpful. Help us improve this article with your feedback.