How to fix invalid view? (DBMR3289)
If you dropped the table, then recreated the table, the view which was based on the table became invalid view. When you select the invalid view, you will get ERROR(6539): This view exists but it is invalid. Before DBMaker 5.4.3, you have to enter below command to recompile the view.
dmSQL> alter view view_name compile;
From DBMaker 5.4.3, we add new features when you create or alter table:
- When creating table, DBMaker will automatically do “ALTER VIEW COMPILE” for all invalid view.
- When altering table, DBMaker will automatically do “ALTER VIEW COMPILE” with dependency.
Version: 5.4.3
Product: Normal/Bundle
Platform: Windows/Linux