CREATE MATERIALIZED VIEW "HCAHPS"."VALIDATION_RULE_MV" ("VALIDATION_RULE_ID", "CODE", "MSG_TEMPLATE", "RULE_GROUP") ORGANIZATION HEAP PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE(INITIAL 131072 NEXT 131072 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "HCAHPS_DATA_SMALL01" BUILD IMMEDIATE USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 131072 NEXT 131072 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "HCAHPS_DATA_SMALL01" REFRESH FORCE ON DEMAND WITH PRIMARY KEY USING DEFAULT LOCAL ROLLBACK SEGMENT USING ENFORCED CONSTRAINTS DISABLE QUERY REWRITE AS SELECT vr.VALIDATION_RULE_ID, vr.CODE, vr.MSG_TEMPLATE, vr.RULE_GROUP FROM SYN_VALIDATION_RULE vr CREATE MATERIALIZED VIEW "HCAHPS"."ANSWER_BIN_ANSWER_MV" ("ANSWER_BIN_ANSWER_ID", "ANSWER_BIN_ID", "ANSWER_ID", "ANSWER _POSITION") ORGANIZATION HEAP PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE(INITIAL 131072 NEXT 131072 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "HCAHPS_DATA_SMALL01" BUILD IMMEDIATE USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 131072 NEXT 131072 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "HCAHPS_DATA_SMALL01" REFRESH FORCE ON DEMAND WITH PRIMARY KEY USING DEFAULT LOCAL ROLLBACK SEGMENT USING ENFORCED CONSTRAINTS DISABLE QUERY REWRITE AS SELECT aba.ANSWER_BIN_ANSWER_ID, aba.ANSWER_BIN_ID,aba.ANSWER_ID, aba.ANSWER_POSITION FROM SYN_ANSWER_BIN_ANSWER aba CREATE MATERIALIZED VIEW "HCAHPS"."ANSWER_BIN_MV" ("ANSWER_BIN_ID", "DESCRIPTION") ORGANIZATION HEAP PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE(INITIAL 131072 NEXT 131072 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "HCAHPS_DATA_SMALL01" BUILD IMMEDIATE USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 131072 NEXT 131072 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "HCAHPS_DATA_SMALL01" REFRESH FORCE ON DEMAND WITH PRIMARY KEY USING DEFAULT LOCAL ROLLBACK SEGMENT USING ENFORCED CONSTRAINTS DISABLE QUERY REWRITE AS SELECT ab.ANSWER_BIN_ID, ab.DESCRIPTION FROM SYN_ANSWER_BIN ab CREATE MATERIALIZED VIEW "HCAHPS"."CATEGORY_MV" ("CATEGORY_ID", "DESCRIPTION") ORGANIZATION HEAP PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE(INITIAL 131072 NEXT 131072 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "HCAHPS_DATA_SMALL01" BUILD IMMEDIATE USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 131072 NEXT 131072 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "HCAHPS_DATA_SMALL01" REFRESH FORCE ON DEMAND WITH PRIMARY KEY USING DEFAULT LOCAL ROLLBACK SEGMENT USING ENFORCED CONSTRAINTS DISABLE QUERY REWRITE AS SELECT cat.CATEGORY_ID, cat.DESCRIPTION FROM SYN_CATEGORY cat CREATE MATERIALIZED VIEW "HCAHPS"."SUBMISSION_DEADLINE_DETAIL_MV" ("SUBMISSION_DEADLINE_DETAIL_ID", "SUBMISSION_DEADLIN E_ID", "HSP_ID", "HSP_EXTENSION_DATE", "ADD_DT", "ADD_USERID", "UPDATE_DT", "UPDATE_USERID", "HSP_RVW_AND_CRCTN_END_DT_EX TSN", "RVW_AND_CRCTN_IND") ORGANIZATION HEAP PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE(INITIAL 131072 NEXT 131072 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "HCAHPS_DATA_SMALL01" BUILD IMMEDIATE USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 131072 NEXT 131072 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "HCAHPS_DATA_SMALL01" REFRESH FORCE ON DEMAND WITH PRIMARY KEY USING DEFAULT LOCAL ROLLBACK SEGMENT USING ENFORCED CONSTRAINTS DISABLE QUERY REWRITE AS SELECT "SDD"."SUBMISSION_DEADLINE_DETAIL_ID" "SUBMISSION_DEADLINE_DETAIL_ID","SDD"."SUBMISSION_DEADLINE_ID" "SUBMISS ION_DEADLINE_ID","SDD"."HSP_ID" "HSP_ID","SDD"."HSP_EXTENSION_DATE" "HSP_EXTENSION_DATE","SDD"."ADD_DT" "ADD_DT","SDD"."A DD_USERID" "ADD_USERID","SDD"."UPDATE_DT" "UPDATE_DT","SDD"."UPDATE_USERID" "UPDATE_USERID","SDD"."HSP_RVW_AND_CRCTN_END_ DT_EXTSN" "HSP_RVW_AND_CRCTN_END_DT_EXTSN","SDD"."RVW_AND_CRCTN_IND" "RVW_AND_CRCTN_IND" FROM "HCAHPS"."SUBMISSION_DEADLI NE_DETAIL"@"QNOLPR01.WORLD@HCAHPS" "SDD" CREATE MATERIALIZED VIEW "HCAHPS"."QUESTION_ANSWER_BIN_MV" ("QUESTION_ANSWER_BIN_ID", "QUESTION_ID", "ANSWER_BIN_ID", " QUESTION_POSITION", "CATEGORY_ID", "TIME_PERIOD_ID", "SECTION") ORGANIZATION HEAP PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE(INITIAL 131072 NEXT 131072 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "HCAHPS_DATA_SMALL01" BUILD IMMEDIATE USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 131072 NEXT 131072 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "HCAHPS_DATA_SMALL01" REFRESH FORCE ON DEMAND WITH PRIMARY KEY USING DEFAULT LOCAL ROLLBACK SEGMENT USING ENFORCED CONSTRAINTS DISABLE QUERY REWRITE AS SELECT qab.QUESTION_ANSWER_BIN_ID, qab.QUESTION_ID, qab.ANSWER_BIN_ID, qab.QUESTION_POSITION, qab.CATEGORY_ID, qab.T IME_PERIOD_ID, qab.SECTION FROM SYN_QUESTION_ANSWER_BIN qab CREATE MATERIALIZED VIEW "HCAHPS"."QUESTION_MV" ("QUESTION_ID", "CODE", "DESCRIPTION") ORGANIZATION HEAP PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE(INITIAL 131072 NEXT 131072 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "HCAHPS_DATA_SMALL01" BUILD IMMEDIATE USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 131072 NEXT 131072 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "HCAHPS_DATA_SMALL01" REFRESH FORCE ON DEMAND WITH PRIMARY KEY USING DEFAULT LOCAL ROLLBACK SEGMENT USING ENFORCED CONSTRAINTS DISABLE QUERY REWRITE AS SELECT q.QUESTION_ID, q.CODE, q.DESCRIPTION FROM SYN_QUESTION q CREATE MATERIALIZED VIEW "HCAHPS"."TIME_PERIOD_MV" ("TIME_PERIOD_ID", "START_DATE", "END_DATE", "CREATE_DATE") ORGANIZATION HEAP PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE(INITIAL 131072 NEXT 131072 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "HCAHPS_DATA_SMALL01" BUILD IMMEDIATE USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 131072 NEXT 131072 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "HCAHPS_DATA_SMALL01" REFRESH FORCE ON DEMAND WITH PRIMARY KEY USING DEFAULT LOCAL ROLLBACK SEGMENT USING ENFORCED CONSTRAINTS DISABLE QUERY REWRITE AS SELECT tp.TIME_PERIOD_ID, tp.START_DATE, tp.END_DATE, tp.CREATE_DATE FROM SYN_TIME_PERIOD tp CREATE MATERIALIZED VIEW "HCAHPS"."ANSWER_MV" ("ANSWER_ID", "CODE", "DESCRIPTION", "INSTRUCTION") ORGANIZATION HEAP PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE(INITIAL 131072 NEXT 131072 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "HCAHPS_DATA_SMALL01" BUILD IMMEDIATE USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 131072 NEXT 131072 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "HCAHPS_DATA_SMALL01" REFRESH FORCE ON DEMAND WITH PRIMARY KEY USING DEFAULT LOCAL ROLLBACK SEGMENT USING ENFORCED CONSTRAINTS DISABLE QUERY REWRITE AS SELECT answer.answer_id, answer.code, answer.description, answer.instruction FROM SYN_ANSWER answer CREATE MATERIALIZED VIEW "HCAHPS"."QSTN_ANS_TM_PRD_MV" ("QSTN_ANS_TM_PRD_GUID", "QUESTION_ID", "ANSWER_ID", "TIME_PERIO D_ID", "Q_NO", "QSTN_CD", "QSTN_DESC", "QSTN_POS", "ANS_CD", "ANSWER_DESC", "ANSWER_POSITION", "SECTION", "CATEGORY_ID", "SORT_ORDER", "START_DATE", "END_DATE") ORGANIZATION HEAP PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE(INITIAL 131072 NEXT 131072 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "HCAHPS_DATA_SMALL01" BUILD IMMEDIATE USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 131072 NEXT 131072 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "HCAHPS_DATA_SMALL01" REFRESH FORCE ON DEMAND WITH PRIMARY KEY USING DEFAULT LOCAL ROLLBACK SEGMENT USING ENFORCED CONSTRAINTS DISABLE QUERY REWRITE AS SELECT "QATM"."QSTN_ANS_TM_PRD_GUID" "QSTN_ANS_TM_PRD_GUID","QATM"."QUESTION_ID" "QUESTION_ID","QATM"."ANSWER_ID" "A NSWER_ID","QATM"."TIME_PERIOD_ID" "TIME_PERIOD_ID","QATM"."Q_NO" "Q_NO","QATM"."QSTN_CD" "QSTN_CD","QATM"."QSTN_DESC" "QS TN_DESC","QATM"."QSTN_POS" "QSTN_POS","QATM"."ANS_CD" "ANS_CD","QATM"."ANSWER_DESC" "ANSWER_DESC","QATM"."ANSWER_POSITION " "ANSWER_POSITION","QATM"."SECTION" "SECTION","QATM"."CATEGORY_ID" "CATEGORY_ID","QATM"."SORT_ORDER" "SORT_ORDER","QATM" ."START_DATE" "START_DATE","QATM"."END_DATE" "END_DATE" FROM "HCAHPS"."QSTN_ANS_TM_PRD"@"QNOLPR01.WORLD@HCAHPS" "QATM" CREATE MATERIALIZED VIEW "HCAHPS"."SUBMISSION_DEADLINE_MV" ("SUBMISSION_DEADLINE_ID", "DISCHARGE_QUARTER", "DISCHARGE_Y EAR", "SUBMISSION_START_DATE", "SUBMISSION_END_DATE", "SUBMISSION_EXTENSION_DATE", "ADD_DT", "ADD_USERID", "UPDATE_DT", " UPDATE_USERID", "RVW_AND_CRCTN_END_DT", "RVW_AND_CRCTN_IND", "CURRENT_CUSTOM_DATE") ORGANIZATION HEAP PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE(INITIAL 131072 NEXT 131072 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "HCAHPS_DATA_SMALL01" BUILD IMMEDIATE USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 131072 NEXT 131072 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "HCAHPS_DATA_SMALL01" REFRESH FORCE ON DEMAND WITH PRIMARY KEY USING DEFAULT LOCAL ROLLBACK SEGMENT USING ENFORCED CONSTRAINTS DISABLE QUERY REWRITE AS SELECT "SBD"."SUBMISSION_DEADLINE_ID" "SUBMISSION_DEADLINE_ID","SBD"."DISCHARGE_QUARTER" "DISCHARGE_QUARTER","SBD"." DISCHARGE_YEAR" "DISCHARGE_YEAR","SBD"."SUBMISSION_START_DATE" "SUBMISSION_START_DATE","SBD"."SUBMISSION_END_DATE" "SUBMI SSION_END_DATE","SBD"."SUBMISSION_EXTENSION_DATE" "SUBMISSION_EXTENSION_DATE","SBD"."ADD_DT" "ADD_DT","SBD"."ADD_USERID" "ADD_USERID","SBD"."UPDATE_DT" "UPDATE_DT","SBD"."UPDATE_USERID" "UPDATE_USERID","SBD"."RVW_AND_CRCTN_END_DT" "RVW_AND_CR CTN_END_DT","SBD"."RVW_AND_CRCTN_IND" "RVW_AND_CRCTN_IND","SBD"."CURRENT_CUSTOM_DATE" "CURRENT_CUSTOM_DATE" FROM "HCAHPS" ."SUBMISSION_DEADLINE"@"QNOLPR01.WORLD@HCAHPS" "SBD" 11 rows selected