PL/SQL (MOSC)

MOSC Banner

Delay in creating materialized view

in PL/SQL (MOSC) 5 commentsAnswered ✓

Hi,

I'm trying to create the following materialized view:
CREATE MATERIALIZED VIEW p.vmiew1
BUILD IMMEDIATELY
USING INDEX
REFRESH FORCE ON DEMAND
USING TRUSTED CONSTRAINTS
TO THE
SELECT hc.cod,
hc.sit,
hc.sgl,
hc.sec
FROM hist@dblnk hc
JOIN m@dblnk m on m.cod = hc.cod_m
WHERE hc.sgl like 'XX'
AND m.cod_dat IN (SELECT cod_dat FROM pleito_config WHERE flag=1) ;
But it's taking too long.
But if I just execute the select command, the response doesn't take long. What can it be?

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