Re: restoring standard system synonyms...

In article <32b8ts$5le_at_larch.cc.swarthmore.edu>, stauffer_at_cc.swarthmore.edu (R Glenn Stauffer) writes:
|>
|> 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

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. Received on Wed Aug 10 1994 - 23:10:13 CEST