creating materialized view takes long time
CREATE MATERIALIZED VIEW BOG_WEB_SERVICE.GP_MV_MY_CASES
(CASE_ID,DIVISION_ID,DIVISION_NAME,RECEIVE_DIVISION_ID,RECEIVE_DIVISION_NAME,
CASE_NO,REG_DATE,REG_YEAR_H,DIVISION_COURT_TYPE,DIVISION_COURT_TYPE_NAME,
PLAINTIFFS,DEFENDANT,RECEIVE_DATE,IS_ARCHIVED_CASE,IDENTITY_TYPE_ID,
IDENTITY_TYPE_NAME,GOV_ENTITY_ID,IDENTITY_ID,MASTER_GOV_ENTITY_ID,PARTY_ID,
FULLNAME,FIRSTNAME,FATHERNAME,FATHERNAME1,FATHERNAME2,
LASTNAME,PHONE1,PARTY_TYPE_ID,PARTY_TYPE_NAME,PARTY_KIND,
KIND_TYPE,RULING_DATE,RULING_DELIVERY_DATE,CATEGORY_ID,CATEGORY_NAME,
LAST_SESSION_DATE,HAS_ACT)
TABLESPACE USERS
PCTUSED 0
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (
INITIAL 64K