synonyms

[chandra517]

hi,
i am getting an error regarding synonyms.
i created a private synonym for a column from a table.
as create synonym <synonym name> for <colname.tablen ame>
to retrieve the column i have given this query.

sql>select <synonymname> from <tablename>;

but i am getting error like this

ERROR at line 1:
ORA-04045: errors during recompilation/revalidation
ORA-00980: synonym translation is no longer valid

plz help me

[rski]

You can not create synonym for a column. You can create synonym for a table.

[debasisdas]

and when you select use this

select column_name from synonym name;