Materialized Views

I am trying to create (and populate a materialized view that is a join between two tables that have a primary key/foreign key relationship:

Select <some columns from each>

    FROM header h, detail d
  where d.header_key = h.header_key

The problem occurs when I try to refresh this MV for the first time. Transactions began backing up immediately, until the instance ran out connections. This caused my users great heartburn.

Is there any way to do this while allowing the users to still access the table, or am I going to have to take downtime?

Sean Bradley
sailf3_at_adelphia.net Received on Sat May 11 2002 - 17:18:14 CDT