I would like to know how to show errors in sqlplus.
try to compile a view
alter view SYS.DBA_XML_SCHEMAS compile;
I have the message :
ERROR at line 1: ORA-04063 : view altered with compilation errors.
I try :
show errors;
it says :
No errors
I try :
show errors view SYS.DBA_XML_SCHEMAS
it says :
LINE/COL ERROR 0/0 ORA-00942 : table or view does not exist
If I could compile with errors, the view must exist or it would tell me that the view does not exist. I dont know how to display the compilation errors of the view
thank you
See Question&Answers more detail:os