Online Tutorials & Training Materials | STechies.com
Register Login

We Run catalog.sql, catproc.sql, pupbld.sql. Why?

Sugandh || 27 Apr 2015 2:21 pm || 1

Hello Experts,

May I know that During manual DB creation we run catalog.sql, catproc.sql, pupbld.sql. Why?

What happend in background ?

Please explain, Thanks in advance.


Comments

  • 06 Oct 2016 4:38 pm Best Answer

    We run these scripts post to the manula creation of database because

    catalog.sql creates all the data dictionary views,

    catproc.sql creates system specified stored procedures

    pupbld.sql creates the default roles and profiles.

    How to run this script

    Go to sql prompt

    ---- --- --- --- 

    sqlplus /nolog

    connect /as sysdba

    SQL>@?/rdbms/admin/catalog.sql

    SQL>@?/rdbms/admin/catproc.sql

    SQL>@?/rdbms/admin/pupbld.sql

    ---- --- --- ---