Create materialized view error ora-1031 and ora 6512
I have met a very strange issue when create a mview in orace 11.2.0.1 on LINUX.
i have 2 users .fmuser_jy and fmtbs. (user fmuser_jy is normal.)
- Scenario 1:
conn fmtbs
SQL>
SQL> create materialized view MV_DETAILNODEWITHUNITE
2 refresh fast on demand
3 as
4 select /*+use_hash(p f) parallel*/p.pvt_em_addr detailnodeid,
5 f_Convert_1E20(f.unite_1) unite1,
6 f_Convert_1E20(f.unite_2) unite2,
7 f_Convert_1E20(f.unite_3) unite3,
8 f_Convert_1E20(f.unite_4) unite4,
9 f_Convert_1E20(f.unite_5) unite5,
10 f_Convert_1E20(f.unite_6) unite6,
11 f_Convert_1E20(f.unite_7) unite7,
12 f_Convert_1E20(f.unite_8) unite8,