错误码 / Oracle Database

Oracle Database 错误码 ORA-12056

invalid REFRESH method 原因:The NEVER REFRESH option may not be used under the following conditions: * The materialized view is updatable * The material…

错误说明

invalid REFRESH method

原因:The NEVER REFRESH option may not be used under the following conditions: * The materialized view is updatable * The materialized view refreshes ON COMMIT * Automatic refresh options are specified

处理:For updatable materialized views, reissue the SQL command using REFRESH FORCE, REFRESH FAST, or REFRESH COMPLETE. For read-only materialized views, reissue the SQL command using ON DEMAND.

官方文档

进一步检索

相关错误码