> This is maybe a newbie question, but what is the difference with a
> materialized view ?
>
An updateable view is one you can insert, delete or update rows.
A materialized view is one that is pre-executed... i mean, that the
data is stored in a file for fast execution of the view
--
regards,
Jaime Casanova
(DBA: DataBase Aniquilator ;)