Hi all,
I created a view with three tables. If i alter any one of the table e,g(add a column,change a datatype of a column in the table etc...) the view becomes invalid. But on querying from the view the view becomes invalid.
My questions are
1. I want to know why this anamoly?
2. What should i do to inform ,that underlying table has changes hence view has to be recreated, when view is queried.
Please mail it to me. I am desparate to know the answer for this ?
Regards
Raghunathan.
I created a view with three tables. If i alter any one of the table e,g(add a column,change a datatype of a column in the table etc...) the view becomes invalid. But on querying from the view the view becomes invalid.
My questions are
1. I want to know why this anamoly?
2. What should i do to inform ,that underlying table has changes hence view has to be recreated, when view is queried.
Please mail it to me. I am desparate to know the answer for this ?
Regards
Raghunathan.