数据量太大,直接DROP物化视图,发现半个小时也没删除成功。
解决办法:
先删除日志,再删除视图
truncate table mlog$_device_state ;
drop materialized view log on device_state;
drop materialized view v_state_history;
数据量太大,直接DROP物化视图,发现半个小时也没删除成功。
解决办法:
先删除日志,再删除视图
truncate table mlog$_device_state ;
drop materialized view log on device_state;
drop materialized view v_state_history;