I was running the dba synonym scripts from the $HOME/dbs/admin directory and
must have run a script that I shouldn't have and this script wiped out the
synonyms on my oracle server.
I am able to restore the application synonyms from a supplied sql script.
However, I am sure that there are others that did not get restored - dual was
one that I caught and fixed. Is there a standard suite of synonyms that is
documented somewhere? Is there an oracle supplied script that will build
these? If so, for both questions, where?
I've looked to no avail.
Thanks,
Glenn Stauffer