During compilation of view I got the following error:
Warning: View created with compilation errors.
Show err gives No Errors.
SQL> 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]';
Did this post help you in any way can you please leave a comment?
No comments:
Post a Comment