restoring standard system synonyms...

[R Glenn Stauffer]

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

[Scott Urman]

Running catproc.sql in $ORACLE_HOME/rdbms/admin should recreate any synonyms that
you may need. It runs other scripts, which drop and recreate various data
dictionary objects, including synonyms for them. Be sure to run it as SYS.
There may be other synonyms that you need besides the ones created by this
script, but it ought to catch most of them.