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

ton de w wrote:
> 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 catalog.sql and catproc.sql scripts are run when the database is created. You can safely re-run these scripts as SYS without causing any problems.

The pupbld.sql script is not run on database creation. IIRC, this script is run as SYSTEM. If you look at the script, you will see that it creates a table called PRODUCT_USER_PROFILE. If this table exists, then you should not need to run the script. If the table does not exist, then run the script as SYSTEM.

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown

-- 
Posted via a free Usenet account from http://www.teranews.com