Thank you JL..Re: Can you do a fast refresh of a basic replication if data is loaded through direct load ?

Thanks a lot :)You are the only who cared enough to reply.

In article <961051729.11501.0.nnrp-01.9e984b29_at_news.demon.co.uk>,   "Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote:
>
> With Oracle 8.1, where snapshots are now called
> 'materialized views', it is possible to do a direct load
> and a fast refresh. Oracle keeps a note of the blocks
> that have been loaded (I can't remember the exact
> details at the moment of where or how) and uses an
> alternative refresh mechanism to load those into
> the materialized view.
>
> --
>
> Jonathan Lewis
> Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk
>
> EnderW wrote in message <8i9l2o$2qc$1_at_nnrp1.deja.com>...
> > My question is I want to create a snapshot and put it on fast
 refresh.
> >If the master table is always loaded through direct load feature of
> >sqlloader, is this possible ? I remember that snapshots create a
> >trigger. Is this still the case with Oracle 8 ?
> >
> >--
> >Ender Wiggin
> >
> >
> >Sent via Deja.com http://www.deja.com/
> >Before you buy.
>
>

--
Ender Wiggin


Sent via Deja.com http://www.deja.com/
Before you buy.