February 14, 2005 at 2:34 am
Hi,
Partitioning view is really a good option. but while implementing in our scenario we are facing some problems such as we cannot create index on the partitioned views as it gives some error saying that "underlying tables have some constraints". Even we had the triggers on the table which we have decided to split but if create instead of triggers on the view it is creating a problems for the queries given below such as
"update a
set col1 = d.col1
from a , d
where a.col2= d.col2"
here a is a view and d is another table
thus we cannot fire any update or delete queries having the syntax mentioned above.
so plz help me out to create index and triggers on the partitioned view
reagrds,
megha
February 16, 2005 at 1:03 am
please mention more details here... in your query there
is col1 = d.col1... I think you are probably trying to do a.col1
How did you create this view?
February 16, 2005 at 6:14 am
i have created a partitioned view as
create view a
as
select * from tbl1
union all
select * from tbl2
and tbl1 and tbl2 have the same structure and primary keys are defined on them and we have a chek constraint on one of the column which is the part of the primary key.
after creating the instead of insert,delete and update trigger on the viewand then when i fire the previous queyit gives me an error
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply