Retour
-
Titre
Issue with favorites after modifying a view -
Description
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 col2x2fromtestFav);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 DoubleCol2fromtestFav);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
Connexion requise
Vous devez être connecté et disposer d'un contrat de maintenance en cours pour afficher les articles de la base de connaissances avancés.