How to solve Oracle Database Error 12056 (ora-12056)

Oracle Error Code
   ora-12056

Description
   invalid REFRESH method

Cause
   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

How to Solve
   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.

Do you have question or do you know about solution ?

Share with us. (No registration required)
  
Your Name
Question, comment or solution
Similar Errors
  ORA-12000    ORA-12001    ORA-12002    ORA-12056    ORA-12057    ORA-12058    ORA-12059  Others

Main Page      Contact Us      Tools & Softwares      Server Monitoring Softwares