Materialized Views

Materialized Views

 

  





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


Oracle LazyDBA home page