View column aliases lost when invalid

[thillson]

We ran into a situation when cloning a database for our demo machines. We had to rename an owner that is referenced in a number of views, but cannot use PLSd to update the views since the column aliases are lost when a view is invalid.

As the owner, create a view and compile it. It is currently valid (there is a synonym for xlattable_vw pointing to the appropriate owner).

from plsql browser window select view and choose edit:

create view testview ( idseq, fieldname, fieldvalue, effdt )
as
select 0, fieldname, fieldvalue, effdt
  from xlattable_vw;

The view becomes invalid (drop the synonym), you can no longer edit the view as the column aliases
are lost.

from plsql browser window select view and choose edit:

create or replace view testview as
select 0, fieldname, fieldvalue, effdt
  from xlattable_vw

Why isn't the column aliases built when the view is invalid?

Thanks,
Tom

 

[Marco Kalter]

To obtain the aliases, the view is described. If it cannot be validated, this information is lost.

 

[thillson]

Marco,
How is it described? Doesn't it just build the list of columns from all_ or dba_tab_columns? The problem is we have a number of invalid views that we cannot use PLSd to edit and fix.

Thanks,
Tom

 

[Marco Kalter]

We hope to fix this in the next release.