PL/SQL (MOSC)

MOSC Banner

Create materialized view error ora-1031 and ora 6512

edited Dec 19, 2012 12:25AM in PL/SQL (MOSC) 4 commentsAnswered
HI  ,

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,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center