Define update: update a materialized view. I dont want to update the base tables, I want to update the mv, and it's formed by several tables (that's the why I dont want to use dbms_refresh), I use 'for update' clause and oracle does not allow it.

So, whe I truncate a table and insert lots of rows using APPEND hint I need to analyze the table, ok, I'll do it. I'm going to truncate the table, insert /*+ append */ as select, then analyze table compute statistics.


thanks.

F.