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