Database DataWarehousing (MOSC)

MOSC Banner

Materialized View Hangs with no error

edited Jan 14, 2010 1:09AM in Database DataWarehousing (MOSC) 6 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.  It is a complex view with unions.  I can use this same code to create a view and create a table with success but not a materialized view.  What am I missing? 

nbsp;                             curr_apft,
            SUM (med_non_deploy) med_non_deploy, SUM (candidates) candidates,
            SUM (officers_no_ba) officers_no_ba,
            SUM (officer_pipe) officer_pipe,
            SUM (security_clearance) security_clearance,
            SUM (gains_last_month) gains_last_month,

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