Please excuse this repost....
Stuck between the horns of a dilemma...
I was puttering around with Microsoft Query one day, and found that one of
the tables that I see normally using SQL*Plus is not listed as a table in
MS-Query and is inaccessible.
When I investigated using SQL*plus I found out that the table I asked for
was in fact a synonym. But the table for which this synonym refers doesn't
exist.
And when I looked using MS-Query for synonyms I couldnt see the synonym I
wanted.
I checked out the FAQ but I couldn't seem to find an answer.
What can I do to see the synonym I'm looking for? Can I convert this
orphaned synonym to a table? Should I not touch this at all?
