During compilation of view I got the following
error:
Warning: View created with compilation errors.
Show err gives No Errors.
SQL> show err
No errors.
With the following select statement it is
possible to find the error:
select text from dba_errors where name =
'[OBJECT_NAME]' and owner = '[OBJECT_OWNER]';
or
SHOW
ERRORS VIEW SCHEMA_NAME.OBJECT_NAME
OUTPUT:-
LINE/COL ERROR
-------- -----------------------------------------------------------------
0/0
ORA-00942: table or view does not exist
No comments:
Post a Comment