dbeaver: Oracle MView refresh does not work: class org.jkiss.dbeaver.ext.oracle.model.OracleTable cannot be cast to class org.jkiss.dbeaver.ext.oracle.model.OracleMaterializedView
System information:
- Operating system (distribution) and version: Mac OS Catalina 10.15.7
- DBeaver version: 21.0.5.202105160657 (Runtime: 11.0.8+10)
- Additional extensions: None, pure installation
Connection specification:
- Database name and version: Oracle 12.1.0.2.0
- Driver name: ojdbc8:12.2.0.1 (I guess this version was bundled or downloaded from MVN central by default)
- Do you use tunnels or proxies (SSH, SOCKS, etc)? No
Describe the problem you’re observing:
The following error on attempt to refresh a view:

Steps to reproduce, if exist:
Right-click materialized view -> Tools -> Refresh Materialized view -> click ‘Start’
Include any warning/errors/backtraces from the logs
Pasting error details from the screenshot:
Execute tool 'Refresh materialized view'
Process [SCHEMA_NAME.MVIEW_NAME]
Process error
class org.jkiss.dbeaver.ext.oracle.model.OracleTable cannot be cast to class org.jkiss.dbeaver.ext.oracle.model.OracleMaterializedView (org.jkiss.dbeaver.ext.oracle.model.OracleTable and org.jkiss.dbeaver.ext.oracle.model.OracleMaterializedView are in unnamed module of loader org.eclipse.osgi.internal.loader.EquinoxClassLoader @419ece7a)
Tool execution finished
I also found this problem in comments to other issues, but those issues are already resolved:
About this issue
- Original URL
- State: open
- Created 3 years ago
- Comments: 16 (6 by maintainers)
Successfully reproduced the issue on Oracle 12c EE.
@akilovich , I already reported above, that the problem was also reproducible on Linux. So far I only did not cover Windows 😃
I cannot reproduce it. Could you please send mview DDL example and logs completely https://github.com/dbeaver/dbeaver/wiki/Log-files?