Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ALL_DEPENDENCIES isn't updated well

francy77Mar 25 2013 — edited Mar 26 2013
Hi all,
may be i found an oracle error.
SQL> select * from ALL_DEPENDENCIES  where name = 'EMP';

OWNER  NAME TYPE    REFERENCED_OWNER               REFERENC REFERENCE REFERENC DEPENDEN
------ ---- ------- ------------------------------ -------- --------- -------- --------
PUBLIC EMP  SYNONYM HR                             EMP_PKG  PACKAGE            HARD
so this tell me that the type is a SYNONYM, while the following
SQL> select object_name,object_type from user_objects where object_name='EMP';

OBJECT_NAME OBJECT_TYPE
----------- -----------
EMP         TABLE
tell me that this is a table and that is true, is this an oracle bug?

Thanks so much
Francesco
This post has been answered by unknown-7404 on Mar 25 2013
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 23 2013
Added on Mar 25 2013
15 comments
856 views