Hi ALl,

I have a prtitioned table and I created a UNION ALL view on them but when I try to update the view even from the enterprise manager I get the following message:
"UNION ALL view 'ViewX' is not updatable because a partitioning column was not found." anybody got any ideas regarding this message.

thanks for helping
regards,

Could u post the structure of Table & View.

Always:),
Hovik Melkomian.

Hi Hovik Melkomian,
I found the problem it was that I used bulk insert into the base table which will make the constraints untrusted so the view will not be updatable anymore.

thanx for ur help

Nice 2 hear that!
WOW hear has changed!!!

Always:),
Hovik Melkomian.