更改物化视图字段长度

来源:互联网 发布:水果机辅助软件助手 编辑:程序博客网 时间:2024/06/17 13:52

原来物化视图也是可以更字段长度的

drop table test/drop materialized view t1/create table test as select '1' as a from dual/create materialized view t1 refresh complete as select * from test/alter table test modify a varchar2(5)/insert into test values('12345')/commit/exec dbms_mview.refresh('t1')alter table t1 modify a varchar2(5)/exec dbms_mview.refresh('t1')select * from t1/