materialized views issues
After the import i realised one of the objects did not create from 91 to 11g. In source there is 5 materialized views but in my new enviroment there is 4 materialized view. I tried to recreate the missing materialized view but i could not. Can anyone help me in this on how could i go about this
DROP PUBLIC SYNONYM MCCB_IA_CALCULATION_CURRENT;
CREATE PUBLIC SYNONYM MCCB_IA_CALCULATION_CURRENT FOR CCC.MCCB_IA_CALCULATION_CURRENT;
DROP MATERIALIZED VIEW CCC.MCCB_IA_CALCULATION_CURRENT;
CREATE MATERIALIZED VIEW CCC.MCCB_IA_CALCULATION_CURRENT
TABLESPACE REFERENCE_DATA
PCTUSED 0
PCTFREE 10
INITRANS 2
MAXTRANS 255