Database Software

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!

Synonym no longer valid for DUAL Table - error after import

189971May 3 2011 — edited May 9 2011

Hi,
I had successfully completed schema level import in a database, but there where few invalid procedures & function in one specific schema, when I compiled
them, threw out an error on DUAL table, when I used "Select sysdate from dual", the system responded but when I used "Select 1 from dual" threw an error
synonym translation no longer valid, but the other schema in the same DB were able to responded to both the queries.

I really do not understand what the exact issue is all about.

DB-Version
----------------------------------------------------------------
Oracle9i Enterprise Edition Release 9.2.0.8.0 - Production
PL/SQL Release 9.2.0.8.0 - Production
CORE 9.2.0.8.0 Production
TNS for Linux: Version 9.2.0.8.0 - Production
NLSRTL Version 9.2.0.8.0 - Production

help me understand what was the exact issue.

Many Thanks.
Balaji