物化视图sql
create materialized view GI_TLJAPAYPERSON
refresh fast
on demand with rowid as
select * from KPIODS.ODS_LJAPAYPERSON_GRP;
创建时候报错 ora-01652:unable to extend temp segment by 8192 in tablespace JH_DATA
看错误，临时段不够用了。
估计是你的数据太多，通常给那个表空间加个数据文件。
参考
http://www.51testing.com/?uid-77325-action-viewspace-itemid-148472