Skip to Main Content
Forums

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!

Create synonym name with more than 30 character.

AChatterjeeOct 27 2010 — edited Oct 27 2010
I have created a synonym for a table which is more than 30 character long.
After creating the synonym with create synonym... synonym created message is showing.
but when i am checking in all_objects view that syninym is not available there, and
select * from <synonym_name> also not returtning any rows.

What is the reason for this ? if oracle is showing message like Syninym Created then where its has stored ?

Thanks in Advance...
This post has been answered by BluShadow on Oct 27 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 24 2010
Added on Oct 27 2010
3 comments
2,242 views