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