Database DataWarehousing (MOSC)

MOSC Banner

Materialized view

edited May 7, 2010 8:00AM in Database DataWarehousing (MOSC) 4 commentsAnswered
 Trying to make the below materialized view but it hangs while the query is running fine within seconds.

what need to be changed?

 create materialized view VIEW_SMS_MO
  2  refresh with rowid
  3  start with sysdate next sysdate+1 as
  4  SELECT to_date(substr("TIMESTAMP_UTC",1,10),'yyyy-mm-dd') todate,"TYPE_OF_RECORD","TRANS_ID","SRC_ID","DEST","3PI_Ser_id" servid,"3PI_Ser_name" servname,"3PI_Prov_id" provid,"PRE_RES_TYPE","PUR_PRICE_EXVAT","CURRENCY","PROD_ID","CONT_DESC","CHANNEL","MESS_SIZE","STATUS","CHARGE_PARTY_MSISDN","SUBS_TYPE","CIRCLE_ID","PUR_ID","STAT_OF_PARLAYX_CALL","PARLEYX_RESERV_ID"
  5  FROM TBL_POSTPAID_CDR_SMS

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