| materalized view [message #472726] |
Mon, 23 August 2010 08:57  |
prashant_ora
Messages: 196
Registered: July 2010
|
Senior Member |
|
|
CREATE MATERIALIZED VIEW MVIEW_REST_SET_LAYR
BUILD IMMEDIATE
refresh FORCE START WITH SYSDATE NEXT SYSDATE + 6/24 WITH ROWID
--REFRESH FAST ENABLE QUERY REWRITE
AS
SELECT RD.REST_ID, RD.ASN_SET_TYP, RD.REST_INST_ID, RD.PREN_SET_ID, RD.CUSM_SET_ID,
RD.DLTD_FL REST_DATA_DLTD_FL,
SL.SET_LAYR_ID, SL.TOP, SL.LEAF, SL.DLTD_FL SET_LAYR_DLTD_FL, SL.CHLD_SET_ID, SL.INHR_ORD
FROM REST_DATA@DB_LINK_MCD3 RD, SET_LAYR@DB_LINK_MCD3 SL
WHERE SL.PREN_SET_ID = RD.PREN_SET_ID
giving error:oRA-12052: cannot fast refresh
|
|
|
|
| Re: materalized view [message #472727 is a reply to message #472726] |
Mon, 23 August 2010 08:59  |
 |
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
|
Senior Member |
|
|
It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/
It would be helpful if you provided Test Case - http://www.orafaq.com/wiki/Test_case
It would be helpful if you provided expected/desired results & a detailed explanation how & why the test data gets transformed or organized.
12052, 00000, "cannot fast refresh materialized view %s.%s"
// *Cause: Either ROWIDs of certain tables were missing in the definition or
// the inner table of an outer join did not have UNIQUE constraints on
// join columns.
// *Action: Specify the FORCE or COMPLETE option. If this error is got
// during creation, the materialized view definition may have be
// changed. Refer to the documentation on materialized views.
//
[Updated on: Mon, 23 August 2010 09:01] Report message to a moderator |
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
