Re: external sql files

From: F Lange <flange_at_pt.lu>
Date: 1997/09/24
Message-ID: <01bcc91d$f0432ca0$8cd79ac2@fql10>#1/1

Hi,

        you need to execute the catproc.sql file eventually the catrep.sql if you use replication.

        you can run some utl one like utlchain, utlxplain,....

	the cat[0-9]*.sql are there only for migration from a version to an other.
			from 7.1.6 to 7.3.2 for exemple.
			or 7.3.3 to 7.1.6 to add the column and update some value in the

database catalog.

-- 
Regards F. Lange Certified DBA.
29A route du vin.
L5450 Stadtbredimus.
Grand Duchy of Luxembourg.
flqnge_at_pt.lu
(int) 352 697412
(cel) 352 021193652
Phone numbers are variable length.
Luxembourg is a small country of 80 miles on 60 miles between France,
Germany and Belgium.


Pete Desnoyers <peted_at_infi.net> wrote in article
<342938D9.41C6_at_infi.net>...


> 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 Wed Sep 24 1997 - 00:00:00 CDT