Oracle DB&SQL Developer：“错误报告：执行完成并带有警告

我得到的输出

Error starting at line x in command: 
*long-ass SQL statement here* 
Error report: 
SQL Command: force view "someViewName"
Failed: Warning: execution completed with warning

如何阅读在不修改脚本的情况下生成的警告？

当我在这个命令后立即使用show错误,我得到的输出没有错误

select line,position,text
from user_errors
where type = 'VIEW'
and name = 'someViewName'
order by sequence;

假设你是在自己的模式下创建它的;如果不是,你可以看看all_errors而不是.

列为in the documentation：

ALL_ERRORS describes the current errors on the stored objects accessible to the current user.
DBA_ERRORS describes the current errors on all stored objects in the database.
USER_ERRORS describes the current errors on the stored objects owned by the current user. This view does not display the OWNER column.

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!