Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: catalog.sql, catproc.sql and pupbld.sql

Re: catalog.sql, catproc.sql and pupbld.sql

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Wed, 14 Mar 2007 21:05:45 +0100
Message-ID: <et9pif$rui$1@news4.zwoll1.ov.home.nl>


ton de w schreef:
> Hello,
>
> I have an application to install on 9i - it says I must run
> catalog.sql, catproc.sql and pupbld.sql before installing.
> hmmm.
> So how do I know if they have been run before? And if they have been
> run before will running them twice be OK?
>
> The instructions seem a bit old - is it possible I dont have to run
> these scripts on 9i?
> Or 10G? I have an install coming up on 10G!
>
> TIA
>
> Ton
>

The application states the obvious - catproc and catalog run upon creation time - no harm in rerunning, unless you run the wrong version (from a different location, for example...).

pupbld.sql builds a rarely used table, called product_user_profile; it can be used to allow users to use a certain interface. In that case, it may be of interest to your app. The first two are really over the top, and would not only make my eyebrows raise an inch or so, I would seriously doubt the Oracle knowledge of the vendor.

Doesn't it say "Switch on your computer" anywhere <g>

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...
Received on Wed Mar 14 2007 - 15:05:45 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US