Altering a view breaks favorites.
Steps to reproduce the problem:
create table testFAv (
col1 number,
col2 number);
create view testFav_view as(
select col1 ,
2*col2 col2x2
from
testFav);
Add view testFav_view to Favorites (select view in schema browser, r-click, add, Favorites)
Now modify the view (in this example the change is just changes the name of the column)
create or replace view testFav_view as(
select col1 ,
2*col2 DoubleCol2
from
testFav);
Go to Favorites , select the View, and go to Data tab:
There are 2 problems:
In the Columns tab there is still the old name of the column(ie col2x2)
In the Data Tab you receive the error ORA-00904:"col2x2":invalid Identifier