Database DataWarehousing (MOSC)

MOSC Banner

Error during create mview repobject : ORA-23456 (9i)

edited Jan 14, 2010 12:34AM in Database DataWarehousing (MOSC) 3 commentsAnswered

 Hello,

I have the error

ORA-23456: la classe (flavor)  ne contient pas "ANALAFAIRE"."ANAF_ANAL"

where I try to create a mview repobject with the following command :

BEGIN
    dbms_repcat.create_mview_repobject (
      gname => 'GM_ADMINISTRATEUR',
      sname => 'ADMINISTRATEUR',
      oname => 'ANALAFAIRE',
      type => 'SNAPSHOT',
      min_communication => TRUE);
END;
/
I verified all that is shown in note 112493.1 in metalink, and all appears correct.

Before these command, I have run the command :

CREATE MATERIALIZED VIEW ADMINISTRATEUR.ANALAFAIRE
    TABLESPACE TS_TELECAR
    STORAGE( INITIAL 1M NEXT 1M)
    USING INDEX STORAGE( INITIAL 100K NEXT 100K)
    REFRESH FAST
    WITH PRIMARY KEY
    FOR UPDATE
    AS SELECT * FROM ADMINISTRATEUR.ANALAFAIRE@CTS2

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