ORACLE 视图

来源:互联网 发布:手机淘宝如何买东西 编辑:程序博客网 时间:2024/06/16 00:46

更改表结构数据类型以后,需要重建视图,否则报

oerr ora 04063
04063, 00000, "%s has errors"
// *Cause:  Attempt to execute a stored procedure or use a view that has
//          errors.  For stored procedures, the problem could be syntax errors
//          or references to other, non-existent procedures.  For views,
//          the problem could be a reference in the view's defining query to
//          a non-existent table.
//          Can also be a table which has references to non-existent or
//          inaccessible types.
// *Action: Fix the errors and/or create referenced objects as necessary.

原创粉丝点击