Database DataWarehousing (MOSC)

MOSC Banner

Materialized View Hangs

edited Jan 14, 2010 1:10AM in Database DataWarehousing (MOSC) 3 commentsAnswered ✓
Can anyone help me on this?  I am trying to create a materialized view but every time I try, it just hangs.  I never get any error but the MV is never created.  I can use this same code to create a view and create a table with sucess but not a materialized view.  What am I missing?  The code is below.

   SELECT   curr_upc upc, SUM (assigned) assigned, SUM (authorized)
                                                                   authorized,
            SUM (on_time_pays) on_time_pays, SUM (total_pays) total_pays,
            SUM (not_mos_q) not_mos_q, SUM (ets_90_days) ets_90_days,
            SUM (out_dated_physicals) out_dated_physicals, SUM (ocie) ocie,

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