我正在建立一个本地oracle(11g)数据库 – 我们已经运行的另一个数据库的克隆.我在sql Developer中运行一堆生成的PL / sql命令.
我得到的输出
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
如果显示错误不给你任何东西:
select line,position,text from user_errors where type = 'VIEW' and name = 'someViewName' order by sequence;
假设你是在自己的模式下创建它的;如果不是,你可以看看all_errors而不是.
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 theOWNER
column.