>Well I did say it was ugly - but if the base tables are also buffered then an update() on a local view should be viable...
I should give your IP to the society against cruel and unusual treating of domesticated silicone !
Buffered views make me scratch my had, views on buffered tables is also not an ideal scenario in my book,
but to recommend using buffered base tables to somebody supposedly already buffering his views...
>
>IAC, I wonder whether Roman could not solve the problem by using buffered tables and unbuffered views ?
You are not alone in this - "WOndering aloud" woud be a fitting title, but Tull already has it...

Regards,

thomas