View does not compare correctly

[Maxmix]

Hello,

Having a view with a such DDL:

?dl=0

I cannot to compare it via Compare User Objects.
As you can see, there is a column list on 1st line (well, column names are in Russian - legacy code), but "Compare User Objects" not only strips quotation marks but also lacks the entire column list altogether, which results in ORA-00998 during Apply SQL in target session process.

 

[Marco Kalter]

Can you let me know how the "Add column alias list for View DDL" preference is set (Tools > Preferences > Oracle / Options)?

 

[Maxmix]

Marco, it's set to Auto

 

[Marco Kalter]

If you don't have access to the underlying objects of the view, then PL/SQL Developer cannot determine if the view DLL needs a column list. In that case you can set the preference to "Always".

 

[Maxmix]

Nice, it works this way.

But :grin:
I wouldn't say I haven't access to tables, instead the tables are in view owner's schema, SHAL, but PLSD obviously tries to resolve names as if they are owned by the [very powerful] connected user.

Having read in the doc:
"When disabled, PL/SQL Developer will attempt to determine if an alias list is
required"
I wonder, may be it's not so difficult to decide, that CompareUserObjects is exactly the case, when an alias list is required.

Alike concerns might arise with triggers as I think.