Oracle Database Discussions

Oracle 10.2.0.3 on RHEL 4 64bit

Hi gurus,

Quick question: I imported a user from another DB and have got two package bodies, that are in invalid mode. I want to recompile them, but it throws an error that 'table or view doesn't exist'. I'm going through the body of that .. package body :-) and see that it tries to query a table, that belongs to another user.. I'm looking for this table in another schema and see that it exists. So I'm creating a synonym for that table, trying to recompile - the same story (table or view doesn't exist). I'm creating a public synonym - same here. I'm connecting as the user with the invalid packages and trying to do 'select * from that_table' and everything works.. But if i only want to recompile the package body - here comes 00942..

Please, advise what should I do to get this package body recompiled?

Thanks!!