materialized view
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