WILL>>Try something like:

create view V1_TEST as
(select * from test);

You will have to create synonyms for users to select from the view.

If end users have the ability to create or replace views, they can
overwrite the
view in their environment only.

The view above will contain all up to date records, if you just want
Monday through Friday
you will need to add a where clause with a between
create view V1_TEST as
(select * from test where m_time between 31-OCT-05 and 05_NOV-05);



BRoussel wrote:

>
>
>Hi DBAs,
>
> I would like to use materialized views for a project that we are
>thinking of, see below:
>
>2 tables with 4.4 millions of rows each
>Need to be read-only view
>Run from Monday to Friday at 5:00am
>
> It is my first time and I would like to have an example on how to
>code this materialized view...
>
> The environment is Unix Solaris and Oracle9i.
>
>Thanks,
>
>Bruno
>
>
>
>--------
>website: http://www.LazyDBA.com
>Please don't reply to RTFM questions
>Oracle documentation is here: http://tahiti.oracle.com
>To unsubscribe: see http://www.lazydba.com/unsubscribe.html
>To subscribe: see http://www.lazydba.com
>By using this list you agree to these terms:http://www.lazydba.com/legal.html
>
>
>


Oracle LazyDBA home page