ORA-32303 When Creating a Join Mview with One of the Tables Having a User Defined Type in its Definition.
Last updated on FEBRUARY 02, 2017
Applies to:Oracle Server - Enterprise Edition - Version 10.1.0.2 to 18.104.22.168.0 [Release 10.1 to 11.2]
Information in this document applies to any platform.
When creating a Materialized view of the type:
create materialized view GIS_SUB_VIEW2
build immediate refresh complete
GIS_UARN.UARN = CTAVM_SALES.UARN@GISU_TO_CDB;
And the local table: CTAVM_SALES@GISU_TO_CDB contains:
CREATE TABLE "OSMMU"."GIS_UARN"
( "UARN" NUMBER NOT NULL ENABLE,
"BACODE" VARCHAR2(4 BYTE),
"MI_PRINX" NUMBER NOT NULL ENABLE,
"MI_STYLE" VARCHAR2(256 BYTE),
"BLDG_GEOMETRY" "MDSYS"."SDO_GEOMETRY" );
We get an error as in the Symptoms below:
The local table contains:
CREATE TABLE COVODIC.CTAVM_SALES
( UARN NUMBER(11, 0),
MINO VARCHAR2(11 CHAR),
ORIGVO VARCHAR2(3 CHAR),
DOECODE VARCHAR2(4 CHAR),
ORA-32303: mviews with user-defined types cannot reference multiple master sites
32303. 00000 - "mviews with user-defined types cannot reference multiple master sites"
*Cause: For materialized views with user-defined types,
the definition query cannot reference tables from different
*Action: Do not create materialized views with user-defined types
referencing multiple master sites.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms