Materialized view and SQLLoader
Date: Thu, 14 Nov 2002 22:01:47 +0100
Message-ID: <ar12uf$pph$1_at_sunce.iskon.hr>
First: Oracle 8.1.6.0.0 (yes, no patches, don't ask), AIX 4.3.3
Here's my problem: in order to use materialized view logs, table on which
the log is created should be filled with sqlloader using direct load.
Direct load is not reccomended on large tables, because it merges existing
index with index created on added records. It also locks table while
loading, and no update or select can be performed on such table during the
So, if a table is large, you should use materialized view logs, so you can do fast refresh. But you can't use direct load, because table is large.
If a table is small, you can use direct load. But, there is no point using
materialized view logs, because table is small.
So, how can I use these two?
Right now I have 6 large table (two of them have +200,000,000 rows). I have
some load tables, in which I load stuff with direct load, do some
processing, and then copy data into main tables (insert into a select *
from a_load)
Since tables are large, I'm looking for a way to use materialized views on
them , instead having some summarized data in separate tables, thus having
to maintain procedures to fill those tables.
Since we'll upgrade on 9.2 soon, any answer for 9.2. will be helpfull, too.
Thanx Received on Thu Nov 14 2002 - 22:01:47 CET