更改物化视图字段长度

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

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
/