Re: Oracle supplied scripts

You should run
catalog.sql and catproc.sql, if you didn't create and/or upgrade your database through the installer. Frequently also catexp.sql seems not to be run automatically.
If all is well, this should be documented in the installation and users guide.
All scripts starting with cat or prvt are called upon by these catalog.sql and catproc.sql. The utl* scripts are documented in the Application Developers Guide.
pupbld.sql is for sqlplus, catdbsyn should be obsolete.

Hth,

Sybrand Bakker, Oracle DBA

tiny anklet bells <nroshak_at_hcs.harvard.edu> wrote in message news:87oblv$gp8$1_at_news.fas.harvard.edu...
> Oracle supplies a bunch of SQL scripts with 8.1.5 -- in
> $ORACLE_HOME/sqlplus/admin and in $ORACLE_HOME/rdbms/admin, for example.
>
> - Where can I find a catalog of these scripts that summarizes what each
> one does? The readmes I've looked through don't seem to document the
> Oracle-supplied scripts, and the docs CD doesn't seem to have this either.
>
> - Which ones should I be running upon creation of a new database? At the
> moment I'm only running catdbsyn.sql and pupbld.sql, but I think I'm
> missing a prerequisite script or two -- I'm getting a lot of 'Public
> synonym to be dropped not found' and 'Object FOO does not exist' errors
> when I run them.
>
> Thanks,
> Natalka Roshak
>
> --
> He stands proud in his uniform
> He knows he's made it now
> He's been told he'll be a hero
> But he hasn't been told how
> He receives his plastic key to heaven
> Takes his holy vow
> Then he turns,
> Then he's gone
> --Peter Ulrich, "Taqaharu's Leaving"
Received on Tue Feb 08 2000 - 03:42:01 CST