Re: catalog.sql et al.

From: dave mausner <dmausner_at_ameritech.x.net>
Date: Tue, 11 Jan 2000 06:11:19 GMT
Message-ID: <8EB81053dlm@206.141.192.241>

bennett_at_cc.gatech.edu (Paul Bennett) wrote in <387AAB4A.2383D7AA_at_cc.gatech.edu>:

>What sql scripts, such as catalog.sql should be run during database
>creation? After running catalog.sql, catproc and catexp, have all the
>object been created that may be used? Is there one master script that
>will create any objects necessary to use any feature of oracle?

catalog, catproc, and catexp are enough for your basic oracle7 and 8. version 7 had a slight flaw that would cause the very last DDL not to be executed; and so extremely old, learned, gray-headed dba's knew to run the scripts in sql*plus and put an extra -- normally unnecessary -- "/" after each "@" invokation.
--
dave mausner (old & learned) Received on Tue Jan 11 2000 - 00:11:19 CST