ORA-32303 When Creating a Join Mview with One of the Tables Having a User Defined Type in its Definition. (Doc ID 1066679.1)

Last updated on FEBRUARY 02, 2017

Applies to:

Oracle Server - Enterprise Edition - Version 10.1.0.2 to 11.2.0.2.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
as
SELECT
GIS_UARN.MI_STYLE
FROM
GIS_UARN,
CTAVM_SALES@GISU_TO_CDB
WHERE
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),
"SEARCH_TYPE" NUMBER,
"LAST_UPDATED_DATE" DATE,
"GEOMETRY" "OSMMU"."SDO_GEOMETRY",
"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),
PERT_DATE DATE);


Symptoms

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
master sites.
*Action: Do not create materialized views with user-defined types
referencing multiple master sites.

Changes

None.

Cause

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