Re: external sql files

Pete,

I have wondered about this same thing. I can't find a simple list of the scripts and when you run them. Some DBA books and online guides (such as the one offered by www.revealnet.com) describe a few of the most commonly used scripts, but the only thing I've found is to get in there and look at the header comment on each file.

Having looked at a few, I would not advise running each one. For example, catrep.sql states that it runs all sql scripts for the replication option. If you're not using replication, running that script would waste space at the very least, and mess things up in the worst case.

If you find any good source of info, let me know.

Regards,
Ken

Pete Desnoyers wrote:
>
> Is there documentation that describes what .sql files need to be
> executed once an installation is complete? For example, I attempted to
> run server manager and got the following error: maybe catsvrmg.sql not
> run. When you do a directory of
> ...oracle/product/7.3.2/rdbms/admin/cat*sql there is approx. 50 files.
> Do I run all these one by one? There is also many other .sql files. Do
> I run each of these as well? Is there a shell that runs all of them?
>
> thanks everyone!
> --
> >>>>>> Pete <<<<<<
> http://jerry.engrs.infi.net
Received on Fri Sep 26 1997 - 00:00:00 CDT