Recompiling Invalid Objects

[Amila Fernando]

Hello I have following question to be get explanation on compiling invalid Objects in orale using PL SQL Develpoer -> Tools -> Compile Invalid Objects.

1. Suppose I logged in as oradinary user, and try to compile the Invalid Objects.

then in backgroud will it take the objects from USER_OBJECTS table or DBA_OBJECTS table.

2. I got to know from one oracle developer he faced to a situation where he compiled set of invalid objects using PL SQL Developer and it causes to invalid some more other additional Objects, for instance Packages, is there any reason behind

 

[Theod]

Hi,

if you compile objects, also dependend objects are invalidated.

Here you can find out.

SELECT * FROM user_dependencies
where referenced_name = 'XYZ'
;