Database DataWarehousing (MOSC)

MOSC Banner

ORA-04052 error when create a MV reference a remote table,

edited Jan 12, 2011 7:21PM in Database DataWarehousing (MOSC) 7 commentsAnswered ✓
Original table on USCUMSP database    --> UMS_DBA.PARSER_HEADER

Synonym on USCDWDBP database over public database link uscumsp.

create synonym dwdb_admin_syn.PARSER_HEADER from ums_dba.parser_header@uscumsp;

and normal sql query run by dwb_admin_syn "select * from dwdb_admin_syn.PARSER_HEADER" works fine.

but when i run below statements to create materialized view runtens error:

15:17:57 DWDB_ADMIN_SYN@ uscdwdbp>CREATE MATERIALIZED VIEW MV_PARSER_HEADER ON PREBUILT TABLE REFRESH FAST ON DEMAND AS SELECT "PARSER_HEADER"."GUID" "GUID","PARSER_HEADER"."DEVICE" "DEVICE","PARSER_H
EADER"."CUSTLOTID" "CUSTLOTID","PARSER_HEADER"."TIMESTAMP" "TIMESTAMP","PARSER_HEADER"."PARSER" "PARSER","PARSER_HEADER"."FILENAME" "FILENAME","PARSER_HEADER"."CUST_CODE" "CUST_CODE" FROM "PARSER_HEAD

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