|
ORA-32316 после смешанного DML не поддерживается REFRESH FAST
#40106428
Ссылка:
Ссылка на сообщение:
Ссылка с названием темы:
|
|
|
|
REFRESH FAST для "T ABLEAU"."MV_CREATIVE_DCO_FACEBOOK" после смешанного DML не поддерживается ORA-06512: на "SYS.DBMS_SNAPSHOT_KKXRCA", line 2952 ORA-06512
Товарищи, не знаете в чём проблема ?
explain matview:
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
PCT F
REFRESH_COMPLETE T
REFRESH_FAST T
REWRITE T
PCT_TABLE F отношение не является секционированной таблицей
PCT_TABLE F отношение не является секционированной таблицей
PCT_TABLE F отношение не является секционированной таблицей
PCT_TABLE F отношение не является секционированной таблицей
REFRESH_FAST_AFTER_INSERT T
REFRESH_FAST_AFTER_ONETAB_DML T
REFRESH_FAST_AFTER_ANY_DML F журнал MV не имеет порядкового №
REFRESH_FAST_AFTER_ANY_DML F журнал MV не имеет порядкового №
REFRESH_FAST_AFTER_ANY_DML F журнал MV не имеет порядкового №
REFRESH_FAST_AFTER_ANY_DML F журнал MV не имеет порядкового №
REFRESH_FAST_PCT F PCT невозможен для любой из таблиц подробных данных в материализованном представлении
REWRITE_FULL_TEXT_MATCH T
REWRITE_PARTIAL_TEXT_MATCH T
REWRITE_GENERAL T
REWRITE_PCT F для любой таблицы подробных данных невозможны ни общая перезапись, ни PCT
PCT_TABLE_REWRITE F отношение не является секционированной таблицей
PCT_TABLE_REWRITE F отношение не является секционированной таблицей
PCT_TABLE_REWRITE F отношение не является секционированной таблицей
PCT_TABLE_REWRITE F отношение не является секционированной таблицей
запрос созданного быстрого материализировнного представления :
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.
36.
37.
38.
39.
40.
41.
42.
43.
44.
45.
46.
47.
48.
49.
50.
51.
52.
53.
54.
55.
56.
57.
58.
59.
60.
61.
62.
63.
64.
65.
66.
67.
68.
69.
70.
71.
72.
73.
74.
75.
76.
77.
78.
79.
80.
81.
82.
83.
84.
SELECT
COUNT(*) primery_t,
CAMPAIGNS.DATE_TO AS CAMPAIGNS_DATE_TO,
PLACEMENTS.DATE_TO AS PLACEMENTS_DATE_TO,
PLACEMENTS.ADSET_ID AS PLACEMENTS_ADSET_ID,
CREATIVES.DATE_TO DAY,
CAST(NULL AS VARCHAR2(4000)) ACCOUNT_ID,
CAST(NULL AS VARCHAR2(4000)) ACCOUNT_NAME,
CREATIVES.ACCOUNT_ID CLIENT_ID,
ACCOUNTS.NAME CLIENT_NAME,
CAST(NULL AS VARCHAR2(4000)) AS CAMPAIGN_ID,
CAST(NULL AS VARCHAR2(4000)) AS CAMPAIGN_NAME,
CREATIVES.CAMPAIGN_ID PLACEMENT_ID,
CAMPAIGNS.CAMPAIGN_NAME PLACEMENT_NAME,
CREATIVES.ADSET_ID ADGROUP_ID,
PLACEMENTS.ADSET_NAME ADGROUP_NAME,
CREATIVES.AD_ID CREATIVE_ID,
CREATIVES.AD_NAME CREATIVE_NAME,
TRUNC(CREATIVES.COST,2) SPEND,
CREATIVES.IMPRESSIONS IMPRESSIONS,
CREATIVES.CLICKS CLICKS,
CREATIVES.LINK_CLICKS LINKS_CLICKS,
CREATIVES.VIDEO_30_SEC_WATCHED_ACTIONS VIDEO_VIEWS,
CREATIVES.VIDEO_PLAY_ACTIONS START_VIDEO,
CAST(NULL AS NUMBER) AS VIDEO_3_SEK,
CREATIVES.VIDEO_10_SEC_WATCHED_ACTIONS VIDEO_10_SEK,
CREATIVES.QUARTILE_25 VIDEO_FIRST_QUARTILE_COMPLETION,
CREATIVES.QUARTILE_50 VIDEO_SECOND_QUARTILE_COMPLETION,
CREATIVES.QUARTILE_75 VIDEO_THIRD_QUARTILE_COMPLETION,
CREATIVES.QUARTILE_100 VIDEO_COMPLETES,
CAST(NULL AS NUMBER) AS ACTIVEVIEW_VIEWABLEIMPRESS,
CREATIVES.ACTION_LIKE LIKES,
CREATIVES.ACTION_COMMENT COMMENTS,
CREATIVES.ACTION_POST SHARES,
CAST(NULL AS NUMBER) AS OPNING_APP,
CAST(NULL AS NUMBER) AS OPENING_POST,
CAST(NULL AS NUMBER) AS MOVING_INTO_GROUPS,
CAST(NULL AS NUMBER) AS JOININGS,
CAST(NULL AS NUMBER) AS VOTINGS,
CAST(NULL AS NUMBER) AS LEADS,
CAST(NULL AS NUMBER) AS INTERACTIONS,
CREATIVES.ACTION_POST_ENGAGEMENT ENGAGEMENTS,
CAST(NULL AS NUMBER) AS GMAIL_CLICKS,
CAST(NULL AS NUMBER) AS HIDE,
CAST(NULL AS NUMBER) AS UNSUBSCRIBE,
CAST(NULL AS NUMBER) AS JOIN_RATE,
CAST(NULL AS NUMBER) AS DATA_FEES,
CREATIVES.ACCOUNT_CURRENCY AS CURRENCY
FROM
TABLEAU.FB_APX_AD_STAT CREATIVES,
TABLEAU.FB_APX_ADSET_STAT PLACEMENTS,
TABLEAU.FB_APX_CAMPAIGN_STAT CAMPAIGNS,
TABLEAU.FB_APX_ACCOUNTS ACCOUNTS
WHERE
CREATIVES.DATE_FROM = PLACEMENTS.DATE_FROM AND CREATIVES.ACCOUNT_ID = PLACEMENTS.ACCOUNT_ID AND CREATIVES.CAMPAIGN_ID = PLACEMENTS.CAMPAIGN_ID AND CREATIVES.ADSET_ID = PLACEMENTS.ADSET_ID AND PLACEMENTS.DATE_FROM = CAMPAIGNS.DATE_FROM AND PLACEMENTS.ACCOUNT_ID = CAMPAIGNS.ACCOUNT_ID AND PLACEMENTS.CAMPAIGN_ID = CAMPAIGNS.CAMPAIGN_ID AND CAMPAIGNS.ACCOUNT_ID = ACCOUNTS.ID
GROUP BY
CAMPAIGNS.DATE_TO,
PLACEMENTS.DATE_TO,
PLACEMENTS.ADSET_ID,
CREATIVES.DATE_TO,
CREATIVES.ACCOUNT_ID,
ACCOUNTS.NAME,
CREATIVES.CAMPAIGN_ID,
CAMPAIGNS.CAMPAIGN_NAME,
CREATIVES.ADSET_ID,
PLACEMENTS.ADSET_NAME,
CREATIVES.AD_ID,
CREATIVES.AD_NAME,
CREATIVES.ACCOUNT_CURRENCY,
TRUNC(CREATIVES.COST,2),
CREATIVES.IMPRESSIONS,
CREATIVES.CLICKS,
CREATIVES.LINK_CLICKS,
CREATIVES.VIDEO_30_SEC_WATCHED_ACTIONS,
CREATIVES.VIDEO_PLAY_ACTIONS,
CREATIVES.VIDEO_10_SEC_WATCHED_ACTIONS,
CREATIVES.QUARTILE_25,
CREATIVES.QUARTILE_50,
CREATIVES.QUARTILE_75,
CREATIVES.QUARTILE_100,
CREATIVES.ACTION_LIKE,
CREATIVES.ACTION_COMMENT,
CREATIVES.ACTION_POST,
CREATIVES.ACTION_POST_ENGAGEMENT
|
|
|
