compile objects problem

[Michael Maramzin]

Hi,

"Tools"->"Compile Invalid Objects..." don't compile objects with names starting with underscore. When I run script, where object names enclosed with double quotes, as DBA (see bellow) in command window - all objects recompilled without any problem.

select 'alter view '||t.owner||'."'||t.object_name||'" compile;'
from dba_objects t
where t.object_type = 'VIEW' and t.status = 'INVALID';
>>
alter view SYS."_ALL_REPCOLUMN" compile;
alter view SYS."_ALL_REPCOLUMN_GROUP" compile;
alter view SYS."_ALL_REPCONFLICT" compile;
alter view SYS."_ALL_REPEXTENSIONS" compile;
alter view SYS."_ALL_REPFLAVOR_OBJECTS" compile;
alter view SYS."_ALL_REPGROUPED_COLUMN" compile;

With best regards, Michael Maramzin

 

[Marco Kalter]

Apparently one has to use quotes when an identifier starts with an underscore? We'll check it out.

 

[fraenkg]

this behavior still remains in 11.0.4 connected to oracle 12.1.0.1