Error during create mview repobject : ORA-23456 (9i)
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