Database DataWarehousing (MOSC)

MOSC Banner

materialized views issues

edited Feb 28, 2012 7:59PM in Database DataWarehousing (MOSC) 7 commentsAnswered
Hi all,

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center