Re: Materialized view and SQLLoader

Well, I would like to see the DOC that you were reading. This is not true. What version of ORACLE are you using? You can fast refresh a MV whether or not the table the MV is based on is filled with SQL*LOADER direct load, conventional load , SQL conventional insert or direct insert. Whethere or not a MV is fast refreshable depends more on how it is structured (like, are there aggregates, joins in the definition?) than on how the data in the base table is populated. Why not play with a couple of MVs and get a feel of it yourself?

• Jusung Yang

"emerald" <emerald_at_net.hr> wrote in message news:<ar41hf$jqg$1_at_sunce.iskon.hr>...
> In documentation is said that fast refresh can be used only if a table is
> filled by direct load. In my post I explained why I can't use direct load on
> my tables - it would slow loading since indexes are huge (direct load is
> recommended only on small tables).
>
> What I'm saying is that you can't use fast refresh on large tables because
> you can not fill them by direct load. Am I right?
Received on Sat Nov 16 2002 - 19:24:10 CET