Database DataWarehousing (MOSC)

MOSC Banner

materialized view

edited May 6, 2010 6:34AM in Database DataWarehousing (MOSC) 4 commentsAnswered
My db ver is 10.2.0.4 ,trying to make the below mview but it hangs while the select query is running fine.what needs to be changed ?

create materialized view VIEW_SMS_Mt
    refresh with rowid    start with sysdate next sysdate+1
AS
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"
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