Skip to Main Content

Oracle Database Discussions

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 compile error

ateeqrahmanSep 23 2010 — edited Sep 25 2010
Hi, i did an export from 8.1.7 and imported in 10g. All the tables were imported. I created all the users and gave them necessary grants. when i try to compile synonyms for this schema i imported,I get the following error in enterprise manager:
Failed to compile: ORA-00980: synonym translation is no longer valid
I cannot login to my application with these users even though they have all grants.
I receive the following error:
FRM-40735:PRE-FORM trigger raised unhandled exception ORA-00942
When i click ok, the screen disappears.
This post has been answered by Srini Chavali-Oracle on Sep 25 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 23 2010
Added on Sep 23 2010
5 comments
1,125 views